My Oracle Support Banner

Wait_timeout Exceeded on JDBC Connection (Doc ID 2019877.1)

Last updated on SEPTEMBER 26, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.