Bug #18867 MaxConcurrentTransactions Exceeded when doing big delete from table

Description:
When testing ndb_cluster disk storage  I run into the following error when trying to delete everything a "big" table

(t1) as described in Michael 's blog entry.

ql> select count(*) from t1;
+----------+
| count(*) |
+----------+
|   394958 |
+----------+
1 row in set (0.00 sec)

mysql> delete from table t1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table  t1' at line 1
mysql> delete from t1;
ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transac tion coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER

Simply dropping the table works

How to repeat:
Create table filled with single values  fill it with about 394958 entries,
then delete them..

Hi,

This is not a bug.
It's documented in limitations section.

The work around is to use "truncate" instead.

see
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-limitations.html

and search for truncate (on this page only)