Exception during keep alive check about hikaricp

[brettwooldridge]

This seems like a mismatch between the HikariCP pool timeout settings and the MySQL timeout settings. This error is almost exactly the same as yours (using the Apache DBCP connection pool):

https://groups.google.com/forum/#!msg/rundeck-discuss/R-2tHGXQzk0/gqFzeZ6WOLsJ

I would suggest checking the my.cnf MySQL configuration file. Here is an article on configuring MySQL timeouts:

http://www.rackspace.com/knowledge_center/article/how-to-change-the-mysql-timeout-on-a-server

The HikariCP timeouts should be about one minute shorter than whatever you set in MySQL. Try and and let me know how it works.

[virtyvoid]

Indeed.. That was the problem, wait_timeout was 600 sec while MaxTime in pool is 3 hrs.
Set wait_timeout to 10860, seems fine now.
Even didn't expected that such inconsistency could lead to this, especially when i got this exception only in 1.2.6.

Useful hint, prolly should be placed somewhere in FAQ.
Thanks a lot.

[brettwooldridge]

No problem, glad it worked out. I've flagged this issue as a "Question", and when I get a few more I'll start a FAQ.