Bug #27434 Incorrect handling of FragState in take-over during SR
Submitted: 26 Mar 2007 8:56 Modified: 2 Apr 2007 11:20
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:4.1,5.0,5.1 OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[26 Mar 2007 8:56] Jonas Oreland
Description:
If take-over during SR occurs
  (i.e node is too old and gets data copied from another node in node group)

Then fragstate in LQH is set incorrectly so that the copy procedure
  is REDO logged, this can lead to 1220 (or similar)

Which if you're unlucky might finally shutdown node (and cluster)

How to repeat:
.

Suggested fix:
.
[27 Mar 2007 14:07] 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/23013

ChangeSet@1.2505, 2007-03-27 16:06:47+02:00, jonas@perch.ndb.mysql.com +14 -0
  ndb - bug#27434
    Add new take-over step, PREPARE_COPY_FRAG
[2 Apr 2007 11:20] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in mysql-5.1.16-ndb-6.2.1 changelog.
[10 Apr 2007 9:41] 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/24140

ChangeSet@1.2140, 2007-04-10 11:38:31+02:00, jonas@perch.ndb.mysql.com +16 -0
  ndb - bug#27434 (wl2325-5.0)
    Add new take-over step, that sets correct fragstate (and fixing expand in ACC)
[10 Apr 2007 9:51] 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/24142

ChangeSet@1.2528, 2007-04-10 11:51:05+02:00, jonas@perch.ndb.mysql.com +3 -0
  ndb - bug#27434
    handle ordered indexes
    handle ACC expand
    correct error code inn testcase
[29 May 2007 13:50] Tomas Ulin
5.1, + telco has the following bug instead:
28491