javax.persistence.PersistenceException

tip

Check if your MongoDB is available.


rp
tip

host port isnt set

tip

To restart the Selenium Webdriver mock browser in a testcase, first use 'driver.close()' and then reinstantiate the driver.

tip

Firewall might be blocking your connection, or MySQL it's not running on your server machine.


rafael
tip

Check if you have started your server, or if your server is set to listen to the port you're trying to connect and is waiting to accept connections and check if the firewall isn't blocking your connection.


rafael
tip

Check if ip adress is correct, if the port is correct, and if the server is up and running and waiting for connections. Also, check if there's no firewall blocking you and if your internet connection is working.


rafael
tip

spring-data-redis requires redis 2.6+ to work properly.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • talend aodn_mhl_sst failing
    via GitHub by danfruehauf
    ,
  • Console Services dies if it cannot establish a connection to PostgreSQL during startup. This means that a transient database outage can take down the classifier and require manual intervention to restart {{pe-console-services}} as the agent will no longer recieve the {{puppet_enterprise::profile::console}} class which manages the state of this service. As a point of comparison, PuppetDB handles PostgreSQL outages gracefully by waiting for the database to come back online and then re-establishing a connection. h2. Reproduction Case Install a PE 3.7.1 all-in-one master, stop the PostgreSQL database and restart both the PuppetDB and Console Services daemons: {code} # service pe-postgresql stop Stopping pe-postgresql service: [ OK ] # service pe-puppetdb restart Stopping pe-puppetdb: [ OK ] Starting pe-puppetdb: [ OK ] # service pe-console-services restart Stopping pe-console-services: [ OK ] Starting pe-console-services: [ OK ] {code} h3. Outcome PuppetDB will be running, however Console Services will be dead: {code} # service pe-puppetdb status pe-puppetdb (pid 17346) is running... # service pe-console-services status pe-console-services dead but pid file exists {code} The {{/var/log/pe-console-services/console-services.log}} file will show an unhandled exception occurred during initialization which causes the service to proceed to shutdown: {code} 2015-01-07 19:15:17,882 ERROR [p.t.internal] Error during service init!!! org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) ~[console-services-release.jar:na] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) ~[console-services-release.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136) ~[console-services-release.jar:na] at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) ~[console-services-release.jar:na] at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) ~[console-services-release.jar:na] at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) ~[console-services-release.jar:na] at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) ~[console-services-release.jar:na] at org.postgresql.Driver.makeConnection(Driver.java:410) ~[console-services-release.jar:na] at org.postgresql.Driver.connect(Driver.java:280) ~[console-services-release.jar:na] at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[na:1.7.0_71-icedtea] at java.sql.DriverManager.getConnection(DriverManager.java:187) ~[na:1.7.0_71-icedtea] at clojure.java.jdbc.deprecated$get_connection.invoke(deprecated.clj:182) ~[na:na] at clojure.java.jdbc.deprecated$with_connection_STAR_.invoke(deprecated.clj:305) ~[na:na] at migratus.database$eval24631$fn__24632.invoke(database.clj:196) ~[na:na] at clojure.lang.MultiFn.invoke(MultiFn.java:227) ~[console-services-release.jar:na] at migratus.core$migrate.invoke(core.clj:56) ~[na:na] at puppetlabs.rbac.db_utils$migrate_BANG_.invoke(db_utils.clj:37) ~[na:na] at puppetlabs.rbac.services.rbac$reify__22438$service_fnk__5284__auto___positional$reify__22445.init(rbac.clj:92) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5121$G__5112__5124.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5121$G__5111__5128.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:145) ~[na:na] at puppetlabs.trapperkeeper.internal$run_lifecycle_fns.invoke(internal.clj:173) ~[na:na] at puppetlabs.trapperkeeper.internal$build_app_STAR_$reify__5977.init(internal.clj:437) [na:na] at puppetlabs.trapperkeeper.internal$boot_services_STAR_$fn__5989.invoke(internal.clj:463) [na:na] at puppetlabs.trapperkeeper.internal$boot_services_STAR_.invoke(internal.clj:462) [na:na] at puppetlabs.trapperkeeper.core$boot_with_cli_data.invoke(core.clj:113) [na:na] at puppetlabs.trapperkeeper.core$run.invoke(core.clj:144) [na:na] at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [console-services-release.jar:na] at clojure.lang.Var.invoke(Var.java:394) [console-services-release.jar:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [console-services-release.jar:na] at clojure.lang.Var.applyTo(Var.java:700) [console-services-release.jar:na] at clojure.core$apply.invoke(core.clj:624) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main$_main.doInvoke(main.clj:7) [console-services-release.jar:na] at clojure.lang.RestFn.applyTo(RestFn.java:137) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main.main(Unknown Source) [console-services-release.jar:na] Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.7.0_71-icedtea] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) ~[na:1.7.0_71-icedtea] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) ~[na:1.7.0_71-icedtea] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) ~[na:1.7.0_71-icedtea] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.7.0_71-icedtea] at java.net.Socket.connect(Socket.java:579) ~[na:1.7.0_71-icedtea] at java.net.Socket.connect(Socket.java:528) ~[na:1.7.0_71-icedtea] at org.postgresql.core.PGStream.<init>(PGStream.java:60) ~[console-services-release.jar:na] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) ~[console-services-release.jar:na] ... 35 common frames omitted 2015-01-07 19:15:17,893 INFO [p.t.internal] Beginning shutdown sequence 2015-01-07 19:15:17,901 ERROR [p.t.internal] Encountered error during shutdown sequence java.lang.IllegalStateException: Lifecycle function 'stop' for service 'puppetlabs.classifier.main/classifier-service' must return a context map (got: nil) at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:152) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_$fn__5941.invoke(internal.clj:313) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_.invoke(internal.clj:312) [na:na] at puppetlabs.trapperkeeper.core$run_app.invoke(core.clj:133) [na:na] at puppetlabs.trapperkeeper.core$run.invoke(core.clj:148) [na:na] at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [console-services-release.jar:na] at clojure.lang.Var.invoke(Var.java:394) [console-services-release.jar:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [console-services-release.jar:na] at clojure.lang.Var.applyTo(Var.java:700) [console-services-release.jar:na] at clojure.core$apply.invoke(core.clj:624) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main$_main.doInvoke(main.clj:7) [console-services-release.jar:na] at clojure.lang.RestFn.applyTo(RestFn.java:137) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main.main(Unknown Source) [console-services-release.jar:na] 2015-01-07 19:15:17,907 INFO [p.t.s.w.jetty9-service] Shutting down web server(s). 2015-01-07 19:15:17,909 ERROR [p.t.internal] Encountered error during shutdown sequence java.lang.NullPointerException: null at clojure.lang.Reflector.invokeNoArgInstanceMember(Reflector.java:301) ~[console-services-release.jar:na] at puppetlabs.rbac.services.rbac$reify__22438$service_fnk__5284__auto___positional$reify__22445.stop(rbac.clj:113) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5147$G__5108__5150.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5147$G__5107__5154.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:145) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_$fn__5941.invoke(internal.clj:313) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_.invoke(internal.clj:312) [na:na] at puppetlabs.trapperkeeper.core$run_app.invoke(core.clj:133) [na:na] at puppetlabs.trapperkeeper.core$run.invoke(core.clj:148) [na:na] at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [console-services-release.jar:na] at clojure.lang.Var.invoke(Var.java:394) [console-services-release.jar:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [console-services-release.jar:na] at clojure.lang.Var.applyTo(Var.java:700) [console-services-release.jar:na] at clojure.core$apply.invoke(core.clj:624) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main$_main.doInvoke(main.clj:7) [console-services-release.jar:na] at clojure.lang.RestFn.applyTo(RestFn.java:137) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main.main(Unknown Source) [console-services-release.jar:na] 2015-01-07 19:15:17,911 INFO [p.t.internal] Finished shutdown sequence {code} By contrast, PuppetDB stays up and waits for the database to come up. The {{/var/log/pe-puppetdb/pe-puppetdb.log}} log file shows: {code} 2015-01-07 19:24:32,947 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 3. Exception: java.net.ConnectException: Connection refused {code} h3. Expected Outcome Console Services behaves similar to PuppetDB and successfully starts up if PostgreSQL is not running. Instead of shutting down, Console Services should remain up and wait for the database.
    via by Charlie Sharpsteen,
  • Console Services dies if it cannot establish a connection to PostgreSQL during startup. This means that a transient database outage can take down the classifier and require manual intervention to restart {{pe-console-services}} as the agent will no longer recieve the {{puppet_enterprise::profile::console}} class which manages the state of this service. As a point of comparison, PuppetDB handles PostgreSQL outages gracefully by waiting for the database to come back online and then re-establishing a connection. h2. Reproduction Case Install a PE 3.7.1 all-in-one master, stop the PostgreSQL database and restart both the PuppetDB and Console Services daemons: {code} # service pe-postgresql stop Stopping pe-postgresql service: [ OK ] # service pe-puppetdb restart Stopping pe-puppetdb: [ OK ] Starting pe-puppetdb: [ OK ] # service pe-console-services restart Stopping pe-console-services: [ OK ] Starting pe-console-services: [ OK ] {code} h3. Outcome PuppetDB will be running, however Console Services will be dead: {code} # service pe-puppetdb status pe-puppetdb (pid 17346) is running... # service pe-console-services status pe-console-services dead but pid file exists {code} The {{/var/log/pe-console-services/console-services.log}} file will show an unhandled exception occurred during initialization which causes the service to proceed to shutdown: {code} 2015-01-07 19:15:17,882 ERROR [p.t.internal] Error during service init!!! org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) ~[console-services-release.jar:na] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) ~[console-services-release.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136) ~[console-services-release.jar:na] at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) ~[console-services-release.jar:na] at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) ~[console-services-release.jar:na] at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) ~[console-services-release.jar:na] at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) ~[console-services-release.jar:na] at org.postgresql.Driver.makeConnection(Driver.java:410) ~[console-services-release.jar:na] at org.postgresql.Driver.connect(Driver.java:280) ~[console-services-release.jar:na] at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[na:1.7.0_71-icedtea] at java.sql.DriverManager.getConnection(DriverManager.java:187) ~[na:1.7.0_71-icedtea] at clojure.java.jdbc.deprecated$get_connection.invoke(deprecated.clj:182) ~[na:na] at clojure.java.jdbc.deprecated$with_connection_STAR_.invoke(deprecated.clj:305) ~[na:na] at migratus.database$eval24631$fn__24632.invoke(database.clj:196) ~[na:na] at clojure.lang.MultiFn.invoke(MultiFn.java:227) ~[console-services-release.jar:na] at migratus.core$migrate.invoke(core.clj:56) ~[na:na] at puppetlabs.rbac.db_utils$migrate_BANG_.invoke(db_utils.clj:37) ~[na:na] at puppetlabs.rbac.services.rbac$reify__22438$service_fnk__5284__auto___positional$reify__22445.init(rbac.clj:92) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5121$G__5112__5124.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5121$G__5111__5128.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:145) ~[na:na] at puppetlabs.trapperkeeper.internal$run_lifecycle_fns.invoke(internal.clj:173) ~[na:na] at puppetlabs.trapperkeeper.internal$build_app_STAR_$reify__5977.init(internal.clj:437) [na:na] at puppetlabs.trapperkeeper.internal$boot_services_STAR_$fn__5989.invoke(internal.clj:463) [na:na] at puppetlabs.trapperkeeper.internal$boot_services_STAR_.invoke(internal.clj:462) [na:na] at puppetlabs.trapperkeeper.core$boot_with_cli_data.invoke(core.clj:113) [na:na] at puppetlabs.trapperkeeper.core$run.invoke(core.clj:144) [na:na] at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [console-services-release.jar:na] at clojure.lang.Var.invoke(Var.java:394) [console-services-release.jar:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [console-services-release.jar:na] at clojure.lang.Var.applyTo(Var.java:700) [console-services-release.jar:na] at clojure.core$apply.invoke(core.clj:624) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main$_main.doInvoke(main.clj:7) [console-services-release.jar:na] at clojure.lang.RestFn.applyTo(RestFn.java:137) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main.main(Unknown Source) [console-services-release.jar:na] Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.7.0_71-icedtea] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) ~[na:1.7.0_71-icedtea] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) ~[na:1.7.0_71-icedtea] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) ~[na:1.7.0_71-icedtea] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.7.0_71-icedtea] at java.net.Socket.connect(Socket.java:579) ~[na:1.7.0_71-icedtea] at java.net.Socket.connect(Socket.java:528) ~[na:1.7.0_71-icedtea] at org.postgresql.core.PGStream.<init>(PGStream.java:60) ~[console-services-release.jar:na] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) ~[console-services-release.jar:na] ... 35 common frames omitted 2015-01-07 19:15:17,893 INFO [p.t.internal] Beginning shutdown sequence 2015-01-07 19:15:17,901 ERROR [p.t.internal] Encountered error during shutdown sequence java.lang.IllegalStateException: Lifecycle function 'stop' for service 'puppetlabs.classifier.main/classifier-service' must return a context map (got: nil) at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:152) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_$fn__5941.invoke(internal.clj:313) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_.invoke(internal.clj:312) [na:na] at puppetlabs.trapperkeeper.core$run_app.invoke(core.clj:133) [na:na] at puppetlabs.trapperkeeper.core$run.invoke(core.clj:148) [na:na] at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [console-services-release.jar:na] at clojure.lang.Var.invoke(Var.java:394) [console-services-release.jar:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [console-services-release.jar:na] at clojure.lang.Var.applyTo(Var.java:700) [console-services-release.jar:na] at clojure.core$apply.invoke(core.clj:624) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main$_main.doInvoke(main.clj:7) [console-services-release.jar:na] at clojure.lang.RestFn.applyTo(RestFn.java:137) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main.main(Unknown Source) [console-services-release.jar:na] 2015-01-07 19:15:17,907 INFO [p.t.s.w.jetty9-service] Shutting down web server(s). 2015-01-07 19:15:17,909 ERROR [p.t.internal] Encountered error during shutdown sequence java.lang.NullPointerException: null at clojure.lang.Reflector.invokeNoArgInstanceMember(Reflector.java:301) ~[console-services-release.jar:na] at puppetlabs.rbac.services.rbac$reify__22438$service_fnk__5284__auto___positional$reify__22445.stop(rbac.clj:113) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5147$G__5108__5150.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.services$eval5120$fn__5147$G__5107__5154.invoke(services.clj:12) ~[na:na] at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:145) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_$fn__5941.invoke(internal.clj:313) ~[na:na] at puppetlabs.trapperkeeper.internal$shutdown_BANG_.invoke(internal.clj:312) [na:na] at puppetlabs.trapperkeeper.core$run_app.invoke(core.clj:133) [na:na] at puppetlabs.trapperkeeper.core$run.invoke(core.clj:148) [na:na] at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159) [na:na] at clojure.lang.RestFn.invoke(RestFn.java:457) [console-services-release.jar:na] at clojure.lang.Var.invoke(Var.java:394) [console-services-release.jar:na] at clojure.lang.AFn.applyToHelper(AFn.java:165) [console-services-release.jar:na] at clojure.lang.Var.applyTo(Var.java:700) [console-services-release.jar:na] at clojure.core$apply.invoke(core.clj:624) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main$_main.doInvoke(main.clj:7) [console-services-release.jar:na] at clojure.lang.RestFn.applyTo(RestFn.java:137) [console-services-release.jar:na] at puppetlabs.trapperkeeper.main.main(Unknown Source) [console-services-release.jar:na] 2015-01-07 19:15:17,911 INFO [p.t.internal] Finished shutdown sequence {code} By contrast, PuppetDB stays up and waits for the database to come up. The {{/var/log/pe-puppetdb/pe-puppetdb.log}} log file shows: {code} 2015-01-07 19:24:32,947 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 3. Exception: java.net.ConnectException: Connection refused {code} h3. Expected Outcome Console Services behaves similar to PuppetDB and successfully starts up if PostgreSQL is not running. Instead of shutting down, Console Services should remain up and wait for the database.
    via by Charlie Sharpsteen,
    • javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:273)[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final] at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryInTransaction(JPATaskPersistenceContext.java:421)[jbpm-human-task-jpa-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.commands.InitDeadlinesCommand.execute(InitDeadlinesCommand.java:52)[jbpm-human-task-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.commands.InitDeadlinesCommand.execute(InitDeadlinesCommand.java:33)[jbpm-human-task-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)[jbpm-human-task-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:69)[jbpm-human-task-jpa-6.4.0.Beta1.jar:6.4.0.Beta1] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73)[drools-persistence-jpa-6.4.0.Beta1.jar:6.4.0.Beta1] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82)[drools-persistence-jpa-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)[jbpm-human-task-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.impl.TaskDeadlinesServiceImpl.initialize(TaskDeadlinesServiceImpl.java:367)[jbpm-human-task-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.services.task.HumanTaskConfigurator.getTaskService(HumanTaskConfigurator.java:157)[jbpm-human-task-core-6.4.0.Beta1.jar:6.4.0.Beta1] at org.jbpm.vertx.VerticleServiceProvider.configureServices(VerticleServiceProvider.java:161)[__vertx~e90ebbed-eb74-4894-b19a-1d48034ff951~__vertx/:na] at org.jbpm.vertx.VerticleServiceProvider.<init>(VerticleServiceProvider.java:72)[__vertx~e90ebbed-eb74-4894-b19a-1d48034ff951~__vertx/:na] at org.jbpm.vertx.VerticleServiceProvider.configure(VerticleServiceProvider.java:46)[__vertx~e90ebbed-eb74-4894-b19a-1d48034ff951~__vertx/:na] at org.jbpm.vertx.JbpmVerticle.start(JbpmVerticle.java:48)[__vertx~e90ebbed-eb74-4894-b19a-1d48034ff951~__vertx/:na] at org.vertx.java.platform.Verticle.start(Verticle.java:82)[vertx-platform-2.1.5.jar:na] at org.vertx.java.platform.impl.DefaultPlatformManager$21.run(DefaultPlatformManager.java:1758)[vertx-platform-2.1.5.jar:na] at org.vertx.java.core.impl.DefaultContext$3.run(DefaultContext.java:175)[vertx-core-2.1.5.jar:na] at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:370)[netty-all-4.0.21.Final.jar:4.0.21.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)[netty-all-4.0.21.Final.jar:4.0.21.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)[netty-all-4.0.21.Final.jar:4.0.21.Final] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_45] Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:56)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:161)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:159)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1854)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1831)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:899)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.doList(Loader.java:2516)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.doList(Loader.java:2502)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2332)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.Loader.list(Loader.java:2327)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1268)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264)[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final] ... 24 more Caused by: java.sql.SQLException: unable to get a connection from pool of a PoolingDataSource containing an XAPool of resource jdbc/jbpm with 0 connection(s) (0 still available) -failed- at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:262)[btm-2.1.4.jar:2.1.4] at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)[hibernate-core-4.2.0.Final.jar:4.2.0.Final] ... 44 more Caused by: bitronix.tm.internal.BitronixRuntimeException: incremental recovery failed when trying to acquire a connection from failed resource 'jdbc/jbpm' at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:103)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:91)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingDataSource.java:258)[btm-2.1.4.jar:2.1.4] ... 47 more Caused by: bitronix.tm.recovery.RecoveryException: cannot start recovery on a PoolingDataSource containing an XAPool of resource jdbc/jbpm with 0 connection(s) (0 still available) at bitronix.tm.resource.jdbc.PoolingDataSource.startRecovery(PoolingDataSource.java:288)[btm-2.1.4.jar:2.1.4] at bitronix.tm.recovery.IncrementalRecoverer.recover(IncrementalRecoverer.java:61)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:100)[btm-2.1.4.jar:2.1.4] ... 49 more Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.Driver.makeConnection(Driver.java:393)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.Driver.connect(Driver.java:267)[postgresql-9.2-1003-jdbc4.jar:na] at java.sql.DriverManager.getConnection(DriverManager.java:664)[na:1.8.0_45] at java.sql.DriverManager.getConnection(DriverManager.java:247)[na:1.8.0_45] at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:97)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.xa.jdbc3.AbstractJdbc3XADataSource.getXAConnection(AbstractJdbc3XADataSource.java:54)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.xa.jdbc3.AbstractJdbc3XADataSource.getXAConnection(AbstractJdbc3XADataSource.java:39)[postgresql-9.2-1003-jdbc4.jar:na] at bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(PoolingDataSource.java:341)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:283)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.common.XAPool.grow(XAPool.java:391)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.common.XAPool.getInPool(XAPool.java:371)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:123)[btm-2.1.4.jar:2.1.4] at bitronix.tm.resource.jdbc.PoolingDataSource.startRecovery(PoolingDataSource.java:284)[btm-2.1.4.jar:2.1.4] ... 51 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method)[na:1.8.0_45] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)[na:1.8.0_45] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)[na:1.8.0_45] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)[na:1.8.0_45] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)[na:1.8.0_45] at java.net.Socket.connect(Socket.java:589)[na:1.8.0_45] at java.net.Socket.connect(Socket.java:538)[na:1.8.0_45] at org.postgresql.core.PGStream.<init>(PGStream.java:60)[postgresql-9.2-1003-jdbc4.jar:na] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)[postgresql-9.2-1003-jdbc4.jar:na] ... 70 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Eric Henderson
    16 times, last one,
    Unknown User
    2 times, last one,
    Tahir
    6 times, last one,
    Unknown visitor1 times, last one,
    479 more bugmates