Bug #25992 Data nodes died during creating many tables based on different tablespaces
Submitted: 31 Jan 2007 22:14 Modified: 23 Mar 2007 11:49
Reporter: Serge Kozlov
Status: Closed
Category:Server: ClusterDD Severity:S2 (Serious)
Version:5.1.16-bk OS:Linux (Linux FC4 64bit)
Assigned to: Bugs System Target Version:

[31 Jan 2007 22: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 3: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 18: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 4: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 10:57] Jonas Oreland 
if you tested this backward and forward some, it's ok to push
[12 Mar 2007 3:43] Guangbao Ni 
Approved by Jonas, and push into mysql-5.1-new-ndb-bj.
[23 Mar 2007 11: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.