HikariCP icon indicating copy to clipboard operation
HikariCP copied to clipboard

Getting connection timeout error during first Hit if application is idle for long period

Open RahulPaycraft opened this issue 1 year ago • 0 comments

I am using default configuration of Hikari pool and have set maxlifetime as 5 mins

I am getting Following errors ::

  • org.postgresql.util.PSQLException: This connection has been closed.

  • at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:877) ~[postgresql-42.2.23.jar!/:42.2.23]

  • at org.postgresql.jdbc.PgConnection.setNetworkTimeout(PgConnection.java:1610) ~[postgresql-42.2.23.jar!/:42.2.23]

  • at com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:566) ~[HikariCP-4.0.3.jar!/:na]

  • at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:173) ~[HikariCP-4.0.3.jar!/:na]

  • [nio-1025-exec-8] o.h.engine.jdbc.spi.SqlExceptionHelper : This connection has been closed.

  • o.h.engine.jdbc.spi.SqlExceptionHelper : HikariPool-1 - Connection is not available, request timed out after 30036ms.

  • o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 08003

we are using postgre edb database

please check the issue.

RahulPaycraft avatar Aug 02 '22 10:08 RahulPaycraft