List:Cluster« Previous MessageNext Message »
From:Justin Swanhart Date:July 28 2004 11:02pm
Subject:problem deleting records from clustered table
View as plain text  
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?
Thread
problem deleting records from clustered tableJustin Swanhart29 Jul
  • Re: problem deleting records from clustered tableMikael Ronström29 Jul