Bug #26716 random index corrupted but no error is reported, select returns 0 rows
Submitted: 28 Feb 2007 11:32 Modified: 12 Apr 2007 22:30
Reporter: xuefer tinys Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:5.0.32 OS:Linux (gentoo linux x86_64)
Assigned to: Assigned Account CPU Architecture:Any
Tags: index corrupted

[28 Feb 2007 11:32] xuefer tinys 
Description:
i have a myisam table that the one of the index will be random corrupted, select ... limit 0,100 returns empty result, but limit 100,100 (for example) do returns 100 rows.
repair table fixes it but the problem will come again randomly.

this does not happen before i upgrade to 5.0.32, my previous version was 4.0.x

How to repeat:
no idea yet
[28 Feb 2007 11:35] xuefer tinys 
i'll have u up to date and try to find a reproducable way (it's hard for me)
[28 Feb 2007 11:43] Sveta Smirnova 
Thank you for the report.

Please provide output of SHOW CREATE TABLE your_table and/or upload your_table.MYI, your_table.MYD and *.frm files
[6 Mar 2007 9:59] Sveta Smirnova 
Thank you for the aditional information and files.

Could you please also send content of your my.cnf file?
[12 Mar 2007 22:30] Sveta Smirnova 
Thank you for the configuration file and additional information.

But I can not repeat error with current development sources. Please try with current 5.0.36 Enterprise or 5.0.37 Community version and say us result.
[12 Apr 2007 23: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".