jdbc "Communications link failure" / Logging myql
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
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.