Bug #27635 | Creating Logfile group fails | ||
---|---|---|---|
Submitted: | 4 Apr 2007 6:16 | Modified: | 27 Nov 2008 11:35 |
Reporter: | Andrew Bishop | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S1 (Critical) |
Version: | 5.1 | OS: | Linux (Red Hat 9) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[4 Apr 2007 6:16]
Andrew Bishop
[5 Apr 2007 21:53]
Hartmut Holzgraefe
can you do a SHOW ERRORS when you get this (there may be additional error messages in there) and provide us with the cluster logs, or at least the error and trace logs of the failing node, too?
[11 Apr 2007 4:37]
Andrew Bishop
CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo1.dat' INITIAL_SIZE 100M UNDO_BUFFER_SIZE = 10M ENGINE=NDB; Show errors +-------+------+-------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------+ | Error | 1296 | Got error 4009 'Cluster Failure' from NDB | | Error | 1516 | Failed to create UNDOFILE | +-------+------+-------------------------------------------+ 2 rows in set (0.00 sec) ndb_1_out.log NDB Cluster Management Server. Version 5.1.16 (beta) Id: 1, Command port: 1186 setEventReportingLevelImpl: failed 2!
[11 Apr 2007 4:39]
Andrew Bishop
node error log
Attachment: ndb_3_error.log (application/octet-stream, text), 1.53 KiB.
[11 Apr 2007 4:40]
Andrew Bishop
node out log
Attachment: ndb_3_out.log (application/octet-stream, text), 5.06 KiB.
[11 Apr 2007 4:40]
Andrew Bishop
managment node out log
Attachment: ndb_1_out.log (application/octet-stream, text), 117 bytes.
[11 Apr 2007 4:41]
Andrew Bishop
management node cluster log
Attachment: ndb_1_cluster.log (application/octet-stream, text), 62.38 KiB.
[15 May 2007 7:28]
Tomas Ulin
Andrew, we see only the restart failures in the logs you supplied. this bug that you are hitting ar system restart is most likely the same as 17614. You've managed to get into a state when you have a log file groups and no undo file... What we'd like to try to understand is how that could happen. Do you have the logs from the time when the the first error occurred, when first creating the adding the undo file... BR, Tomas
[23 May 2007 4:01]
Andrew Bishop
Sorry I dont have the log file from when this happend, but the log files I added where from a clean install of mysql.
[27 Oct 2008 11:35]
Frazer Clement
Unfortunately there is not enough information in this report to reproduce the original issue. The bug is marked against telco-6.3, but appears to be a 5.1 issue. As mentioned previously, there is a known issue during system restart when an undo file is missing (can be reproduced by deleting an undofile, then attempting SR). See bug 17614. What is missing from this bug report is the trace file (mentioned in the error log) corresponding to the initial failure, when the undo file could not be created, and the node crashed for the first time. If possible, could you send the trace file mentioned, or reproduce and send it?
[28 Nov 2008 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".