java.sql.SQLException: HikariDataSource HikariDataSource (PDBWritePool) has been closed.

JIRA | Ryan Senior | 3 months ago
  1. 0

    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}

    JIRA | 3 months ago | Ryan Senior
    java.sql.SQLException: HikariDataSource HikariDataSource (PDBWritePool) has been closed.
  2. 0

    Issues migrating from Play 2.4.6 to Play 2.5.3 - HikariDataSource HikariDataSource (default-xxxx-hikaricp) has been closed.

    Google Groups | 7 months ago | SM
    java.sql.SQLException: HikariDataSource HikariDataSource (default-xxxx-hikaricp) has been closed.*
  3. 0

    Scala play: H2 "HikariDataSource has been closed."

    Stack Overflow | 3 months ago | JulienD
    java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Play Framework HikariDataSource has been closed

    Stack Overflow | 1 week ago | Jared Loomis
    javax.persistence.PersistenceException: java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-7) has been closed.
  6. 0

    HikariDataSource getConnection fails saying pool is closed eventhough close was never called

    Stack Overflow | 3 days ago | sjsp
    java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.

  1. hoangtranwork 1 times, last 7 months ago
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    HikariDataSource HikariDataSource (PDBWritePool) has been closed.

    at com.zaxxer.hikari.HikariDataSource.getConnection()
  2. HikariCP-java6
    HikariDataSource.getConnection
    1. com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:79)[HikariCP-2.4.3.jar:na]
    1 frame
  3. Clojure
    jdbc$get_connection.invoke
    1. clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:281)[na:na]
    2. clojure.java.jdbc$get_connection.invoke(jdbc.clj:176)[na:na]
    2 frames
  4. puppetlabs.puppetdb
    jdbc$with_transacted_connection_fn.invoke
    1. puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__17435.invoke(jdbc.clj:304)[na:na]
    2. puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415$fn__17416.invoke(jdbc.clj:283)[na:na]
    3. puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414$fn__17415.invoke(jdbc.clj:282)[na:na]
    4. puppetlabs.puppetdb.jdbc$eval17409$retry_sql_STAR___17414.invoke(jdbc.clj:273)[na:na]
    5. puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invokeStatic(jdbc.clj:303)[na:na]
    6. puppetlabs.puppetdb.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:298)[na:na]
    6 frames
  5. puppetlabs.puppetdb.scf
    Object$Callable$7da976d4.call
    1. puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_$fn__19927.invoke(storage.clj:1388)[na:na]
    2. puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na]
    2 frames
  6. Metrics Core
    Timer.time
    1. com.codahale.metrics.Timer.time(Timer.java:101)[metrics-core-3.1.2.jar:3.1.2]
    1 frame
  7. puppetlabs.puppetdb.scf
    storage$garbage_collect_BANG_.invoke
    1. puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invokeStatic(storage.clj:1386)[na:na]
    2. puppetlabs.puppetdb.scf.storage$garbage_collect_BANG_.invoke(storage.clj:1383)[na:na]
    2 frames
  8. puppetlabs.puppetdb.cli
    Object$Callable$7da976d4.call
    1. puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invokeStatic(services.clj:154)[na:na]
    2. puppetlabs.puppetdb.cli.services$garbage_collect_BANG_.invoke(services.clj:145)[na:na]
    3. puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849$fn__44857.invoke(services.clj:228)[na:na]
    4. puppetlabs.puppetdb.cli.services.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na]
    4 frames
  9. Metrics Core
    Timer.time
    1. com.codahale.metrics.Timer.time(Timer.java:101)[metrics-core-3.1.2.jar:3.1.2]
    1 frame
  10. puppetlabs.puppetdb.cli
    services$eval44840$clean_up__44845.invoke
    1. puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845$fn__44849.invoke(services.clj:227)[na:na]
    2. puppetlabs.puppetdb.cli.services$eval44840$clean_up__44845.invoke(services.clj:195)[na:na]
    2 frames
  11. Clojure
    core$apply.invoke
    1. clojure.lang.AFn.applyToHelper(AFn.java:165)[clojure-1.8.0.jar:na]
    2. clojure.lang.AFn.applyTo(AFn.java:144)[clojure-1.8.0.jar:na]
    3. clojure.core$apply.invokeStatic(core.clj:646)[clojure-1.8.0.jar:na]
    4. clojure.core$apply.invoke(core.clj:641)[clojure-1.8.0.jar:na]
    4 frames
  12. puppetlabs.puppetdb
    admin_clean_test$fn__46546$fn__46547$fn__46548$fn__46549.doInvoke
    1. puppetlabs.puppetdb.admin_clean_test$fn__46546$fn__46547$fn__46548$fn__46549.doInvoke(admin_clean_test.clj:73)[na:na]
    1 frame
  13. Clojure
    RestFn.invoke
    1. clojure.lang.RestFn.invoke(RestFn.java:457)[clojure-1.8.0.jar:na]
    1 frame
  14. puppetlabs.puppetdb.cli
    services$eval44933$fn__44977$G__44924__44986.invoke
    1. puppetlabs.puppetdb.cli.services$clean_puppetdb.invokeStatic(services.clj:239)[na:na]
    2. puppetlabs.puppetdb.cli.services$clean_puppetdb.invoke(services.clj:233)[na:na]
    3. puppetlabs.puppetdb.cli.services$reify__44999$service_fnk__25918__auto___positional$reify__45008.clean(services.clj:461)[na:na]
    4. puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44925__44981.invoke(services.clj:406)[na:na]
    5. puppetlabs.puppetdb.cli.services$eval44933$fn__44977$G__44924__44986.invoke(services.clj:406)[na:na]
    5 frames
  15. Clojure
    core$partial$fn__4759.invoke
    1. clojure.core$partial$fn__4759.invoke(core.clj:2515)[clojure-1.8.0.jar:na]
    1 frame
  16. puppetlabs.puppetdb
    admin$handle_clean_req$fn__45134.invoke
    1. puppetlabs.puppetdb.admin$handle_clean_req$fn__45134.invoke(admin.clj:44)[na:na]
    1 frame
  17. Clojure
    AFn.call
    1. clojure.core$binding_conveyor_fn$fn__4676.invoke(core.clj:1938)[clojure-1.8.0.jar:na]
    2. clojure.lang.AFn.call(AFn.java:18)[clojure-1.8.0.jar:na]
    2 frames
  18. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:266)[na:1.8.0_101]
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_101]
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_101]
    4. java.lang.Thread.run(Thread.java:745)[na:1.8.0_101]
    4 frames