Bug #46846 I can't create many undo logfile in mysql cluster

Submitted:	21 Aug 2009 2:54	Modified:	27 Aug 2009 10:11
Reporter:	ws lee	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Cluster: Disk Data	Severity:	S1 (Critical)
Version:	mysql5.1-telco-6.3, 5.1-telco-7.0	OS:	Solaris (5.10)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	mysql5.1.32-ndb6.3.24

Description:
I can't create many undo logfile.
In my environment, mysql clusgter occured error if undo file create over 237 number.

How to repeat:
config.ini
----------
[NDBD DEFAULT]
NoOfReplicas=1
DataMemory=500M
IndexMemory=50M

datadir=/var/lib/mysql-cluster5.1.32-ndb6.3.24

[NDBD]
hostname=localhost

[NDB_MGMD DEFAULT]
datadir=/var/lib/mysql-cluster5.1.32-ndb6.3.24

[NDB_MGMD]
hostname=localhost

[MYSQLD]
hostname=localhost
-----------------

my.cnf
--------------
[MYSQL_CLUSTER]
ndb-connectstring="host=localhost"

[MYSQLD]                        
ndbcluster
-----------------

create_unodfile.sh
-----------
MYSQL_DIR=/usr/local/mysql5.1.32-ndb6.3.24

i=0
while [ $i -le 500 ]
do
        i=`expr $i + 1`
        echo "i = $i"
        if [ $i = 1 ] 
        then
                CMD=`$MYSQL_DIR/bin/mysql -uroot -e"CREATE LOGFILE GROUP lg ADD UNDOFILE 'undo${i}.dat' ENGINE=ndbcluster" 2>&1`
        else
                CMD=`$MYSQL_DIR/bin/mysql -uroot -e"ALTER LOGFILE GROUP lg ADD UNDOFILE 'undo${i}.dat'ENGINE=ndbcluster" 2>&1`
        fi
        if [ -n "$CMD" ]
        then
                echo $CMD
                exit
        fi      
done
-----------------------------------

Run create_unodfile.sh
./create_unodfile.sh
i = 1
...
...
...
i = 235
i = 236
i = 237
ERROR 1533 (HY000) at line 1: Failed to alter: CREATE UNDOFILE

In my server, mysql occured error, in undofile 237 number
In this time, data node log is like below.

cat ndb_1_out.log
...
...
2009-08-21 11:22:29 [ndbd] INFO     -- DBDICT: File system open failed during FsConnectRecord state 1. OS errno: 24
2009-08-21 11:22:29 [ndbd] INFO     -- DBDICT (Line: 814) 0x0000000a
2009-08-21 11:22:29 [ndbd] INFO     -- Error handler shutting down system
2009-08-21 11:22:30 [ndbd] INFO     -- Error handler shutdown completed - exiting
2009-08-21 11:22:31 [ndbd] ALERT    -- Node 1: Forced node shutdown completed. Caused by error 2814: 'System reports no more file system resources(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
......
]

Thank you for the report.

Verified as described. Problem only repeatable on Solaris. On Linux everything works fine.

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.