Bug #9807 timeout

• Submitted: 11 Apr 2005 9:50
• Modified: 11 Apr 2005 14:55
• Reporter: Nicolas Olek
• Status: Not a Bug
• Category: Connector / J
• Severity: S3 (Non-critical)
• Assigned to: Geert Vanderkelen
• CPU Architecture: Any

[11 Apr 2005 9:50] Nicolas Olek

Description:
This is the only example : I launch my application at 5pm on monday. On tuesday at 8am i want to to make a request to my database and i already have this problem. Is it an timeout ?

SQLException: 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.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2370)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183)
        at tools.BeanDataBase.executeRequeteSelection(BeanDataBase.java:175)
        at data.Outil.loadObject(Outil.java:400)
        at frm.MainFrm.DoubleClickOnOutil(MainFrm.java:5423)
        at frm.MainFrm.tableOutilMouseClicked(MainFrm.java:5408)
        at frm.MainFrm.access$1300(MainFrm.java:45)
        at frm.MainFrm$14.mouseClicked(MainFrm.java:832)
        at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)

** END NESTED EXCEPTION **

SQLState: 08S01
VendorError: 0

How to repeat:
Don't use application more tahn 8 hours.

Suggested fix:
I don't know how to fix the problem.

[11 Apr 2005 12:50] Geert Vanderkelen

Hi Nicolas,

Check either:
- if server has been restarted, or connection killed, network issues, etc..
- the system variables wait_timeout/interactive_timeout

Regards,

Geert

[11 Apr 2005 14:55] Mark Matthews

Please see http://dev.mysql.com/doc/connector/j/en/cj-troubleshooting.html#id2629885