jdbc "Communications link failure" / Logging myql
Posted by: Stefan Scheffler
Date: May 07, 2013 03:33AM

Hi,

We are facing a problem. At night we are running several proccesses on a Mysql (Server 5.1.61) and we are getting the exception from jdbc

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 7.200.068 milliseconds ago. The last packet sent successfully to the server was 8.333.893 milliseconds ago.
...
with nested Exception:

Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2499)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3008)


Our wait_timeout is set to 8h which should not be exceeded by the proccesses, because they are stopping after ca 2h.
max_connections is set to 800 which also should not be exceeded.
Is there a logging where i can have a look into, what has happened?

Regards
Stefan

Options: ReplyQuote


Subject
Written By
Posted
jdbc "Communications link failure" / Logging myql
May 07, 2013 03:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.