Hello,
PuppetDB is partially broken after we upgrade Debian from Jessie to Stretch.
PuppetDB version has been upgraded from 5.2.9 to 5.2.18. We used "apt-get
dist-upgrade" command, no manual setups.
Puppet master works fine with Puppetdb. But, if I try to use API via CURL,
I got:
<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]}
at
puppetlabs.puppetdb.jdbc$eval28778$paged_sql__28783.invoke(jdbc.clj:389)
at
puppetlabs.puppetdb.query_eng.engine$compile_user_query__GT_sql.invokeStatic(engine.clj:2429)
at
puppetlabs.puppetdb.query_eng.engine$compile_user_query__GT_sql.doInvoke(engine.clj:2410)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at
puppetlabs.puppetdb.query_eng$query__GT_sql.invokeStatic(query_eng.clj:115)
at
puppetlabs.puppetdb.query_eng$query__GT_sql.invoke(query_eng.clj:88)
at
puppetlabs.puppetdb.query_eng$eval35521$produce_streaming_body__35526$fn__35527$fn__35530.invoke(query_eng.clj:204)
at
puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__28935$fn__28936.invoke(jdbc.clj:514)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:628)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:598)
at
puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__28935.invoke(jdbc.clj:513)
at
puppetlabs.puppetdb.jdbc$eval28909$retry_sql_STAR___28914$fn__28915$fn__28916.invoke(jdbc.clj:485)
at
puppetlabs.puppetdb.jdbc$eval28909$retry_sql_STAR___28914$fn__28915.invoke(jdbc.clj:484)
at
puppetlabs.puppetdb.jdbc$eval28909$retry_sql_STAR___28914.invoke(jdbc.clj:475)
at
puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invokeStatic(jdbc.clj:511)
at
puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:500)
at
puppetlabs.puppetdb.query_eng$eval35521$produce_streaming_body__35526$fn__35527.invoke(query_eng.clj:200)
at
puppetlabs.puppetdb.query_eng$eval35521$produce_streaming_body__35526.invoke(query_eng.clj:185)
at
puppetlabs.puppetdb.http.query$query_handler$fn__38938.invoke(query.clj:383)
at clojure.core$comp$fn__4727.invoke(core.clj:2460)
at clojure.core$comp$fn__4727.invoke(core.clj:2460)
at compojure.response$eval22875$fn__22876.invoke(response.clj:33)
at
compojure.response$eval22830$fn__22831$G__22821__22838.invoke(response.clj:6)
at
puppetlabs.puppetdb.http.handlers$eval39182$resources_routes__39187$fn__39188$fn__39189.invoke(handlers.clj:201)
at
puppetlabs.puppetdb.http.query$extract_query$fn__38921.invoke(query.clj:315)
at bidi.ring$eval36767$fn__36768.invoke(ring.clj:20)
at bidi.ring$eval36746$fn__36747$G__36737__36756.invoke(ring.clj:12)
at
puppetlabs.puppetdb.middleware$eval38106$make_pdb_handler__38115$fn__38118$fn__38120.invoke(middleware.clj:360)
at
puppetlabs.puppetdb.middleware$wrap_with_illegal_argument_catch$fn__37966.invoke(middleware.clj:101)
at
puppetlabs.puppetdb.middleware$verify_accepts_content_type$fn__37970.invoke(middleware.clj:116)
at
puppetlabs.puppetdb.middleware$verify_content_type$fn__37982.invoke(middleware.clj:146)
at
puppetlabs.puppetdb.middleware$wrap_with_metrics$fn__38027$fn__38036.invoke(middleware.clj:252)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599$fn__35600.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics.proxy$java.lang.Object$Callable$7da976d4.call(Unknown
Source)
at com.codahale.metrics.Timer.time(Timer.java:101)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599$fn__35600.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics.proxy$java.lang.Object$Callable$7da976d4.call(Unknown
Source)
at com.codahale.metrics.Timer.time(Timer.java:101)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599$fn__35600.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics.proxy$java.lang.Object$Callable$7da976d4.call(Unknown
Source)
at com.codahale.metrics.Timer.time(Timer.java:101)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599$fn__35600.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics.proxy$java.lang.Object$Callable$7da976d4.call(Unknown
Source)
at com.codahale.metrics.Timer.time(Timer.java:101)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_$fn__35598$fn__35599.invoke(metrics.clj:14)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_.invokeStatic(metrics.clj:17)
at
puppetlabs.puppetdb.utils.metrics$multitime_BANG__STAR_.invoke(metrics.clj:6)
at
puppetlabs.puppetdb.middleware$wrap_with_metrics$fn__38027.invoke(middleware.clj:251)
at
puppetlabs.puppetdb.middleware$wrap_with_globals$fn__37961.invoke(middleware.clj:95)
at
puppetlabs.puppetdb.http.server$build_app$fn__39636.invoke(server.clj:74)
at compojure.core$routing$fn__24425.invoke(core.clj:151)
at clojure.core$some.invokeStatic(core.clj:2592)
at clojure.core$some.invoke(core.clj:2583)
at compojure.core$routing.invokeStatic(core.clj:151)
at compojure.core$routing.doInvoke(core.clj:148)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at
puppetlabs.puppetdb.pdb_routing$wrap_with_context$fn__50546.invoke(pdb_routing.clj:35)
at compojure.core$if_context$fn__24487.invoke(core.clj:218)
at compojure.core$routing$fn__24425.invoke(core.clj:151)
at clojure.core$some.invokeStatic(core.clj:2592)
at clojure.core$some.invoke(core.clj:2583)
at compojure.core$routing.invokeStatic(core.clj:151)
at compojure.core$routing.doInvoke(core.clj:148)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:648)
at clojure.core$apply.invoke(core.clj:641)
at compojure.core$routes$fn__24429.invoke(core.clj:156)
at compojure.core$routing$fn__24425.invoke(core.clj:151)
at clojure.core$some.invokeStatic(core.clj:2592)
at clojure.core$some.invoke(core.clj:2583)
at compojure.core$routing.invokeStatic(core.clj:151)
at compojure.core$routing.doInvoke(core.clj:148)
at clojure.lang.RestFn.invoke(RestFn.java:460)
at
puppetlabs.puppetdb.pdb_routing$pdb_app$fn__50557.invoke(pdb_routing.clj:63)
at compojure.core$if_context$fn__24487.invoke(core.clj:218)
at
ring.middleware.params$wrap_params$fn__35698.invoke(params.clj:64)
at
puppetlabs.puppetdb.middleware$wrap_with_certificate_cn$fn__37951.invoke(middleware.clj:77)
at
puppetlabs.puppetdb.middleware$wrap_with_default_body$fn__37956.invoke(middleware.clj:84)
at
puppetlabs.puppetdb.middleware$wrap_with_debug_logging$fn__37934.invoke(middleware.clj:41)
at
puppetlabs.i18n.core$locale_negotiator$fn__124.invoke(core.clj:357)
at
puppetlabs.trapperkeeper.services.webserver.jetty9_core$ring_handler$fn__44870.invoke(jetty9_core.clj:434)
at
puppetlabs.trapperkeeper.services.webserver.jetty9_core.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown
Source)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1317)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:205)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1219)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724)
at
org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:56)
at
com.puppetlabs.trapperkeeper.services.webserver.jetty9.utils.MDCRequestLogHandler.handle(MDCRequestLogHandler.java:36)
at
org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:531)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at
org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:762)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:680)
at java.lang.Thread.run(Thread.java:748)
</pre>
I don't know where to look. Thanks for help.
WBR, Eugene
--
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 puppet-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/bde62219-68b4-4580-9294-cfe8390ce7b5n%40googlegroups.com.
