Skip to content

Instantly share code, notes, and snippets.

@llowder
Last active August 29, 2015 14:21
Show Gist options
  • Save llowder/92bb4903b84c10b12603 to your computer and use it in GitHub Desktop.
Save llowder/92bb4903b84c10b12603 to your computer and use it in GitHub Desktop.
2015-05-15 18:02:09,078 ERROR [c.p.p.c.services] Error while sweeping reports
java.sql.BatchUpdateException: Batch entry 0 DELETE FROM reports WHERE end_time < '2015-05-01 18:02:08.982000 +02:00:00' was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:457) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405) ~[puppetdb.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893) ~[puppetdb.jar:na]
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[puppetdb.jar:na]
at clojure.java.jdbc.internal$do_prepared_STAR_$fn__6350.invoke(internal.clj:356) ~[na:na]
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na]
at clojure.java.jdbc.internal$do_prepared_STAR_.doInvoke(internal.clj:356) ~[na:na]
at clojure.lang.RestFn.invoke(RestFn.java:423) [puppetdb.jar:na]
at clojure.java.jdbc$delete_rows.invoke(jdbc.clj:297) ~[na:na]
at com.puppetlabs.puppetdb.scf.storage$delete_reports_older_than_BANG_.invoke(storage.clj:1145) ~[na:na]
at com.puppetlabs.puppetdb.cli.services$sweep_reports_BANG_$fn__19176.invoke(services.clj:140) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290) ~[na:na]
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290) ~[na:na]
at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287) ~[na:na]
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259) ~[na:na]
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258) ~[na:na]
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286) ~[na:na]
at com.puppetlabs.puppetdb.cli.services$sweep_reports_BANG_.invoke(services.clj:139) ~[na:na]
at clojure.lang.AFn.applyToHelper(AFn.java:156) [puppetdb.jar:na]
at clojure.lang.AFn.applyTo(AFn.java:144) [puppetdb.jar:na]
at clojure.core$apply.invoke(core.clj:626) [puppetdb.jar:na]
at clojure.core$partial$fn__4228.doInvoke(core.clj:2468) [puppetdb.jar:na]
at clojure.lang.RestFn.invoke(RestFn.java:408) [puppetdb.jar:na]
at com.puppetlabs.puppetdb.cli.services$perform_db_maintenance_BANG_.doInvoke(services.clj:177) [na:na]
at clojure.lang.RestFn.applyTo(RestFn.java:139) [puppetdb.jar:na]
at clojure.core$apply.invoke(core.clj:626) [puppetdb.jar:na]
at com.puppetlabs.puppetdb.cli.services$start_puppetdb$fn__19276.invoke(services.clj:347) [na:na]
at clojure.lang.AFn.run(AFn.java:22) [puppetdb.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_71-icedtea]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [na:1.7.0_71-icedtea]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_71-icedtea]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_71-icedtea]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_71-icedtea]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_71-icedtea]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71-icedtea]
2015-05-15 18:01:11,925 ERROR [c.j.b.PoolWatchThread] Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: the database system is starting up
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:398) ~[puppetdb.jar:na]
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:173) ~[puppetdb.jar:na]
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) ~[puppetdb.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136) ~[puppetdb.jar:na]
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) ~[puppetdb.jar:na]
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) ~[puppetdb.jar:na]
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) ~[puppetdb.jar:na]
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) ~[puppetdb.jar:na]
at org.postgresql.Driver.makeConnection(Driver.java:393) ~[puppetdb.jar:na]
at org.postgresql.Driver.connect(Driver.java:267) ~[puppetdb.jar:na]
at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[na:1.7.0_71-icedtea]
at java.sql.DriverManager.getConnection(DriverManager.java:215) ~[na:1.7.0_71-icedtea]
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256) ~[puppetdb.jar:na]
at com.jolbox.bonecp.ConnectionHandle.obtainInternalConnection(ConnectionHandle.java:211) ~[puppetdb.jar:na]
at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:170) ~[puppetdb.jar:na]
at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:101) [puppetdb.jar:na]
at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82) [puppetdb.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_71-icedtea]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_71-icedtea]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71-icedtea]
2015-05-15 18:02:09,260 ERROR [c.p.p.c.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) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:457) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887) ~[puppetdb.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405) ~[puppetdb.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893) ~[puppetdb.jar:na]
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[puppetdb.jar:na]
at clojure.java.jdbc.internal$do_prepared_STAR_$fn__6350.invoke(internal.clj:356) ~[na:na]
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na]
at clojure.java.jdbc.internal$do_prepared_STAR_.doInvoke(internal.clj:356) ~[na:na]
at clojure.lang.RestFn.invoke(RestFn.java:423) [puppetdb.jar:na]
at clojure.java.jdbc$delete_rows.invoke(jdbc.clj:297) ~[na:na]
at com.puppetlabs.puppetdb.scf.storage$delete_unassociated_params_BANG_$fn__9696.invoke(storage.clj:740) ~[na:na]
at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na]
at com.yammer.metrics.core.Timer.time(Timer.java:91) ~[puppetdb.jar:na]
at com.puppetlabs.puppetdb.scf.storage$delete_unassociated_params_BANG_.invoke(storage.clj:739) ~[na:na]
at com.puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__9708$fn__9709.invoke(storage.clj:767) ~[na:na]
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) ~[na:na]
at com.puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__9708.invoke(storage.clj:766) ~[na:na]
at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na]
at com.yammer.metrics.core.Timer.time(Timer.java:91) ~[puppetdb.jar:na]
at com.puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invoke(storage.clj:765) ~[na:na]
at com.puppetlabs.puppetdb.cli.services$garbage_collect_BANG_$fn__19190.invoke(services.clj:165) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290) ~[na:na]
at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290) ~[na:na]
at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287) ~[na:na]
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259) ~[na:na]
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258) ~[na:na]
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250) ~[na:na]
at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286) ~[na:na]
at com.puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invoke(services.clj:164) ~[na:na]
at com.puppetlabs.puppetdb.cli.services$perform_db_maintenance_BANG_.doInvoke(services.clj:177) [na:na]
at clojure.lang.RestFn.applyTo(RestFn.java:139) [puppetdb.jar:na]
at clojure.core$apply.invoke(core.clj:626) [puppetdb.jar:na]
at com.puppetlabs.puppetdb.cli.services$start_puppetdb$fn__19276.invoke(services.clj:347) [na:na]
at clojure.lang.AFn.run(AFn.java:22) [puppetdb.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_71-icedtea]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [na:1.7.0_71-icedtea]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_71-icedtea]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_71-icedtea]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_71-icedtea]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_71-icedtea]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71-icedtea]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment