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
I I try to delete with limit I get:
mysql> delete from webdata limit 1000;
ERROR 1030 (HY000): Got error 499 from storage engine
Is the only way to remove all the rows currently to drop/recreate the table?