Bug #36882 Tables corruped + tables on slave corrupted too
Submitted: 22 May 2008 9:26 Modified: 18 May 2009 13:55
Reporter: Cyril SCETBON Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S1 (Critical)
Version:mysql-5.1.-telco-6.3 OS:Linux (debian etch)
Assigned to: CPU Architecture:Any
Tags: 5.1.24-ndb-6.3.13-telco

[22 May 2008 9:26] Cyril SCETBON 
Description:
ERROR 1033 (HY000): Incorrect information in file: './spp/spp.frm'

tables on the slave (replication between 2 clusters) are corrupted too.

We checked the binlog and the last event before the corruption is the following :

# at 4
#080521  6:26:23 server id 66  end_log_pos 107 
# Position  Timestamp   Type   Master ID        Size      Master Pos    Flags 
#        4 6f a4 33 48   0f   42 00 00 00   67 00 00 00   6b 00 00 00   00 00
#       17 04 00 35 2e 31 2e 32 34  2d 6e 64 62 2d 36 2e 33 |..5.1.24.ndb.6.3|
#       27 2e 31 33 2d 74 65 6c 63  6f 2d 30 68 65 62 65 78 |.13.telco.0hebex|
#       37 32 2d 6c 6f 67 00 00 00  00 00 00 00 00 00 00 00 |2.log...........|
#       47 00 00 00 00 00 00 00 00  13 38 0d 00 08 00 12 00 |.........8......|
#       57 04 04 04 04 12 00 00 54  00 04 1a 08 00 00 00 08 |.......T........|
#       67 08 08 02 00  |....|
#       Start: binlog v 4, server v 5.1.24-ndb-6.3.13-telco-0hebex2-log created 080521  6:26:23
BINLOG '
b6QzSA9CAAAAZwAAAGsAAAAAAAQANS4xLjI0LW5kYi02LjMuMTMtdGVsY28tMGhlYmV4Mi1sb2cA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==
'/*!*/;
# at 107

We got 3 tables : 1 ndb memory & 2 ndb disk tables
after this event all the tables are corrupted but we can create a new one in memory without error.

How to repeat:
none

Suggested fix:
none
[28 Jan 2009 19:12] Hartmut Holzgraefe 
Probably to late to ask for this, but could you provide the
CREATE statement for the corrupted table, the binlog file and
all cluster and mysqld log files related to this incident?
[29 Jan 2009 8:25] Cyril SCETBON 
you're right. It's too late :-(
[18 May 2009 13:39] Jonathan Miller 
Not enough information for us to work on this. In future please provide logs, creates and how to repeat.
[18 May 2009 13:55] Cyril SCETBON 
If I could have reproduced it I would have informed you.