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'.
......
]