Bug #30975 cluster restart fails tsman table id assertion
Submitted: 12 Sep 2007 14:06 Modified: 5 Nov 2007 21:15
Reporter: Axel Schwenke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:5.1 OS:Linux
Assigned to: Jonas Oreland CPU Architecture:Any

[12 Sep 2007 14:06] Axel Schwenke
Description:
Cluster restarted at 12:02:35

2007-09-12 12:03:11 [MgmSrvr] ALERT    -- Node 4: Forced node shutdown completed
. Occured during startphase 4. Initiated by signal 6. Caused by error 2341: 'Int
ernal program error (failed ndbrequire)(Internal error, programming error or mis
sing error message, please report a bug). Temporary error
2007-09-12 12:03:13 [MgmSrvr] ALERT    -- Node 3: Forced node shutdown completed
. Occured during startphase 4. Initiated by signal 6. Caused by error 2308: 'Ano
ther node failed during system restart, please investigate error(s) on other nod
e(s)(Restart error). Temporary error, restart node'.
...
2007-09-12 12:05:51 [MgmSrvr] ALERT    -- Node 3: Forced node shutdown completed
. Occured during startphase 4. Initiated by signal 6. Caused by error 2341: 'Int
ernal program error (failed ndbrequire)(Internal error, programming error or mis
sing error message, please report a bug). Temporary error
2007-09-12 12:05:52 [MgmSrvr] ALERT    -- Node 4: Forced node shutdown completed
. Occured during startphase 4. Initiated by signal 6. Caused by error 2341: 'Int
ernal program error (failed ndbrequire)(Internal error, programming error or mis
sing error message, please report a bug). Temporary error
...
[lots more of those]

the failed ndbrequire:

Time: Wednesday 12 September 2007 - 12:05:28
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: tsman.cpp
Error object: TSMAN (Line: 1802) 0x00000002
Program: ./ndbd
Pid: 15466
Trace: /var/mnt/local/MySQLClusterPreprov-0-A_DATA/ndb_3_trace.log.3
Version: mysql-5.1.15 ndb-6.1.19-beta

complete logs in CSC issue

How to repeat:
n/a
[21 Sep 2007 9:36] Jonas Oreland
E (0,1)
P0 OK
P1 UNINIT
U P0
U P1
[26 Sep 2007 17:24] 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/34567

ChangeSet@1.2585, 2007-09-26 19:21:45+02:00, jonas@eel.hemma.oreland.se +8 -0
  ndb - bug#30975
    Add testcase
[27 Sep 2007 19: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/34604

ChangeSet@1.2586, 2007-09-27 21:00:51+02:00, jonas@eel.hemma.oreland.se +3 -0
  ndb - bug#30975
    more testcases
[28 Sep 2007 7:59] 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/34628

ChangeSet@1.2510, 2007-09-28 09:58:56+02:00, jonas@perch.ndb.mysql.com +10 -0
  ndb - add new testcases/error insert bug#30975
    (recommit for correct merge order)
[29 Sep 2007 9:10] 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/34673

ChangeSet@1.2511, 2007-09-29 11:10:12+02:00, jonas@perch.ndb.mysql.com +2 -0
  ndb - bug#30975
    add even more tests
[29 Sep 2007 9:28] 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/34675

ChangeSet@1.2583, 2007-09-29 11:27:50+02:00, jonas@perch.ndb.mysql.com +8 -0
  ndb - bug#30975
    - only update extent pages *after* flush of real page has been done
    - sync both create/drop of table into undolog (for disk tables)
[6 Oct 2007 17:23] Jon Stephens
Documented bugfix in mysql-5.1.15-ndb-6.1.21 changelog.

Left status as Patch Pending.
[8 Oct 2007 13:54] 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/35102

ChangeSet@1.2514, 2007-10-08 15:53:29+02:00, jonas@perch.ndb.mysql.com +8 -0
  ndb - bug#30975 (recommit to 51-telco-gca)
      - only update extent pages *after* flush of real page has been done
      - sync both create/drop of table into undolog (for disk tables)
[9 Oct 2007 6:13] Jonas Oreland
pushed to 51-ndb, telco-6.2, telco-6.3 and 51-telco
[10 Oct 2007 8:20] Jon Stephens
Bugfix also documented in mysql-5.1.22-ndb-6.2.7 changelog; left status as PQ.
[15 Oct 2007 17:40] Jon Stephens
Also documented in mysql-5.1.22-ndb-6.3.4 changelog; left status as PQ.
[5 Nov 2007 13:53] Bugs System
Pushed into 6.0.4-alpha
[5 Nov 2007 13:56] Bugs System
Pushed into 5.1.23-rc
[5 Nov 2007 21:15] 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

Also documented in 5.1.23 and 6.0.4 changelogs. Closed.