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 -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/5dc36af2-f373-4042-b6b7-68ecedf4cf70n%40apereo.org.
