Bug #45965 In mysql clusterr can't create many datafile for tablespace

• Submitted: 6 Jul 2009 10:00
• Modified: 21 Jul 2009 7:56
• Reporter: ws lee
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S1 (Critical)
• Version: mysql5.1.27-ndb6.3.17
• OS: Solaris (5.10)
• Assigned to: Sveta Smirnova
• CPU Architecture: Any

[6 Jul 2009 10:00] ws lee

Description:
In mysql clusterr can't create many datafile for tablespace.

How to repeat:
1.firstly, create 40 undofile with size 128M

CREATE LOGFILE GROUP lg ADD UNDOFILE 'undo1.dat' INITIAL_SIZE 134283264 ENGINE=ndbcluster;
ALTER LOGFILE GROUP lg ADD UNDOFILE 'undo2.dat' INITIAL_SIZE 134283264 ENGINE=ndbcluster;
ALTER LOGFILE GROUP lg ADD UNDOFILE 'undo3.dat' INITIAL_SIZE 134283264 ENGINE=ndbcluster;
...
...
...
ALTER LOGFILE GROUP lg ADD UNDOFILE 'undo39.dat' INITIAL_SIZE 134283264 ENGINE=ndbcluster;
ALTER LOGFILE GROUP lg ADD UNDOFILE 'undo40.dat' INITIAL_SIZE 134283264 ENGINE=ndbcluster;

2. in next create 98 datafile for tablespace

CREATE TABLESPACE ts1 ADD DATAFILE 'data1_1.dat' USE LOGFILE GROUP lg INITIAL_SIZE ENGINE=ndbcluster;
bcluster;
ALTER TABLESPACE ts1 ADD DATAFILE 'data1_2.dat' ENGINE=ndbcluster;
ALTER TABLESPACE ts1 ADD DATAFILE 'data1_3.dat' ENGINE=ndbcluster;
.....
.....
ALTER TABLESPACE ts1 ADD DATAFILE 'data1_97.dat' ENGINE=ndbcluster;
ALTER TABLESPACE ts1 ADD DATAFILE 'data1_98.dat' ENGINE=ndbcluster;

in progress of creating data1_98.dat, stop.
never progress next creating datafile.

[16 Jul 2009 11:24] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior.

Please provide your configuration file. Also indicate accurate version of package you use (file name) or configure options if you built yourself.

[21 Jul 2009 7:56] ws lee

To. Sveta Smirnova
thanks your reply.

this problem seems to caused by console of mysql client and my ssh tool.
mysql> ....
mysql> ALTER TABLESPACE ts1 ADD DATAFILE  'data1_96.dat' ENGINE=ndbcluster;
mysql> ALTER TABLESPACE ts1 ADD DATAFILE  'data1_97.dat' ENGINE=ndbcluster;
mysql> ALTER TABLESPACE ts1 ADD DATAFILE  'data1_98.dat' ENGINE=ndbcluster;
mysql> ....

but, in below case, no problem.
mysql -uroot -p < create_tablespace_datafile.sql