Bug #24521 ndbd node crashes if try to create many datafiles for tablespace
Submitted: 22 Nov 2006 20:52 Modified: 7 May 2009 14:59
Reporter: Serge Kozlov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S2 (Serious)
Version:5.1.14-bk OS:Linux (Linux FC4)
Assigned to: CPU Architecture:Any
Triage: Triaged: D2 (Serious) / R6 (Needs Assessment) / E6 (Needs Assessment)

[22 Nov 2006 20:52] Serge Kozlov
Description:
Data nodes died if to create many datafiles for table space.

How to repeat:
1. Create a new simple config.ini where added InitialNoOfOpenFiles=20 (or use from attached file)
2. Start cluster.
3. Run script (from attached file) as it described below:
./sqe.pl -q ats1.txt -p 127.0.0.1:3306:root
4. Wait while the script will stop and look into error and trace log files

Suggested fix:
Seems error is correct in error_log but why nodes die?
[24 Jan 2007 5:33] justin he
the patch for bug24521

Attachment: bug24521.patch (text/x-patch), 9.31 KiB.

[25 Jan 2007 16:30] Jonas Oreland
Hi,

Please do it as this instead.

- Have ndbfs send back a FSOPENREF with new error code instead.

/Jonas

ps. please ask by mail if description was unclear ds.
[29 Mar 2007 3:06] 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/23230

ChangeSet@1.2487, 2007-03-29 10:59:05+08:00, Justin.He@dev3-240.dev.cn.tlan +3 -0
  Bug#24521, ndbd node crashes if try to create many datafiles for tablespace
[7 Apr 2007 7:01] Bugs System
Pushed into 5.1.18-beta
[10 Apr 2007 11:17] 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.18 changelog.
[26 Nov 2008 16:35] Geert Vanderkelen
This isn't fixed. Adding lots of data files still segfaults the datanode using mysql-5.1.30-ndb-6.3.20.
I can add like 241 datafiles, and then one data node segfaults.

Attaching the logs.
[26 Nov 2008 16:36] Geert Vanderkelen
Logs while adding lots of datafiles to a tablespace

Attachment: ndb_error_report_20081126172139.tar.bz2 (application/octet-stream, text), 71.15 KiB.

[13 Mar 2009 9:05] Jonas Oreland
decreasing prio
based on (own) triage
[6 May 2009 7:45] 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/73457

2911 Jonas Oreland	2009-05-06
      ndb - bug#24521
        Don't try to free a file that was never created
[6 May 2009 7:46] 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/73458

2912 Jonas Oreland	2009-05-06
      ndb - bug#24521
          Don't try to free a file that was never created
[6 May 2009 12:07] Bugs System
Pushed into 5.1.32-ndb-6.3.25 (revid:jonas@mysql.com-20090506110937-wloyovra7v732nw6) (version source revid:jonas@mysql.com-20090506110937-wloyovra7v732nw6) (merge vers: 5.1.32-ndb-6.3.25) (pib:6)
[6 May 2009 12:08] Bugs System
Pushed into 5.1.32-ndb-7.0.6 (revid:jonas@mysql.com-20090506120323-js5j4twu5w71iy0a) (version source revid:jonas@mysql.com-20090506120323-js5j4twu5w71iy0a) (merge vers: 5.1.32-ndb-7.0.6) (pib:6)
[6 May 2009 12:09] Bugs System
Pushed into 5.1.32-ndb-6.2.18 (revid:jonas@mysql.com-20090506101635-2hm4lyqgtzhw8lmi) (version source revid:jonas@mysql.com-20090506074420-euxc02x4y8vxstlh) (merge vers: 5.1.32-ndb-6.2.18) (pib:6)
[7 May 2009 14:59] Jon Stephens
Documented new fix in the NDB-6.2.18, 6.3.25, and 7.0.6 changelogs. Closed.