java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.

GitHub | darkweaver87 | 7 months ago
tip
Do you find the tips below useful? Click on the to mark them and say thanks to Rafael Fischer Viola . Or join the community to write better ones.
  1. 0

    At lot of users using gitbucket at the same time make it lock

    GitHub | 7 months ago | darkweaver87
    java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  2. 0
    samebug 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.
    via GitHub by njovy
  3. 0

    HikariCP 2.4.3 and 2.4.7 have some Exception

    GitHub | 6 months ago | dengly
    org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HikariCP connection timeout error after certain amount of queries

    Stack Overflow | 3 months ago | Arraying
    java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
  6. 0

    When trying to search 1.6 million groups, Hikari falls apart. {code:java} 00:24:28,248 WARN [Hikari housekeeper (pool HikariPool-1)][HikariPool:611] HikariPool-1 - Unusual system clock change detected, soft-evicting connections from pool. 00:24:28,250 WARN [Hikari housekeeper (pool HikariPool-0)][HikariPool:611] HikariPool-0 - Unusual system clock change detected, soft-evicting connections from pool. Listening for transport dt_socket at address: 8000 00:24:58,290 ERROR [liferay/scheduler_dispatch-3][JDBCExceptionReporter:234] HikariPool-1 - Connection is not available, request timed out after 30000ms. 00:24:58,295 ERROR [liferay/scheduler_dispatch-3][ParallelDestination:55] Unable to process message {destinationName=liferay/scheduler_dispatch, response=null, responseDestinationName=null, responseId=null, payload=null, values={groupId=0, STORAGE_TYPE=MEMORY_CLUSTERED, EXCEPTIONS_MAX_SIZE=0, JOB_NAME=com.liferay.calendar.web.messaging.CheckBookingsMessageListener, GROUP_NAME=com.liferay.calendar.web.messaging.CheckBookingsMessageListener, DESTINATION_NAME=liferay/scheduler_dispatch, JOB_STATE=com.liferay.portal.kernel.scheduler.JobState@27be0def, companyId=0}} com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:32) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:72) at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52) at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756) at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667) at java.lang.Thread.run(Thread.java:745) Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileRankFinderImpl.findByStaleRanks(DLFileRankFinderImpl.java:62) at com.liferay.portlet.documentlibrary.service.impl.DLFileRankLocalServiceImpl.checkFileRanks(DLFileRankLocalServiceImpl.java:77) at sun.reflect.GeneratedMethodAccessor563.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153) at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:84) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127) at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173) at com.sun.proxy.$Proxy199.checkFileRanks(Unknown Source) at com.liferay.recent.documents.web.messaging.RecentDocumentsMessageListener.doReceive(RecentDocumentsMessageListener.java:66) at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26) ... 5 more Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:193) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:172) at com.liferay.portlet.documentlibrary.service.persistence.impl.DLFileRankFinderImpl.findByStaleRanks(DLFileRankFinderImpl.java:59) ... 17 more Caused by: org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2545) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:181) ... 19 more Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:99) at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:400) at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:375) at com.sun.proxy.$Proxy4.prepareStatement(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700) at org.hibernate.loader.Loader.doQuery(Loader.java:801) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2542) ... 26 more {code}

    Liferay Issues | 1 year ago | Brett Swaim
    com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
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.SQLTransientConnectionException

    HikariPool-1 - Connection is not available, request timed out after 30000ms.

    at com.zaxxer.hikari.pool.HikariPool.getConnection()
  2. HikariCP-java6
    HikariDataSource.getConnection
    1. com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
    2. com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:147)
    3. com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83)
    3 frames
  3. SLICK
    JdbcBackend$BaseSession.withTransaction
    1. scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.createConnection(JdbcBackend.scala:47)
    2. scala.slick.jdbc.JdbcBackend$BaseSession.conn$lzycompute(JdbcBackend.scala:397)
    3. scala.slick.jdbc.JdbcBackend$BaseSession.conn(JdbcBackend.scala:397)
    4. scala.slick.jdbc.JdbcBackend$BaseSession.withTransaction(JdbcBackend.scala:420)
    4 frames
  4. scala.slick.backend
    DatabaseComponent$DatabaseDef$class.withSession
    1. scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
    2. scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
    3. scala.slick.backend.DatabaseComponent$DatabaseDef$class.withSession(DatabaseComponent.scala:34)
    3 frames
  5. SLICK
    JdbcBackend$DatabaseFactoryDef$$anon$3.withSession
    1. scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withSession(JdbcBackend.scala:46)
    1 frame
  6. scala.slick.backend
    DatabaseComponent$DatabaseDef$class.withTransaction
    1. scala.slick.backend.DatabaseComponent$DatabaseDef$class.withTransaction(DatabaseComponent.scala:54)
    1 frame
  7. SLICK
    JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction
    1. scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction(JdbcBackend.scala:46)
    1 frame
  8. gitbucket.core.servlet
    TransactionFilter.doFilter
    1. gitbucket.core.servlet.TransactionFilter.doFilter(TransactionFilter.scala:28)
    1 frame
  9. Jetty
    SelectChannelEndPoint$2.run
    1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
    2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
    3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
    5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
    6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1174)
    7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
    8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1106)
    10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    11. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
    12. org.eclipse.jetty.server.Server.handle(Server.java:524)
    13. org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)
    14. org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)
    15. org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
    16. org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
    17. org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
    17 frames
  10. org.eclipse.jetty
    ExecuteProduceConsume.run
    1. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
    2. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
    3. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
    3 frames
  11. Jetty
    QueuedThreadPool$2.run
    1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
    2. org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
    2 frames
  12. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame