MySQL Bugs: #34033: Error 899 can occur during high insert/delete-load

Bug #34033	Error 899 can occur during high insert/delete-load
Submitted:	24 Jan 2008 14:10	Modified:	20 Feb 2008 22:56
Reporter:	Jonas Oreland
Status:	Closed
Category:	Server: Cluster	Severity:	S4 (Feature request)
Version:	5.1*	OS:	Any
Assigned to:	Jonas Oreland	Target Version:
Triage:	D5 (Feature request)

Description:
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:
.

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:

  http://lists.mysql.com/commits/41204

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

pushed to 51-ndb, telco-*

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.

Also documented for 5.1.23-ndb-6.2.11; left status unchanged.

Pushed into 5.1.24-rc

Pushed into 6.0.5-alpha

Also documented for 5.1.24 and 6.0.5.