Bug #64767 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

• Submitted: 26 Mar 2012 19:29
• Modified: 27 Mar 2012 6:29
• Reporter: Fabricio Siqueira
• Status: Not a Bug
• Category: Connector / J
• Severity: S1 (Critical)
• Version: 5.1.46
• OS: Windows
• CPU Architecture: Any

[26 Mar 2012 19:29] Fabricio Siqueira

Description:
I have an application that authenticates to jboss, and adds a record in a table control for users who are using the software, but when they do log off or leave the system that record is deleted to prevent more than one person use the same login, but when he tries to erase the record at one point this error is displayed.
What to do???

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 51.601.798 milliseconds ago.  The last packet sent successfully to the server was 51.601.798 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.

How to repeat:
Every day

[27 Mar 2012 6:29] Valeriy Kravchuk

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.