From: Mikael Ronström
Date: July 29 2004 3:44pm
Subject: Re: problem deleting records from clustered table
List-Archive: http://lists.mysql.com/cluster/214
Message-Id: <2CCD8AAC-E176-11D8-A76E-000A959312A2@mysql.com>
MIME-Version: 1.0 (Apple Message framework v618)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi Justin,

2004-07-29 kl. 01.02 skrev Justin Swanhart:

> 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:=20
> 156)
>

Not 100% sure but I think this will be done in one transaction so thus=20=

will run out
of operation records similar to the delete command next.

> 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
>

Executes as one transaction, needs the MaxNoOfConcurrentOperations to=20
be set higher
than the number of records in the table (actually due to a bug to be=20
fixed 2*number of records).

> I I try to delete with limit I get:
> mysql> delete from webdata limit 1000;
> ERROR 1030 (HY000): Got error 499 from storage engine
>

This error should not occur so please file a bug report on this one.

Rgrds Mikael

>
>
> Is the only way to remove all the rows currently to drop/recreate the=20=

> table?
>
> --=20
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:   =20
> http://lists.mysql.com/cluster?unsub=3Dmikael@stripped
>
>
Mikael Ronstr=F6m, Senior Software Architect
MySQL AB, www.mysql.com

Clustering:
http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html

http://www.eweek.com/article2/0,1759,1567546,00.asp