Wait_timeout Exceeded on JDBC Connection
(Doc ID 2019877.1)
Last updated on MAY 29, 2023
Applies to:
MySQL Connectors - Version 5.3 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |