java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • The failure seems to occur most often in travis. Below is a snippet from the log {code} lein test puppetlabs.puppetdb.admin-clean-test The [database] classname setting has been retired and will be ignored. The [database] subprotocol setting has been retired and will be ignored. =====v instance log: /tmp/pdb-suppressed1473213189823-3504731248.log 52929 [clojure-agent-send-off-pool-1] ERROR puppetlabs.puppetdb.cli.services - Error while purging deactivated and expired nodes java.sql.SQLException: HikariDataSource HikariDataSource (PDBWritePool) has been closed. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:79) ~[HikariCP-2.4.3.jar:na] at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:281) ~[na:na] at clojure.java.jdbc$get_connection.invoke(jdbc.clj:176) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__17435.invoke(jdbc.clj:304) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415$fn__17416.invoke(jdbc.clj:283) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415.invoke(jdbc.clj:282) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414.invoke(jdbc.clj:273) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invokeStatic(jdbc.clj:303) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:298) ~[na:na] at puppetlabs.puppetdb.cli.services$purge_nodes_BANG_.invokeStatic(services.clj:126) [na:na] at puppetlabs.puppetdb.cli.services$purge_nodes_BANG_.invoke(services.clj:116) [na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849$fn__44853.invoke(services.clj:218) [na:na] at puppetlabs.puppetdb.cli.services.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) [na:na] at com.codahale.metrics.Timer.time(Timer.java:101) [metrics-core-3.1.2.jar:3.1.2] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849.invoke(services.clj:217) [na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845.invoke(services.clj:195) [na:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [clojure-1.8.0.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) [clojure-1.8.0.jar:na] at clojure.core$apply.invokeStatic(core.clj:646) [clojure-1.8.0.jar:na] at clojure.core$apply.invoke(core.clj:641) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin_clean_test$fn__46546$fn__46547$fn__46548$fn__46549.doInvoke(admin_clean_test.clj:73) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invokeStatic(services.clj:239) [na:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invoke(services.clj:233) [na:na] at puppetlabs.puppetdb.cli.services$reify__44999$service_fnk__25918__auto___positional$reify__45008.clean(services.clj:461) [na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44925__44981.invoke(services.clj:406) [na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44924__44986.invoke(services.clj:406) [na:na] at clojure.core$partial$fn__4759.invoke(core.clj:2515) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin$handle_clean_req$fn__45134.invoke(admin.clj:44) [na:na] at clojure.core$binding_conveyor_fn$fn__4676.invoke(core.clj:1938) [clojure-1.8.0.jar:na] at clojure.lang.AFn.call(AFn.java:18) [clojure-1.8.0.jar:na] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_101] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 52963 [clojure-agent-send-off-pool-1] ERROR puppetlabs.puppetdb.cli.services - Error while sweeping reports java.sql.SQLException: HikariDataSource HikariDataSource (PDBWritePool) has been closed. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:79) ~[HikariCP-2.4.3.jar:na] at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:281) ~[na:na] at clojure.java.jdbc$get_connection.invoke(jdbc.clj:176) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__17435.invoke(jdbc.clj:304) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415$fn__17416.invoke(jdbc.clj:283) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415.invoke(jdbc.clj:282) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414.invoke(jdbc.clj:273) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invokeStatic(jdbc.clj:303) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:298) ~[na:na] at puppetlabs.puppetdb.cli.services$sweep_reports_BANG_.invokeStatic(services.clj:140) [na:na] at puppetlabs.puppetdb.cli.services$sweep_reports_BANG_.invoke(services.clj:131) [na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849$fn__44855.invoke(services.clj:222) [na:na] at puppetlabs.puppetdb.cli.services.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) [na:na] at com.codahale.metrics.Timer.time(Timer.java:101) [metrics-core-3.1.2.jar:3.1.2] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849.invoke(services.clj:221) [na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845.invoke(services.clj:195) [na:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [clojure-1.8.0.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) [clojure-1.8.0.jar:na] at clojure.core$apply.invokeStatic(core.clj:646) [clojure-1.8.0.jar:na] at clojure.core$apply.invoke(core.clj:641) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin_clean_test$fn__46546$fn__46547$fn__46548$fn__46549.doInvoke(admin_clean_test.clj:73) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invokeStatic(services.clj:239) [na:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invoke(services.clj:233) [na:na] at puppetlabs.puppetdb.cli.services$reify__44999$service_fnk__25918__auto___positional$reify__45008.clean(services.clj:461) [na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44925__44981.invoke(services.clj:406) [na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44924__44986.invoke(services.clj:406) [na:na] at clojure.core$partial$fn__4759.invoke(core.clj:2515) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin$handle_clean_req$fn__45134.invoke(admin.clj:44) [na:na] at clojure.core$binding_conveyor_fn$fn__4676.invoke(core.clj:1938) [clojure-1.8.0.jar:na] at clojure.lang.AFn.call(AFn.java:18) [clojure-1.8.0.jar:na] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_101] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] 52964 [clojure-agent-send-off-pool-1] ERROR puppetlabs.puppetdb.cli.services - Error during garbage collection java.sql.SQLException: HikariDataSource HikariDataSource (PDBWritePool) has been closed. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:79) ~[HikariCP-2.4.3.jar:na] at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:281) ~[na:na] at clojure.java.jdbc$get_connection.invoke(jdbc.clj:176) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__17435.invoke(jdbc.clj:304) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415$fn__17416.invoke(jdbc.clj:283) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415.invoke(jdbc.clj:282) ~[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414.invoke(jdbc.clj:273) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invokeStatic(jdbc.clj:303) ~[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:298) ~[na:na] at puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__19927.invoke(storage.clj:1388) ~[na:na] at puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) ~[na:na] at com.codahale.metrics.Timer.time(Timer.java:101) [metrics-core-3.1.2.jar:3.1.2] at puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invokeStatic(storage.clj:1386) ~[na:na] at puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invoke(storage.clj:1383) ~[na:na] at puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invokeStatic(services.clj:154) [na:na] at puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invoke(services.clj:145) [na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849$fn__44857.invoke(services.clj:228) [na:na] at puppetlabs.puppetdb.cli.services.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source) [na:na] at com.codahale.metrics.Timer.time(Timer.java:101) [metrics-core-3.1.2.jar:3.1.2] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849.invoke(services.clj:227) [na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845.invoke(services.clj:195) [na:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [clojure-1.8.0.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144) [clojure-1.8.0.jar:na] at clojure.core$apply.invokeStatic(core.clj:646) [clojure-1.8.0.jar:na] at clojure.core$apply.invoke(core.clj:641) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin_clean_test$fn__46546$fn__46547$fn__46548$fn__46549.doInvoke(admin_clean_test.clj:73) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invokeStatic(services.clj:239) [na:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invoke(services.clj:233) [na:na] at puppetlabs.puppetdb.cli.services$reify__44999$service_fnk__25918__auto___positional$reify__45008.clean(services.clj:461) [na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44925__44981.invoke(services.clj:406) [na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44924__44986.invoke(services.clj:406) [na:na] at clojure.core$partial$fn__4759.invoke(core.clj:2515) [clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin$handle_clean_req$fn__45134.invoke(admin.clj:44) [na:na] at clojure.core$binding_conveyor_fn$fn__4676.invoke(core.clj:1938) [clojure-1.8.0.jar:na] at clojure.lang.AFn.call(AFn.java:18) [clojure-1.8.0.jar:na] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_101] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] =====^ instance log: /tmp/pdb-suppressed1473213189823-3504731248.log The [database] classname setting has been retired and will be ignored. The [database] subprotocol setting has been retired and will be ignored. lein test :only puppetlabs.puppetdb.admin-clean-test/admin-clean-status FAIL in (admin-clean-status) (admin_clean_test.clj:43) expected: (= http/status-ok (:status result)) actual: (not (= 200 409)) {:status 409, :headers {"Date" "Wed, 07 Sep 2016 01:53:10 GMT", "Content-Type" "application/json; charset=utf-8", "Connection" "close", "Server" "Jetty(9.2.10.v20150310)"}, :body "{\n \"kind\" : \"conflict\",\n \"msg\" : \"Another cleanup is already in progress\",\n \"details\" : null\n}", :request-time 4, :trace-redirects ["http://localhost:43073/pdb/admin/v1/cmd"], :orig-content-encoding nil} No output has been received in the last 10m0s, this potentially indicates a stalled build or something wrong with the build itself. The build has been terminated {code}
    via by Ryan Senior,
  • Unexpected Behavior with RoutesDSL
    via by Unknown author,
  • Error on server stop
    via GitHub by Eufranio
    ,
    • java.sql.SQLException: HikariDataSource HikariDataSource (PDBWritePool) has been closed. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:79)[HikariCP-2.4.3.jar:na] at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:281)[na:na] at clojure.java.jdbc$get_connection.invoke(jdbc.clj:176)[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__17435.invoke(jdbc.clj:304)[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415$fn__17416.invoke(jdbc.clj:283)[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415.invoke(jdbc.clj:282)[na:na] at puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414.invoke(jdbc.clj:273)[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invokeStatic(jdbc.clj:303)[na:na] at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:298)[na:na] at puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__19927.invoke(storage.clj:1388)[na:na] at puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na] at com.codahale.metrics.Timer.time(Timer.java:101)[metrics-core-3.1.2.jar:3.1.2] at puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invokeStatic(storage.clj:1386)[na:na] at puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invoke(storage.clj:1383)[na:na] at puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invokeStatic(services.clj:154)[na:na] at puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invoke(services.clj:145)[na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849$fn__44857.invoke(services.clj:228)[na:na] at puppetlabs.puppetdb.cli.services.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na] at com.codahale.metrics.Timer.time(Timer.java:101)[metrics-core-3.1.2.jar:3.1.2] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849.invoke(services.clj:227)[na:na] at puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845.invoke(services.clj:195)[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:165)[clojure-1.8.0.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144)[clojure-1.8.0.jar:na] at clojure.core$apply.invokeStatic(core.clj:646)[clojure-1.8.0.jar:na] at clojure.core$apply.invoke(core.clj:641)[clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin_clean_test$fn__46546$fn__46547$fn__46548$fn__46549.doInvoke(admin_clean_test.clj:73)[na:na] at clojure.lang.RestFn.invoke(RestFn.java:457)[clojure-1.8.0.jar:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invokeStatic(services.clj:239)[na:na] at puppetlabs.puppetdb.cli.services$clean_puppetdb.invoke(services.clj:233)[na:na] at puppetlabs.puppetdb.cli.services$reify__44999$service_fnk__25918__auto___positional$reify__45008.clean(services.clj:461)[na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44925__44981.invoke(services.clj:406)[na:na] at puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44924__44986.invoke(services.clj:406)[na:na] at clojure.core$partial$fn__4759.invoke(core.clj:2515)[clojure-1.8.0.jar:na] at puppetlabs.puppetdb.admin$handle_clean_req$fn__45134.invoke(admin.clj:44)[na:na] at clojure.core$binding_conveyor_fn$fn__4676.invoke(core.clj:1938)[clojure-1.8.0.jar:na] at clojure.lang.AFn.call(AFn.java:18)[clojure-1.8.0.jar:na] at java.util.concurrent.FutureTask.run(FutureTask.java:266)[na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_101] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_101] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_101]

    Users with the same issue

    hoangtranworkhoangtranwork
    1 times, last one,
    guizmaiiguizmaii
    1 times, last one,
    chenjunjunchenjunjun
    39 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    1 more bugmates