Bug #65256 | NDBD error 2341 in NDBCNTR during startup phase 5 causes cluster shutdown | ||
---|---|---|---|
Submitted: | 9 May 2012 13:59 | Modified: | 5 Oct 2016 22:55 |
Reporter: | Przemysław Ołtarzewski | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
Version: | 7.2.5 | OS: | Solaris (10, SPARC 64bit) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
Tags: | NDBD NDBCNTR 2341 CREATE_TABLE_REF phase 5 |
[9 May 2012 13:59]
Przemysław Ołtarzewski
[9 May 2012 15:02]
Przemysław Ołtarzewski
After more trace parsing it turns out that the root cause behing the error 2341 was an error no. 771 in DBDICT (Given NODEGROUP doesn't exist in this cluster). Node groups for data nodes were arbitrally set to 1 and 2. As it turns out, setting them to 0 and 1 respectively solves the issue and is a workaround for cluster startup. Severity changed as workaround found, although the error message should contain the root cause of the problem, an arbitrary node group numbering within a specified range should be possible or at least there should be a hint in the documentation that node groups should be number starting with 0.
[18 Sep 2012 23:59]
Frank Zhou
I got the similar error Node 2: Forced node shutdown completed. Occured during startphase 5. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'. ndb_mgm> Node 3: Forced node shutdown completed. Occured during startphase 5. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'. 3 nodes, 154 is the mgmd, 248,249 are ndbd
[21 Dec 2012 15:34]
Mark Norman
how do you force the node groups to be numbered 0 and 1?
[15 Aug 2014 4:23]
vishnu chanderraju
Thanks Frank for the work around. it helped. hi Mark, you can use the 'NodeGroup' variable and assign node group id. example: [ndbd] NodeGroup= 1 HostName=10.95.19.62 with regards, ch Vishnu
[5 Oct 2016 22:55]
MySQL Verification Team
not able to reproduce this on any modern mccge release.