Bug #1436 errno 145, table corruption
Submitted: 30 Sep 2003 0:42 Modified: 30 Sep 2003 11:43
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.14 (src) OS:Linux (Redhat 9.0)
Assigned to: CPU Architecture:Any

[30 Sep 2003 0:42] [ name withheld ]
Description:
Unpredictable table corruption. Different tables are affected. The corruption is not periodic or follows any logic.

How to repeat:
No idea.
[30 Sep 2003 0:42] [ name withheld ]
corrupted table part 1

Attachment: Objekte.frm (application/octet-stream, text), 8.91 KiB.

[30 Sep 2003 0:43] [ name withheld ]
corrupted table part 2

Attachment: Objekte.MYD (application/octet-stream, text), 57.61 KiB.

[30 Sep 2003 0:44] [ name withheld ]
Last repair of this table yields to a lost of some rows.
[30 Sep 2003 4:16] [ name withheld ]
corrupted table part 3

Attachment: Objekte.MYI (application/octet-stream, text), 6.00 KiB.

[30 Sep 2003 11:43] Indrek Siitan
Please try upgrading to 4.0.15 - multiple corruption-related bugs were fixed there.
[1 Oct 2003 1:14] [ name withheld ]
Today I'll upgrade to version 4.0.15. Unfortunatly I can do it only on the test system where the error occured. On the production system I have to wait a bit.
[14 Oct 2003 2:46] [ name withheld ]
The error occured again. Version: 4.0.15a

I'll post the corrupted tables...
[14 Oct 2003 2:49] [ name withheld ]
2nd table part 1

Attachment: Ansichten.frm (application/octet-stream, text), 8.71 KiB.

[14 Oct 2003 2:50] [ name withheld ]
2nd table part 3

Attachment: Ansichten.MYI (application/octet-stream, text), 21.00 KiB.

[14 Oct 2003 2:51] [ name withheld ]
2nd table part 2 (zipped)

Attachment: Ansichten.zip (application/x-zip-compressed, text), 78.29 KiB.