Bug #13826 Crash when creating undofile /tmp/undofile.dat
Submitted: 7 Oct 2005 1:49 Modified: 10 Jan 2006 10:10
Reporter: Stewart Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1-ndb-dd OS:Linux (Linux)
Assigned to: Jonas Oreland CPU Architecture:Any

[7 Oct 2005 1:49] Stewart Smith
Description:
crash of ndbd when trying to create a logfile group with an undofile at /tmp/undofile.dat

Date/Time: Friday 7 October 2005 - 04:45:32
Type of error: error
Message: No message slogan found
Fault ID: 0
Problem data: Signal 6 received
Object of reference: main.cpp
ProgramName: /home/stewart/Documents/MySQL/5.1/ndb-dd/storage/ndb/src/kernel/ndbd
ProcessID: 21874
TraceFile: /home/stewart/Documents/MySQL/5.1/ndb-dd/mysql-test/var/ndbcluster-9350/ndb_1_trace.log.1
Version 5.1.2 (alpha)
***EO
Date/Time: Friday 7 October 2005 - 04:47:26
Type of error: error
Message: Internal program error
Fault ID: 2307
Problem data: WatchDog terminate
Object of reference: WatchDog.cpp
ProgramName: /home/stewart/Documents/MySQL/5.1/ndb-dd/storage/ndb/src/kernel/ndbd
ProcessID: 21874
TraceFile: /home/stewart/Documents/MySQL/5.1/ndb-dd/mysql-test/var/ndbcluster-9350/ndb_1_trace.log.2
Version 5.1.2 (alpha

Will attach trace.

How to repeat:
mysql> CREATE LOGFILE GROUP lg1 ADD UNDOFILE '/tmp/undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect...
Connection id:    1
Current database: test

ERROR 1491 (HY000): Failed to create UNDOFILE
mysql> show errors;
+-------+------+---------------------------+
| Level | Code | Message                   |
+-------+------+---------------------------+
| Error | 1491 | Failed to create UNDOFILE |
+-------+------+---------------------------+
1 row in set (0.00 sec)

mysql> CREATE LOGFILE GROUP lg1 ADD UNDOFILE '/tmp/undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB;
ERROR 1491 (HY000): Failed to create LOGFILE GROUP
mysql> CREATE LOGFILE GROUP lg1 ADD UNDOFILE '/tmp/undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB;
ERROR 1491 (HY000): Failed to create LOGFILE GROUP
mysql>

(ndbd crashes after first create)

Suggested fix:
create the LFG and UF successfully.
[7 Oct 2005 1:51] Stewart Smith
ndbd node 1 trace

Attachment: ndb_1_trace.log.1.gz (application/x-gzip, text), 45.28 KiB.

[10 Jan 2006 10:10] Jonas Oreland
Fixed...(error handling)
however if you run two nodes on same computer using absolute path's will not work.
as both nodes will create file on exact same place...and only one of them can succeed...