Skip to content

Instantly share code, notes, and snippets.

@xorpaul
Created January 2, 2015 16:58
Show Gist options
  • Select an option

  • Save xorpaul/ba0573fe2245abd407f9 to your computer and use it in GitHub Desktop.

Select an option

Save xorpaul/ba0573fe2245abd407f9 to your computer and use it in GitHub Desktop.
PuppetDB 1.6.3 Garbace collection stack trace
2014-10-05 12:37:23,333 ERROR [pool-3-thread-3] [cli.services] Error during garbage collection
java.sql.BatchUpdateException: Batch entry 0 DELETE FROM resource_params_cache WHERE NOT EXISTS (SELECT * FROM catalog_resources cr WHERE cr.resource=resource_params_cache.resource) was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:457)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469)
at clojure.java.jdbc.internal$do_prepared_STAR_$fn__2140.invoke(internal.clj:356)
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223)
at clojure.java.jdbc.internal$do_prepared_STAR_.doInvoke(internal.clj:356)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at clojure.java.jdbc$delete_rows.invoke(jdbc.clj:297)
at com.puppetlabs.puppetdb.scf.storage$delete_unassociated_params_BANG_$fn__3714.invoke(storage.clj:666)
at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$f8c5758f.call(Unknown Source)
at com.yammer.metrics.core.Timer.time(Timer.java:91)
at com.puppetlabs.puppetdb.scf.storage$delete_unassociated_params_BANG_.invoke(storage.clj:665)
at com.puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__3718$fn__3719.invoke(storage.clj:673)
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223)
at com.puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__3718.invoke(storage.clj:672)
at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$f8c5758f.call(Unknown Source)
at com.yammer.metrics.core.Timer.time(Timer.java:91)
at com.puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invoke(storage.clj:671)
at com.puppetlabs.puppetdb.cli.services$garbage_collect_BANG_$fn__12778.invoke(services.clj:165)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__2278$fn__2279.invoke(jdbc.clj:229)
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__2278.invoke(jdbc.clj:228)
at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186)
at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:225)
at com.puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invoke(services.clj:164)
at com.puppetlabs.puppetdb.cli.services$perform_db_maintenance_BANG_.doInvoke(services.clj:177)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invoke(core.clj:619)
at com.puppetlabs.puppetdb.cli.services$_main$fn__12842.invoke(services.clj:316)
at clojure.lang.AFn.run(AFn.java:24)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment