Bug #36702 System restart fails after LOGFILE creation error

Submitted: 13 May 2008 22:05 Modified: 21 Aug 2009 14:28
Reporter: Hartmut Holzgraefe Email Updates:
Status: Closed Impact on me:
None 
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:jonas@mysql.com-20090821130746-x78pnclj4ph2s6l1) (version source revid:jonas@mysql.com-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:jonas@mysql.com-20090821131130-5ecm4jwh6itjov34) (version source revid:jonas@mysql.com-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:jonas@mysql.com-20090821131226-o6ub35a5eln0meis) (version source revid:jonas@mysql.com-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:jonas@mysql.com-20090821130547-d8i4pnm2hw7atv65) (version source revid:jonas@mysql.com-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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.062 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.