Description:
As subject.
How to repeat:
create table t1 (
a bigint(18) NOT NULL AUTO_INCREMENT primary key,
b varchar(128) NOT NULL,
c LONGTEXT
) ENGINE NDB ;
mysql1> set autocommit=0;
mysql1> insert into t1 (b,c) values ('test','test');
mysql2> select * from t1;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql2> show warnings\G
*************************** 1. row ***************************
Level: Error
Code: 1297
Message: Got temporary error 274 'Time-out in NDB, probably caused by deadlock' from NDB
*************************** 2. row ***************************
Level: Error
Code: 1297
Message: Got temporary error 274 'Time-out in NDB, probably caused by deadlock' from NDB
*************************** 3. row ***************************
Level: Error
Code: 1205
Message: Lock wait timeout exceeded; try restarting transaction
*************************** 4. row ***************************
Level: Error
Code: 1622
Message: Storage engine NDB does not support rollback for this statement. Transaction rolled back and must be restarted
4 rows in set (0.00 sec)
Description: As subject. How to repeat: create table t1 ( a bigint(18) NOT NULL AUTO_INCREMENT primary key, b varchar(128) NOT NULL, c LONGTEXT ) ENGINE NDB ; mysql1> set autocommit=0; mysql1> insert into t1 (b,c) values ('test','test'); mysql2> select * from t1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction mysql2> show warnings\G *************************** 1. row *************************** Level: Error Code: 1297 Message: Got temporary error 274 'Time-out in NDB, probably caused by deadlock' from NDB *************************** 2. row *************************** Level: Error Code: 1297 Message: Got temporary error 274 'Time-out in NDB, probably caused by deadlock' from NDB *************************** 3. row *************************** Level: Error Code: 1205 Message: Lock wait timeout exceeded; try restarting transaction *************************** 4. row *************************** Level: Error Code: 1622 Message: Storage engine NDB does not support rollback for this statement. Transaction rolled back and must be restarted 4 rows in set (0.00 sec)