SQL Error updating certnames PDB6.22.1

[Chris Hoffman]

Hello,

I'm seeing this error after updating PDB to 6.22.1 and PostgreSQL to 15

ERROR:  trailing junk after parameter at or near "$3A" at character 90
STATEMENT:  UPDATE certnames SET latest_report_id = $1,latest_report_timestamp = $2 WHERE certname = $3AND ( latest_report_timestamp < $4      OR latest_report_timestamp is NULL )

I don't see any relevant bugs in tickets.puppetlabs.com.

Puppet Version 6.27.0

Thanks,

Chris

[Dirk Heinrichs]

Am Mittwoch, dem 30.11.2022 um 07:58 -0800 schrieb Chris Hoffman:

certname = $3AND

Is this a typo or is there really no blank between "$3" and "AND"? If there really isn't one, that would explain it.

Bye...

Dirk

-- 

Dirk Heinrichs

Senior Systems Engineer, Delivery Pipeline

OpenText ™ Discovery | Recommind

Phone: +49 2226 15966 18

Email: dhei...@opentext.com

Website: www.recommind.de

Recommind GmbH, Von-Liebig-Straße 1, 53359 Rheinbach

Vertretungsberechtigte Geschäftsführer Gordon Davies, Madhu Ranganathan, Christian Waida, Registergericht Amtsgericht Bonn, Registernummer HRB 10646

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.

[Chris Hoffman]

Yes, that is the issue... the question is, where is this generated, and how do I fix it.......

[austin...@puppet.com]

We noticed this when attempting to add testing for Postgres 15 and put up a maintenance commit that fixed it https://github.com/puppetlabs/puppetdb/commit/689e4cbae0773363bb9722fad5a8d7f415b00737. The commit message describes the two breaking changes in Postgres 15 that affected PuppetDB (one was a test-only issue), but what you are seeing is a change that made the Postgres query parser more strict and it started rejecting the query given its lack of space between the parameter and the AND clause.

Given the late stage of Puppet Platform 6's lifecycle, we currently only added support for Postgres 15 to PuppetDB 7. There is a Puppet Platform 7 release scheduled soon, so the packages that fix this issue will be available shortly.

- Austin

[Chris Hoffman]

Okay, cool, so I just need to downgrade postrgres, as I don't want to take on a 6->7 upgrade right now.

Thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "Puppet Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/puppet-users/R7uzBTGJFXg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to puppet-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/b81bbbf5-5ad5-45f3-b4dc-00bd14d68ea2n%40googlegroups.com.