lthoulon-locala commented on issue #11855: URL: https://github.com/apache/druid/issues/11855#issuecomment-1768747376
Hello. I'm having the same issue and even setting the `keepalive-time` it's failing after 4 minutes of idle time. I guess this is linked to the `unusedConnectionTimeout`. I do however see the keepalive working on my second connection. ``` 2023-10-18T17:24:16.753+02:00 DEBUG 18188 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Pool stats (total=5, active=0, idle=5, waiting=0) 2023-10-18T17:24:16.754+02:00 DEBUG 18188 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Fill pool skipped, pool has sufficient level or currently being filled (queueDepth=0). 2023-10-18T17:24:20.002+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Pool stats (total=5, active=0, idle=5, waiting=0) 2023-10-18T17:24:20.002+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Fill pool skipped, pool has sufficient level or currently being filled (queueDepth=0). 2023-10-18T17:24:26.452+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@52f0bb54 is alive 2023-10-18T17:24:29.238+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@36919a6d is alive 2023-10-18T17:24:30.369+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@652279f0 is alive 2023-10-18T17:24:31.113+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@190ba0b6 is alive 2023-10-18T17:24:32.424+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@b89cbf9 is alive 2023-10-18T17:24:46.825+02:00 DEBUG 18188 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Pool stats (total=5, active=0, idle=5, waiting=0) 2023-10-18T17:24:46.826+02:00 DEBUG 18188 --- [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Fill pool skipped, pool has sufficient level or currently being filled (queueDepth=0). 2023-10-18T17:24:50.075+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Pool stats (total=5, active=0, idle=5, waiting=0) 2023-10-18T17:24:50.075+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Fill pool skipped, pool has sufficient level or currently being filled (queueDepth=0). 2023-10-18T17:24:54.356+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@52f0bb54 is alive 2023-10-18T17:24:57.357+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@36919a6d is alive 2023-10-18T17:24:58.540+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@652279f0 is alive 2023-10-18T17:24:59.370+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@190ba0b6 is alive 2023-10-18T17:25:00.905+02:00 DEBUG 18188 --- [l-2 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - keepalive: connection org.apache.calcite.avatica.AvaticaJdbc41Factory$AvaticaJdbc41Connection@b89cbf9 is alive ``` At some point I also thought there was an issue with the [connection's stickiness](https://druid.apache.org/docs/latest/querying/sql-jdbc/#connection-stickiness) but the druid i'm using only has a single broker. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org
