Bug #25992 Data nodes died during creating many tables based on different tablespaces
Submitted: 31 Jan 2007 21:14 Modified: 23 Mar 2007 10:49
Reporter: Serge Kozlov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S2 (Serious)
Version:5.1.16-bk OS:Linux (Linux FC4 64bit)
Assigned to: Guangbao Ni CPU Architecture:Any

[31 Jan 2007 21:14] Serge Kozlov 
Description:
There is a script which tries to create 100 tablespaces with one datafile for each and then creates one table for each tablespace. During execution this script both data nodes crashed with following error:

Current byte-offset of file-pointer is: 568

Time: Wednesday 31 January 2007 - 21:47:27
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: 1093) 0x0000000e
Program: ./builds/libexec/ndbd
Pid: 4524
Trace: /space/run/ndb_3_trace.log.1
Version: Version 5.1.16 (beta)
***EOM***

How to repeat:
1. Start cluster with following options in config.ini:
NoOfReplicas: 2
DataMemory: 1000M
IndexMemory: 500M
MaxNoOfOpenFiles: 1K

2. Run script:
./sqe.pl -q bb1.txt -p=127.0.0.1:3306:root::test

3. Wait while errors will appear during execution of script.
[28 Feb 2007 2: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/20721

ChangeSet@1.2437, 2007-02-28 10:34:58+08:00, gni@dev3-221.dev.cn.tlan +1 -0
  BUG#25992 Data nodes died during creating many tables based on different tablespaces.
[3 Mar 2007 17:36] Jonas Oreland 
i think the fix looks incorrect.
i think the ndbrequire looks incorrect and should be removed.
  there is no reason not to allow objects with id > c_tableRecordPool.size()

/Jonas
[5 Mar 2007 3:27] 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/21103

ChangeSet@1.2437, 2007-03-05 11:25:44+08:00, gni@dev3-221.dev.cn.tlan +1 -0
  BUG#25992 Data nodes died during creating many tables based on different tablespaces.
[7 Mar 2007 9:57] Jonas Oreland 
if you tested this backward and forward some, it's ok to push
[12 Mar 2007 2:43] Guangbao Ni 
Approved by Jonas, and push into mysql-5.1-new-ndb-bj.
[23 Mar 2007 10:49] 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 bugfix in 5.1.17 changelog.