HikariCP
HikariCP copied to clipboard
Getting connection timeout error during first Hit if application is idle for long period
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.