Re: Error: Transaction already aborted

[Adam D]

This bug report is for 5.0, however I am also experiancing it in 4.1.12-max;

mysql> delete from table where tableID < 240000;
ERROR 1296 (HY000): Got error 4350 'Transaction already aborted' from ndbcluster
mysql> show warnings;
Same 3 errors As original post.

mysql> delete from table where tableID < 240000 limit 5000;
Query OK, 5000 rows affected (58.73 sec)

mysql> delete from table where tableID < 240000 limit 10000;
ERROR 1296 (HY000): Got error 4350 'Transaction already aborted' from ndbcluster
mysql> show warnings;
Same 3 errors As original post.


mysql> desc table;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| tableID | int(10) unsigned | | PRI | NULL | auto_increment |
| table0 | datetime | YES | | NULL | |
| table1 | varchar(50) | YES | | NULL | |
| table4 | int(11) | | MUL | 0 | |
| table3 | mediumtext | YES | | NULL | |
| table4 | tinyint(4) | | | 0 | |
+------------+------------------+------+-----+---------+----------------+
6 rows in set (0.02 sec)