Bug #33168 Incorrectly handled parameters can make the TC crash during node failure
Submitted: 12 Dec 2007 13:55 Modified: 14 Dec 2007 20:26
Reporter: Geert Vanderkelen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:4.1 -> OS:Any
Assigned to: Tomas Ulin CPU Architecture:Any
Triage: D2 (Serious)

[12 Dec 2007 13:55] Geert Vanderkelen
Description:
When stopping one data node, it is possible that the remaining node crashes with following error:

Time: Monday 12 November 2007 - 06:38:51
Status: Temporary error, restart node
Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)
Error: 2341
Error data: 
Error object: DBTC (Line: 6469) 0x00000002
Program: /opt/foo/bin/ndbd
Pid: 3578
Trace: /blade/foo/ndb//ndb_4_trace.log.2
Version: mysql-5.1.22 ndb-6.2.8-beta

How to repeat:
No test case by MySQL, but it can be repeated by customer.
[13 Dec 2007 18:37] Tomas Ulin
proposed patch

Attachment: bug33168.patch (text/x-patch), 2.18 KiB.

[13 Dec 2007 18:38] Tomas Ulin
patch attached for review
[13 Dec 2007 20:31] 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/39938

ChangeSet@1.2578, 2007-12-13 21:31:38+01:00, tomas@whalegate.ndb.mysql.com +2 -0
  Bug #33168 Incorrectly handled parameters can make the TC crash during node failure
  - during commit deadlock timeout needs to be at least 5 times db hearbeat
[13 Dec 2007 20:45] Tomas Ulin
will not fix in 4.1

queued 5.0 and onwards
[14 Dec 2007 17:08] Bugs System
Pushed into 5.1.23-rc
[14 Dec 2007 17:08] Bugs System
Pushed into 5.0.56
[14 Dec 2007 17:09] Bugs System
Pushed into 6.0.5-alpha
[14 Dec 2007 20:26] 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 5.0.56, 5.1.23, and 6.0.5 changelogs as:

        Incorrectly handled parameters could lead to a crash in the
        Transaction Coordinator during a node failure, causing other data
        nodes to fail.