java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.

Stack Overflow | JulienD | 3 months ago
  1. 0

    Scala play: H2 "HikariDataSource has been closed."

    Stack Overflow | 3 months ago | JulienD
    java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.
  2. 0

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

    Stack Overflow | 4 days ago | sjsp
    java.sql.SQLException: HikariDataSource HikariDataSource (HikariPool-1) has been closed.
  3. 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.*
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.
  6. 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.

  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 (HikariPool-1) has been closed.

    at com.zaxxer.hikari.HikariDataSource.getConnection()
  2. HikariCP-java6
    HikariDataSource.getConnection
    1. com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:79)
    1 frame
  3. Play JDBC
    DefaultDatabase.withConnection
    1. play.api.db.DefaultDatabase.getConnection(Databases.scala:142)
    2. play.api.db.DefaultDatabase.withConnection(Databases.scala:152)
    3. play.api.db.DefaultDatabase.withConnection(Databases.scala:148)
    3 frames
  4. Unknown
    ControllerSpec$$anonfun$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1.apply
    1. ControllerSpec$$anonfun$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1.apply$mcV$sp(ControllerSpec.scala:37)
    2. ControllerSpec$$anonfun$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1.apply(ControllerSpec.scala:37)
    3. ControllerSpec$$anonfun$1$$anonfun$apply$1$$anonfun$apply$mcV$sp$1.apply(ControllerSpec.scala:37)
    3 frames
  5. scalatest
    OutcomeOf$.outcomeOf
    1. org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
    2. org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
    3. org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
    3 frames