View Single Post

  #1 (permalink)  
Old 03-29-2008
रवींदर ठाकुर (ravinder thakur)
 
Posts: n/a
Default error : Lock wait timeout exceeded; try restarting transaction

hello friends,


i am trying to create a java application using mysql but if i try to
create multiple connections, i keep on getting this exception given
below. I have read about the TransactionDeadLockDetectionTimeOut
option but i am neither able to find config.ini nor i am running the
cluster for which this option applies.


what could be the problem here ?

thanks
ravinder thakur



java.sql.SQLException: Lock wait timeout exceeded; try restarting
transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:18 37)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1961)
Reply With Quote