Wait_timeout Exceeded on JDBC Connection (Doc ID 2019877.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Connectors - Version 5.3 and later
Information in this document applies to any platform.

Symptoms

On : 5.6 version, Connector/J

When attempting to access MySQL Server via JDBC,
the following error occurs.

ERROR
-----------------------
2015-05-03 21:09:25,541 ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The last packet successfully received from the server was 108,565,353 milliseconds ago. The last packet sent successfully to the server was 108,565 ,399 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot manage connections via their application to the mysql service.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms