org.hibernate.exception.JDBCConnectionException

tip

This might be cause due to an overload in your database accesses. Try to implement a queue or using an Executor to access the database server.

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

  • GitHub comment 729#249481722
    via GitHub by njovy
    ,
  • GitHub comment 729#250366236
    via GitHub by njovy
    ,
  • GitHub comment 418#141114687
    via GitHub by Shredder121
    ,
  • HikariCP - connection is not available
    via Stack Overflow by dfche
    ,
  • Hikari connection Timeout Scala SBT 2.11
    via Stack Overflow by Lucas Soares
    ,
    • org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:87)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:109)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1934)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1903)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:925)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.doList(Loader.java:2622)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.doList(Loader.java:2605)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2434)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.Loader.list(Loader.java:2429)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1787)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at models.db.DbModel$Query.byId(DbModel.java:111)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at models.db.chat.Chat.lambda$peerId$0(Chat.java:78)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at utils.JPA.transaction(JPA.java:43)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at utils.JPA.transaction(JPA.java:86)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at models.db.chat.Chat.peerId(Chat.java:77)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at modules.rpc.handler.AuthorizedRancamImpl.sendTextMessage(AuthorizedRancamImpl.java:828)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at com.rancam.models.rpc.AuthorizedRancamGrpc$MethodHandlers.invoke(AuthorizedRancamGrpc.java:2356)[rancam-api.rancam-api-0.1.1.1.jar:0.1.1.1] at io.grpc.stub.ServerCalls$1$1.onHalfClose(ServerCalls.java:150)[io.grpc.grpc-stub-1.0.0.jar:1.0.0] at io.grpc.PartialForwardingServerCallListener.onHalfClose(PartialForwardingServerCallListener.java:48)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.ForwardingServerCallListener.onHalfClose(ForwardingServerCallListener.java:38)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.ForwardingServerCallListener$SimpleForwardingServerCallListener.onHalfClose(ForwardingServerCallListener.java:55)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.Contexts$ContextualizedServerCallListener.onHalfClose(Contexts.java:102)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:260)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$2.runInContext(ServerImpl.java:503)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.ContextRunnable.run(ContextRunnable.java:52)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.SerializingExecutor$TaskRunner.run(SerializingExecutor.java:154)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_74] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_74] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_74] Caused by: java.sql.SQLTransientConnectionException: db-pool - Connection is not available, request timed out after 33289ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:548)[com.zaxxer.HikariCP-2.5.1.jar:na] at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)[com.zaxxer.HikariCP-2.5.1.jar:na] at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:145)[com.zaxxer.HikariCP-2.5.1.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83)[com.zaxxer.HikariCP-2.5.1.jar:na] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:386)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:84)[org.hibernate.hibernate-core-5.1.1.Final.jar:5.1.1.Final] ... 37 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    13 more bugmates