Bug #34033 Error 899 can occur during high insert/delete-load
Submitted: 24 Jan 2008 13:10 Modified: 20 Feb 2008 21:56
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:5.1* OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[24 Jan 2008 13:10] Jonas Oreland
Error 899 can occur during high insert/delete-load
The problem is that LCP is not syncronized between the nodes,
  and the LCP snapshot prevents deleted ROWIDs to reused directly
  (even if time when they are not reused should be short...
   possibly it's higher if running with low disk-checkpoint-speed)

However, the LCP-snapshot is only needed for DD-tables

So the (forth-coming) patch removes it from MM-tables.

How to repeat:

Suggested fix:
[24 Jan 2008 13:21] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


ChangeSet@1.2532, 2008-01-24 14:21:52+01:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#34033
    remove LCP-snapshot from MM-tables,
    removing possibility of spurious 899 on MM-tables
[30 Jan 2008 13:08] Jonas Oreland
pushed to 51-ndb, telco-*
[1 Feb 2008 12:56] Jon Stephens
Documented bugfix for 5.1.23-ndb-6.3.8 as follows:

        High numbers of insert operations, delete operations, or both
        could cause NDB error 899 (Rowid
        already allocated) to occur unnecessarily.        
Left bug in Patch Queued status pending further merges.
[2 Feb 2008 12:09] Jon Stephens
Also documented for 5.1.23-ndb-6.2.11; left status unchanged.
[20 Feb 2008 16:02] Bugs System
Pushed into 5.1.24-rc
[20 Feb 2008 16:04] Bugs System
Pushed into 6.0.5-alpha
[20 Feb 2008 21:56] Jon Stephens
Also documented for 5.1.24 and 6.0.5.