mySql connection failed

Networking & Multiplayer
#1

I’m not sure what exactly was your problem, can you please explain?

Today, I experienced following problem:
On my dedicated unix box I have running mySql 4.1.10 and my game server (java application).
The application is permanently connected to the database, is has 4 prepared sql statements (quite simple) and occasionaly executes some of them.
Everything run smoothly for a week - and then, out of the blue, following exception:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288 )
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347)

each subsequent sql statement failed with:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe

STACKTRACE:

java.net.SocketException: Broken pipe

I have really no idea what could went wrong, when both the database and the application are on the same machine?!
Happened to anybody? Any ideas?

#2

yes, you actually need to read the docs for mmmysql driver and mysql.

its (almost certainly) a design “feature” that has pissed off huge numbers of people over the years.

just make you8r connection auto reconnnnect better, i cant tell you how you have toread thedocs for your particlar version of the driver

#3

Uh… if this is a feature… than I’m bit worried what bugs do they have :o