Lock wait timeout exceeded; try restarting transaction

[Prabhu MK]

Hi,

I have web application that needs to access MySQL cluster setup. However after few hundreds of transactions my application gets the error as mentioned below:

java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1120)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:675)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

MySQL Cluster consists of 2 servers with both Data/AP node running on the same server. My web application is using the hibernate to access the database. Please let me know what could be the problem ?

Im using mysql-connector-java-3.1.11-bin.jar for connecting to Database.

This is my config.ini for the cluster.

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=600M
IndexMemory=100M

[NDB_MGMD]
hostname=192.168.1.43
datadir=/var/lib/mysql-cluster
[MYSQLD]
hostname=192.168.1.41
[MYSQLD]
hostname=192.168.1.42

[NDBD]
hostname=192.168.1.41
datadir=/var/mysql/data
[NDBD]
hostname=192.168.1.42
datadir=/var/mysql/data

Thanks in Adavance.

Prabhu MK