We updated Debian Jessie to Stretch and Puppetdb from 5.2.9 to 5.2.18.
PostgreSQL version remains 9.6 (with a small minor update).
After update PuppetDB is partially broken. Puppet works fine with it, but
if I try to use API, I get an error:
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /pdb/query/v4/resources. Reason:
<pre> Server Error</pre></p><h3>Caused
by:</h3><pre>clojure.lang.ExceptionInfo: Input to paged-sql does not match
schema: [(named (not (instance? java.lang.String a-honeysql.types.SqlRaw))
sql) nil] {:type :schema.core/error, :schema [#schema.core.One{:schema
java.lang.String, :optional? false, :name sql} #schema.core.One{:schema
Any, :optional? false, :name arg1}], :value [#sql/raw " ( SELECT
reports.corrective_change AS latest_report_corrective_change,
certnames.deactivated AS deactivated, certnames.expired AS expired,
reports_environment.environment AS report_environment, certnames.certname
AS certname, fs.timestamp AS facts_timestamp, facts_environment.environment
AS facts_environment, reports.cached_catalog_status AS
cached_catalog_status, report_statuses.status AS latest_report_status,
encode(reports.hash::bytea, 'hex') AS latest_report_hash,
catalogs.timestamp AS catalog_timestamp, reports.noop_pending AS
latest_report_noop_pending, reports.end_time AS report_timestamp,
reports.noop AS latest_report_noop, catalog_environment.environment AS
catalog_environment, reports.job_id AS latest_report_job_id FROM certnames
LEFT JOIN catalogs ON catalogs.certname = certnames.certname LEFT JOIN
factsets fs ON certnames.certname = fs.certname LEFT JOIN reports ON
(certnames.certname = reports.certname AND certnames.latest_report_id =
reports.id) LEFT JOIN environments catalog_environment ON
catalog_environment.id = catalogs.environment_id LEFT JOIN report_statuses
ON reports.status_id = report_statuses.id LEFT JOIN environments
facts_environment ON facts_environment.id = fs.environment_id LEFT JOIN
environments reports_environment ON reports_environment.id =
reports.environment_id WHERE (((certnames.certname) in (SELECT certname
FROM ( (SELECT certnames.certname AS certname FROM factsets fs LEFT JOIN
environments ON fs.environment_id = environments.id LEFT JOIN producers ON
fs.producer_id = producers.id LEFT JOIN certnames ON fs.certname =
certnames.certname WHERE (fs.stable||fs.volatile) @> ?) ) sub)) AND
((certnames.certname) in (SELECT certname FROM ( (SELECT
active_nodes.certname AS certname FROM active_nodes) ) sub))) ) "
{:node-purge-ttl #object[org.joda.time.Period 0x3484bd4a "P14D"],
:limit nil, :offset nil, :order_by ()}], :error [(named (not (instance?
java.lang.String a-honeysql.types.SqlRaw)) sql) nil]}
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/2c1337ca-7586-4e20-9f27-a849e5785889n%40googlegroups.com.
