mysql connection failure

[pguillebaud]

mySQL/jdbc driver seems to be locking up after a period of inactivity.

mySQL server is version 3.2.3, the driver is version 3.0.6.

Here is the stack trace:
"Thread-3" daemon prio=1 tid=0x085b2c18 nid=0x55cd runnable [4e1ce000..4e1cf8b8]
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
at java.io.BufferedInputStream.read(BufferedInputStream.java:201)
- locked <0x4514f348> (a java.io.BufferedInputStream)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1309)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1624)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
at com.mysql.jdbc.Connection.ping(Connection.java:2513)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1855)
- locked <0x4514f1e8> (a java.lang.Object)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1817)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1798)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:572)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:237)
at org.apache.commons.dbcp.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:273)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
- locked <0x4514ceb0> (a org.apache.commons.dbcp.AbandonedObjectPool)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
- locked <0x4514ceb0> (a org.apache.commons.dbcp.AbandonedObjectPool)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
at insl.DBObject.doSelect(DBObject.java:909)
at insl.Controller.doLogin(Controller.java:391)
at insl.Controller.handleRequest(Controller.java:124)
at insl.Controller.doPost(Controller.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

Any ideas welcome!
Many thanks.

 

[vbkris]

do a try catch block, the error will be clearer...

Known is handfull, Unknown is worldfull