Bug #20804 Error: 899 'Rowid already allocated' on UPDATE w/ disk column
Submitted: 1 Jul 2006 1:04 Modified: 11 Sep 2007 7:19
Reporter: Brian Morin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.11 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[1 Jul 2006 1:04] Brian Morin 
Description:
First, posted to forms, was told to file a bug.

When running load on a prototype app, I'm getting this error: 
mysql_real_query failed: Got temporary error 899 'Rowid already allocated' from NDBCLUSTER 

I'm using the v5.1.11 binaries on Linux. 

The app in question is doing no inserts or deletes. The is comming from an UPDATE operation that is operating on columns that aren't disk based, but the row does have a disk based column. 

What causes this error and advice on how to follow-up?

How to repeat:
No simple repro at this time
[1 Jul 2006 8:18] Valeriy Kravchuk 
Thank you for a problem report. Please, send relevant part of your application (at least, failing UPDATE statement) and SHOW CREATE TABLE results for the table you are updating.

For indexes UPDATE is similar to DELETE (old key walue) + INSERT (new key value), by the way...
[1 Jul 2006 8:35] Jonas Oreland 
Can you also upload cluster log.

This bug look like (http://bugs.mysql.com/bug.php?id=19929)

Did you do a node restart at any time while running inserts.
If so then this has been fixed,
  and you should be able to work-around by doing a rolling restart --initial
[24 Aug 2006 21:10] Brian Morin 
We've suspended the project that produced this bug.