Bug #5702 | cluster goes down during an alter table | ||
---|---|---|---|
Submitted: | 22 Sep 2004 14:49 | Modified: | 28 Sep 2004 7:02 |
Reporter: | Tomas Ulin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
Version: | 4.1.5 source | OS: | Linux (linux 2.6) |
Assigned to: | Jonas Oreland | CPU Architecture: | Any |
[22 Sep 2004 14:49]
Tomas Ulin
[22 Sep 2004 15:16]
Tomas Ulin
cuts from error log and trace (2-node cluster). Both nodes fail on same place: Date/Time: Wednesday 22 September 2004 - 16:17:48 Type of error: error Message: Internal program error (failed ndbrequire) Fault ID: 2341 Problem data: Dbdict.cpp Object of reference: DBDICT (Line: 9274) 0x0000000a ProgramName: NDB Kernel ProcessID: 14470 TraceFile: /home/tomas/mysql/mysql-test/ndbcluster-2200/ndb_2_trace.log.3 ***EOM*** From trace file: DBTUP 002032 DBDICT 006545 006551 006553 DBDICT 006545 006551 006692 DBDICT 006624 006641 006681 006722 DBDICT 009035 009045 009053 DBDICT 009035 009045 009280 DBDICT 009133 009151 009263 009508 009557 DBDICT 009035 009099 009350 009355 DBDICT 009133 009151 009274 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657894 gsn: 605 "ALTER_INDX_CONF" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657893 length: 3 trace: 0 #sec: 0 fragInf: 0 H'00fa0002 H'00000002 H'00000050 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657893 gsn: 603 "ALTER_INDX_REQ" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657892 length: 7 trace: 0 #sec: 0 fragInf: 0 H'00fa0002 H'00000002 H'00000050 H'0000000e H'00000010 H'00000003 H'00000000 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657892 gsn: 605 "ALTER_INDX_CONF" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657891 length: 3 trace: 0 #sec: 0 fragInf: 0 H'00fa0002 H'00000002 H'00000010 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657891 gsn: 603 "ALTER_INDX_REQ" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657890 length: 8 trace: 0 #sec: 0 fragInf: 0 H'00fa0002 H'00000001 H'00000003 H'0000000e H'00000010 H'00000003 H'00000000 H'00000002 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657890 gsn: 603 "ALTER_INDX_REQ" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657889 length: 7 trace: 0 #sec: 0 fragInf: 0 H'00fa0002 H'00000001 H'00000003 H'0000000e H'00000010 H'00000003 H'00000000 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657889 gsn: 517 "DROP_INDX_CONF" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657888 length: 3 trace: 0 #sec: 0 fragInf: 0 H'00000001 H'00fa0002 H'00000010 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657888 gsn: 516 "DROP_INDX_REQ" prio: 1 s.bn: 250 "DBDICT", s.proc: 2, s.sigId: 1657887 length: 7 trace: 0 #sec: 0 fragInf: 0 H'00000000 H'80020004 H'00000001 H'ffffffff H'00000010 H'00000003 H'00000001 --------------- Signal ---------------- r.bn: 250 "DBDICT", r.proc: 2, r.sigId: 1657887 gsn: 516 "DROP_INDX_REQ" prio: 1 s.bn: 32770 "API", s.proc: 4, s.sigId: 0 length: 6 trace: 0 #sec: 0 fragInf: 0 H'00000000 H'80020004 H'00000001 H'ffffffff H'00000010 H'00000003
[22 Sep 2004 15:26]
Martin Skold
Looks like this is part of the drop table (with drop index) in the end of the alter table.
[28 Sep 2004 7:02]
Tomas Ulin
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html