I am seeing the below DEBUG logs for my Java service. Connections are not going to the pool again after use. And active and total connects remain equal and after a certain time, when timeout happens, waiting for connections decreases.
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Before cleanup stats (total=1, active=1, idle=0, waiting=0)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Before cleanup stats (total=1, active=1, idle=0, waiting=0)
After cleanup stats (total=1, active=1, idle=0, waiting=0) 17-01-2023 10:15:32.419 [35m[HikariPool-1 housekeeper][0;39m [39mDEBUG[0;39m After cleanup stats (total=1, active=1, idle=0, waiting=0)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Before cleanup stats (total=32, active=32, idle=0, waiting=1)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Before cleanup stats (total=32, active=32, idle=0, waiting=1)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - After cleanup stats (total=32, active=32, idle=0, waiting=1)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - After cleanup stats (total=32, active=32, idle=0, waiting=1)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - After adding stats (total=50, active=40, idle=10, waiting=0)
m com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - After adding stats (total=50, active=40, idle=10, waiting=0)
2023-01-17T15:46:32.536+05:30
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Before cleanup stats (total=50,
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Before cleanup stats (total=50, active=50, idle=0, waiting=31)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - After cleanup stats (total=50, active=50, idle=0, waiting=31)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - After cleanup stats (total=50, active=50, idle=0, waiting=31)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Timeout failure stats (total=50, active=50, idle=0, waiting=91)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - **Timeout failure stats (total=50, active=50, idle=0, waiting=91) **
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 - Timeout failure stats (total=50, active=50, idle=0, waiting=92)
com.zaxxer.hikari.pool.HikariPool.logPoolState - HikariPool-1 -**** Timeout failure stats (total=50, active=50, idle=0, waiting=92)
I am not using any datasource.getConnection(). It's all implicit to springboot.
Can you pls help and suggest.
Below is the config I am using
hikari:
connection-timeout: 30000
maximum-pool-size: 10
min-idle: 5
leak-detection-threshold: 30000
