I am facing issue of unable to obtain JDBC connection even though there are idle connections available in HIKARI.
Context: using SCDF to launch composed task. There are three tasks which run in parallel.
Solutions I tried but didn't work:
- Adding connection validation query
- Increasing connectionTimeout and validationTimeout
And this issue started to happen recently and happens intermittently. we run the same composed task 4 times daily but fails once or twice a day with above error.
hikari config
allowPoolSuspension:false
autoCommit:true
catalog:none
connectionInitSql:none
connectionTestQuery:"SELECT1"
connectionTimeout:60000
dataSource:none
dataSourceClassName:none
dataSourceJNDI:none
dataSourceProperties:{password=<masked>}
driverClassName:"com:mysql:cj:jdbc:Driver"
healthCheckProperties:{}
healthCheckRegistry:none
idleTimeout:600000
initializationFailTimeout:1
isolateInternalQueries:false
jdbcUrl:<jdbcUrl>
leakDetectionThreshold:0
maxLifetime:1800000
maximumPoolSize:20
metricRegistry:none
metricsTrackerFactory:none
minimumIdle:20
password:<masked>
poolName:"HikariPool-1"
readOnly:false
registerMbeans:false
scheduledExecutor:none
schema:none
threadFactory:internal
transactionIsolation:default
username:"user"
validationTimeout:20000
