Tomcat, jdbc, mysql, servernedbrud

Til ekspertene!!

Jeg har en applikation, som i lang tid har kørt på en red-hat 9.0 med en tomcat, jdbc og MySql database... Indtil for nyligt var alt i skønneste orden, men pludselig er mit set-up blevet rablende vanvittig....

Min application benytter en connection pool configureret i Server.xml som beskrevet i dokumentationen for Tomcat.

(autoReconnect er sat til true!!!)

Her kommer noget af den fejlmeddelelse som Tomcat skriver i logfilen...:

2005-03-10 09:27:06 JDBCRealm[/chemicalinventory]: Exception performing authentication
java.sql.SQLException: Communications link failure during commit(). Transaction resolution unknown.
    at com.mysql.jdbc.Connection.commit(Connection.java:1099)
    at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:460)
    at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:347)
    at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:229)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:446)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Thread.java:595)

Denne fejlmeddelse er fremkommet efter jeg har opdateret jdbc driveren til den nyeste version fra MySql's hjemme side..

Inden opdatering af jdbc driver var fejlen typisk som denne:

java.sql.SQLException
MESSAGE: Communication link failure: java.io.EOFException, underlying cause: null

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1586)
    at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:403)
    at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:347)
    at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:229)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:446)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **

...... Er der nogen der har oplevet lignende problem, eller kan du hjælpe med info til at løse dette problem.