Bug #34260 Rare race condition between aborted insert + scan delete can cause node crash
Submitted: 3 Feb 2008 13:59 Modified: 20 Feb 2008 22:50
Reporter: Jonas Oreland
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Jonas Oreland Target Version:
Triage: D2 (Serious) / R2 (Low) / E1 (None/Negligible)

[3 Feb 2008 13:59] Jonas Oreland 
Description:
Two scans can que up on a insert that gets aborted
In this case the assert(nextSerial == RNIL) is incorrect

How to repeat:
testDict -n TableAddAttrsDuring T1 T2 T7

Suggested fix:
remove assertion
[3 Feb 2008 14:01] 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:

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

ChangeSet@1.2534, 2008-02-03 14:01:31+01:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#34260
    remove incorrect ndbrequire
[10 Feb 2008 13:09] Jonas Oreland 
pushed to 51-ndb, telco-6.x (>=2)
[12 Feb 2008 16:16] Jon Stephens 
Documented in the 5.1.23-ndb-6.3.9 changelog as follows:

      In certain rare circumstances, a race condition could occur
      between an aborted insert and a delete leading a data node crash.

Left in PQ status pending additional merges.
[12 Feb 2008 17:10] Jon Stephens 
Also documented for 5.1.23-ndb-6.2.12.
[20 Feb 2008 17:03] Bugs System 
Pushed into 5.1.24-rc
[20 Feb 2008 17:03] Bugs System 
Pushed into 6.0.5-alpha
[20 Feb 2008 22:50] Jon Stephens 
Also documented for 5.1.24 and 6.0.5.