Hello,
I have a process on Grails 2 that handles requests from the DB...every 2 to 3 weeks I get the error
SQL Error: 0, SQLState: 08S01
spi.SqlExceptionHelper - Communications link failure
The last packet successfully received from the server was 1,681 milliseconds ago. The last packet sent successfully to the server was 1,681 milliseconds ago.
The worst part is that the application doesn't reconnect and my process keeps hanging until i restart tomcat myself
- I've checked the configuration on my.cnf
- I've added all the info in my datasource configuration for reconnect, timeouts and validation queries
- The connection to the DB is never idle since I query the DB every second to retrieve records
- I'm catching the throwable when this error occurs but I'm still unable to do anything about it
Does anyone have any hint of how to solve this issue ?