Connection with empty query string in DB

[subodh022]

We see a lot of queries sitting idle in DB but no query string. And they have been running for hours. We use Hikari connection pool in our Scala - Play Framework app.

And our app is throwing this error now - HikariPool-1 - Connection is not available, request timed out after 5000ms.

This is our Hikari Config -

HikariPool-1 - idleTimeout is less than 10000ms, setting to default 600000ms. HikariPool-1 - configuration: allowPoolSuspension.............false autoCommit......................true catalog.........................none connectionInitSql...............none connectionTestQuery.............none connectionTimeout...............5000 dataSource......................none dataSourceClassName.............none dataSourceJNDI..................none dataSourceProperties............{password=<masked>} driverClassName................."org.postgresql.Driver" healthCheckProperties...........{} healthCheckRegistry.............none idleTimeout.....................600000 initializationFailTimeout.......1 isolateInternalQueries..........false jdbcUrl.........................<masked> leakDetectionThreshold..........0 maxLifetime.....................1800000 maximumPoolSize.................228 metricRegistry..................none metricsTrackerFactory...........none minimumIdle.....................5 password........................<masked> poolName........................"HikariPool-1" readOnly........................false registerMbeans..................false scheduledExecutor...............none schema..........................none threadFactory...................internal transactionIsolation............default username........................<masked> validationTimeout...............5000

[Ari-Prasetiyo]

whats issue solved ?