HikariPool-1 connection has passed maxLifetime

[Joe Manavalan]

Upgrading from jasig cas 3.4 to 6.1 using  cas.authn.pac4j.oauth2  and jpa registry

Following is my connection pool setting

cas.ticket.registry.jpa.failFastTimeout=1

#cas.ticket.registry.jpa.healthQuery=SELECT 1

cas.ticket.registry.jpa.isolateInternalQueries=false

cas.ticket.registry.jpa.leakThreshold=10

cas.ticket.registry.jpa.batchSize=25

cas.ticket.registry.jpa.jpaLockingTimeout=3600

cas.ticket.registry.jpa.pool.minSize=10

cas.ticket.registry.jpa.pool.maxSize=18

Is there a setting to resolve the connection pool issue? It seems all the connections reaches max life more or less around the same time and the pool becomes empty and server stops responding with sql error thereafter

2021-01-30 14:41:02,135 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Before cleanup stats (total=10, active=0, idle=10, waiting=0)>

2021-01-30 14:41:02,135 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - After cleanup  stats (total=10, active=0, idle=10, waiting=0)>

2021-01-30 15:26:02,159 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Before cleanup stats (total=5, active=0, idle=5, waiting=0)>

2021-01-30 15:26:02,159 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - After cleanup  stats (total=5, active=0, idle=5, waiting=0)>

2021-01-30 15:26:13,339 DEBUG [com.zaxxer.hikari.pool.PoolBase] - <HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@3596dd43: (connection has passed maxLifetime)>

2021-01-30 15:26:32,159 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Before cleanup stats (total=4, active=0, idle=4, waiting=0)>

2021-01-30 15:26:32,159 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - After cleanup  stats (total=4, active=0, idle=4, waiting=0)>

2021-01-30 15:30:46,183 DEBUG [com.zaxxer.hikari.pool.PoolBase] - <HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@75dee9d5: (connection has passed maxLifetime)>

2021-01-30 15:30:11,432 DEBUG [com.zaxxer.hikari.pool.PoolBase] - <HikariPool-1 - Closing connection oracle.jdbc.driver.T4CConnection@756a44f4: (connection has passed maxLifetime)>

2021-01-30 15:30:32,161 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)>

2021-01-30 15:30:32,161 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - After cleanup  stats (total=1, active=0, idle=1, waiting=0)>

2021-01-30 15:31:02,161 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Before cleanup stats (total=0, active=0, idle=0, waiting=0)>

2021-01-30 15:31:02,161 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - After cleanup  stats (total=0, active=0, idle=0, waiting=0)>

2021-01-30 15:31:32,162 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Before cleanup stats (total=0, active=0, idle=0, waiting=1)>

2021-01-30 15:31:32,162 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - After cleanup  stats (total=0, active=0, idle=0, waiting=1)>

2021-01-30 15:31:56,158 DEBUG [com.zaxxer.hikari.pool.HikariPool] - <HikariPool-1 - Timeout failure stats (total=0, active=0, idle=0, waiting=0)>

2021-01-30 15:31:56,160 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <SQL Error: 0, SQLState: null>

2021-01-30 15:31:56,160 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <HikariPool-1 - Connection is not available, request timed out after 30003ms.>

2021-01-30 15:31:56,240 ERROR [org.apereo.cas.config.CasCoreTicketsSchedulingConfiguration] - <Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection>

org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:447) ~[spring-orm-5.2.0.RELEASE.jar:5.2.0.RELEASE]

Thanks in advance

Joe