Interestingly, we've had that setting on for a while and still occasionally get the issue.
Here's our configuration:
idleMaxAge=10 minutes idleConnectionTestPeriod=30 seconds connectionTimeout=2 seconds connectionTestStatement="SELECT 1" maxConnectionAge=0 partitionCount=4 maxConnectionsPerPartition=6 minConnectionsPerPartition=4 setLogStatementsEnabled=true acquireRetryAttempts=10 acquireRetryDelay=5 seconds
Interestingly, we've had that setting on for a while and still occasionally get the issue.
Here's our configuration:
idleMaxAge=10 minutes nTestPeriod= 30 seconds eout=2 seconds tStatement= "SELECT 1" Age=0 sPerPartition= 6 sPerPartition= 4 ntsEnabled= true ttempts= 10 elay=5 seconds
idleConnectio
connectionTim
connectionTes
maxConnection
partitionCount=4
maxConnection
minConnection
setLogStateme
acquireRetryA
acquireRetryD