Bug #4892 TRUNCATE TABLE returns error 156
Submitted: 4 Aug 2004 9:30 Modified: 5 Aug 2004 9:23
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-4.1 bk OS:
Assigned to: Magnus Blåudd CPU Architecture:Any

[4 Aug 2004 9:30] Magnus Blåudd
I have a clustered table with a couple hundred thousand rows..

I am trying to clear the table..

If I try to truncate the table I get:
mysql> truncate table webdata;
ERROR 1005 (HY000): Can't create table './easynews/webdata' (errno: 156)

If I try to delete the rows I get:
mysql> delete from webdata;
ERROR 1297 (HY000): Got temporary error 233 'Out of operation records
in transaction coordinator' from ndbcluster

How to repeat:
truncate table t1;

Suggested fix:
Add test case ndb_truncate 
Make it possible to truncate the table.
[4 Aug 2004 11:33] Magnus Blåudd
Added NDBCLUSTER to table types which does not support generate. This make the truncate work by deleting on row at a time. However the TRUNCATE is still limited by MaxNoOfConcurrentOperations.