Bug #1852 cannot repair MyISAM crashed compressed table
Submitted: 16 Nov 2003 11:50 Modified: 17 Nov 2003 8:03
Reporter: Martin Mokrejs Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.0.16 OS:Linux (Linux 2.4.20)
Assigned to: Dean Ellis CPU Architecture:Any

[16 Nov 2003 11:50] Martin Mokrejs 
Description:
This bug I have already reported and was thought to be fixed in 4.0.14 or 4.0.15 I think, but doesn't seem so. myisamchk -rq never finishes on the table.

How to repeat:
support.mysql.com/pub/mysql/secret/Drosophila_melanogaster.tar.gz

unpack
mysql> truncate table contig_data;
mysql> flush tables;
quit
myisampack contig_data.MYI
myisamchk -rq contig_data.MYI
cp contig_data.MYD- contig_data.MYD
myisamchk -rq contig_data.MYI [will never finish]
[17 Nov 2003 8:03] Dean Ellis 
I cannot duplicate this using 4.0.17 from the latest BitKeeper sources.  The table repairs successfully.

Thank you.