Bug #9265 mysql cluster "Lock"
Submitted: 18 Mar 2005 6:37 Modified: 2 Jul 2005 14:54
Reporter: errorlog errorlog Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:14.1.14 OS:Linux (linux)
Assigned to: CPU Architecture:Any

[18 Mar 2005 6:37] errorlog errorlog
Description:
java.sql.SQLException: General error,  message from server: "Lock wait timeout exceeded; try restarting transaction"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1750)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1596)
        at com.guardlbt.db.connect.test(connect.java:83)
        at com.guardlbt.db.connect.main(connect.java:103)

How to repeat:
java.sql.SQLException: General error,  message from server: "Lock wait timeout exceeded; try restarting transaction"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1750)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1596)
        at com.guardlbt.db.connect.test(connect.java:83)
        at com.guardlbt.db.connect.main(connect.java:103)
[2 Jul 2005 14:54] Hartmut Holzgraefe
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.