Bug #36702 System restart fails after LOGFILE creation error

• Submitted: 13 May 2008 22:05
• Modified: 21 Aug 2009 14:28
• Reporter: Hartmut Holzgraefe
• Status: Closed
• Category: MySQL Cluster: Disk Data
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-6.3
• OS: Linux
• Assigned to: Jonas Oreland
• CPU Architecture: Any
• Tags: 5.1.24-ndb-6.3.13

[13 May 2008 22:05] Hartmut Holzgraefe

Description:
Crash nodes as reported in bug #34102, restarting the data nodes will fail

How to repeat:
Have:
SharedGlobalMemory=256M

Create a logfile group with a quite big undo_buffer_size:

CREATE LOGFILE GROUP lg_1 ADD UNDOFILE '/data0/johan/mysqlcluster/undo_1.dat'
INITIAL_SIZE=4096M UNDO_BUFFER_SIZE=192M ENGINE=ndb;

This will trigger bug #34102, and after this node recovery fails.

Time: Monday 28 January 2008 - 13:45:42
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: dbdict/Dbdict.cpp
Error object: DBDICT (Line: 3560) 0x0000000a
Program: ndbd
Pid: 24121
Trace: /data1/johan/mysqlcluster/ndb_2_trace.log.7
Version: mysql-5.1.23 ndb-6.3.7-beta
***EOM***

[19 Feb 2009 10:45] Jonas Oreland

Note: added error insert 6016/6017 for reproducing this

[21 Aug 2009 9:36] 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/81255

2964 Jonas Oreland	2009-08-21
      ndb - bug#36702
        Handle cluster crash during create file{group}

[21 Aug 2009 13:13] Bugs System

Pushed into 5.1.35-ndb-6.3.26 (revid:[e-mail]-20090821130746-x78pnclj4ph2s6l1) (version source revid:[e-mail]-20090821105549-gchec4bo08hcd7w2) (merge vers: 5.1.35-ndb-6.3.26) (pib:11)

[21 Aug 2009 13:13] Bugs System

Pushed into 5.1.35-ndb-7.0.7 (revid:[e-mail]-20090821131130-5ecm4jwh6itjov34) (version source revid:[e-mail]-20090821130134-pyd31rchtu4q8h51) (merge vers: 5.1.35-ndb-7.0.7) (pib:11)

[21 Aug 2009 13:14] Bugs System

Pushed into 5.1.35-ndb-7.1.0 (revid:[e-mail]-20090821131226-o6ub35a5eln0meis) (version source revid:[e-mail]-20090821130432-7tqdvg3puedi54qp) (merge vers: 5.1.35-ndb-7.1.0) (pib:11)

[21 Aug 2009 13:14] Bugs System

Pushed into 5.1.35-ndb-6.2.19 (revid:[e-mail]-20090821130547-d8i4pnm2hw7atv65) (version source revid:[e-mail]-20090821093523-b01c9nxwnp97x204) (merge vers: 5.1.35-ndb-6.2.19) (pib:11)

[21 Aug 2009 13:18] Jonas Oreland

pushed to 6.2.19, 6.3.26 and 7.0.7

[21 Aug 2009 14:28] Jon Stephens

Documented bugfix in the NDB-6.2.19, 6.3.26 and 7.0.7 changelogs, as follows:

        If the cluster crashed during the execution of a CREATE LOGFILE
        GROUP statement, the cluster could not be restarted afterwards.

        See also Bug #34102.