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

Andreas Andersson <[email protected]> Fri, 25 May 2007 19:19:51 +0200
Newsgroups gmane.comp.db.mysql.java
Message-ID <[email protected]>
Hi!

I'm running mysql 5.0.37 with mysql-connector-java-5.0.6. We just moved
from mysql 4.0.something and now we notice this annoying error.

(full stacktrace)

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

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: 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:1956)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2368)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2867)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3333)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1232)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2749)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
        at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
 
This all happens on new connections created after between 50 and 90
minutes uptime on my tomcat server. Several connections are in use (and
being reused until they are dropped by the server) during that time.

I get nothing in the error log at all.

I'll be thankful for any input on this. Thanks.
-- 
Andreas Andersson
Senior Developer

Travelstart <http://www.travelstart.se>

Travelstart Nordic AB
Davidshallsgatan 14
211 45 Malmö

www.travelstart.se <http://www.travelstart.se>
www.travelstart.dk <http://www.travelstart.dk>
	  	Tel +46 (0)40-690 38 83
Mob +46 (0)70-757 23 73
Fax +46 (0)40-611 17 78

www.travelstart.no <http://www.travelstart.no>
www.travelstart.co.za <http://www.travelstart.co.za>


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]