Bug #13638 Out of operation records in DELETE FROM on cluster
Submitted: 30 Sep 2005 8:39 Modified: 14 Mar 2006 9:11
Reporter: Fabio Coatti Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:4.1.15 (nightly) OS:Linux (Linux (AMD64))
Assigned to: CPU Architecture:Any

[30 Sep 2005 8:39] Fabio Coatti
Description:
This seems very similar to Bug# 10694, but I'm using 4.1.15-nightly-20050928 and the patch reported seems to be applied. Anyway, I've got this:

mysql> select count(*) from table;
+----------+
| count(*) |
+----------+
|   634876 |
+----------+
1 row in set (0.00 sec)

mysql> delete from table;
ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from ndbcluster
mysql> select count(*) from table;
+----------+
| count(*) |
+----------+
|   634876 |
+----------+
1 row in set (0.00 sec)

The table has 56 columns, for shorter tables I haven't got the same error;
MaxNoOfConcurrentOperations is set to 1048576

The system and configuration is the same as bug #11776 and bug #12118
(two dual opterons with 8 Gb each, with gentoo linux)

How to repeat:
Issue a delete, as shown, on a big table, I don't have yet more precise indication about the size of the table can trigger the problem.
[7 Feb 2006 6:39] Jonas Oreland
have you tried "truncate table" ?
[14 Feb 2006 9:11] Valeriy Kravchuk
And, please, try to repeat with a newer version, 4.1.18.
[15 Mar 2006 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".