Bug #25743 If initial_size less than undo_buffer_size (for LG) then ndbd nodes are crashed
Submitted: 21 Jan 2007 18:03 Modified: 23 Mar 2007 10:28
Reporter: Serge Kozlov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S2 (Serious)
Version:5.1.15-bk OS:Linux (Linux FC4 64bit)
Assigned to: Guangbao Ni CPU Architecture:Any

[21 Jan 2007 18:03] Serge Kozlov 
Description:
All data nodes are crashed if during creating logfile group initial_size less than undo_buffer_size.

Current byte-offset of file-pointer is: 568

Time: Sunday 21 January 2007 - 18:50:43
Status: Temporary error, restart node
Message: Error OS signal received (Internal error, programming error or missing
error message, please report a bug)
Error: 6000
Error data: Signal 11 received; Segmentation fault
Error object: main.cpp
Program: ./builds/libexec/ndbd
Pid: 15470
Trace: /space/run/ndb_3_trace.log.1
Version: Version 5.1.15 (beta)
***EOM***

How to repeat:
1. Start cluster
2. Run mysql
3. Repeat the following:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.15-beta-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test;
Database changed
mysql> create logfile group lg1 add undofile 'undofile.dat' initial_size=20M un
do_buffer_size=21M engine=ndb;
ERROR 1516 (HY000): Failed to create UNDOFILE
mysql>

Suggested fix:
It seems that the error message is correct but why both data nodes die...
[23 Jan 2007 3:06] Jonas Oreland 
Hi,

interesting...

1) you did ofcourse try with other sizes matching decription
e.g initial_size=10m undo_buffer_size=11m or similar

2) could you attatch error log + tracefile anyway...
   (so I can look here online...)

/Jonas
[8 Mar 2007 9:35] 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/21469

ChangeSet@1.2441, 2007-03-08 17:33:30+08:00, gni@dev3-221.dev.cn.tlan +1 -0
  BUG#25743 If undo_buffer_size (for LG) greater than the inital shared memory (default 20M), 
            ndbd nodes are crashed
[8 Mar 2007 9:48] 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/21470

ChangeSet@1.2441, 2007-03-08 17:47:13+08:00, gni@dev3-221.dev.cn.tlan +1 -0
  BUG#25743 If undo_buffer_size (for LG) greater than the inital shared memory (default 20M), 
            ndbd nodes are crashed
[9 Mar 2007 3:41] 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/21551
[9 Mar 2007 8:54] Guangbao Ni 
Approved by Jonas, merge into mysql-5.1-new-ndb-bj.
[16 Mar 2007 5:42] Jon Stephens 
Documented fix for ndb-6.1.5 (MCCGE) release.
[22 Mar 2007 20:03] Mads Martin Joergensen 
Fixed in 5.1.17
[23 Mar 2007 10:28] 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 fix in 5.1.17 changelog.