Red Hat Bugzilla – Bug 507296
Databases created by MySQL v4 are corrupted when using F11
Last modified: 2013-07-02 23:23:01 EDT
Description of problem:
There is a problem with the mysql_upgrade program where it is failing to update tables created with mysql v4 such that they appear corrupted can can't be accessed within v5.1
Version-Release number of selected component (if applicable):
Not sure - but many people have seen this. There are reproducible test cases available
Steps to Reproduce:
1. Create a database in mysql v4
2. Update mysql to 5.1
3. Run mysqlcheck on the database
Errors such as:
warning : Table is marked as crashed
warning : Size of indexfile is: 1975296 Should be: 1572864
error : Found key at page 180224 that points to record outside datafile
error : Corrupt
Error : Incorrect key file for table 'Clone_hit'; try to repair it
error : Corrupt
Repair table (even with use_frm) can't fix this, neither can isamchk. Apparently it requires a dump from the old verion, completely deleting the files under /var/lib/mysql (apart from the mysql tables), and then a restore to get things working again.
This could potentially cause big problems.
Tables are upgraded properly from older versions.
There is an upstream report of this, which suggests that this is fixed in v5.1.35 but I've not been able to verify that this solves the problem and the bug page isn't exactly chock full of reports that it works. The upstream bug is at:
Please add your comments to the existing upstream bug --- I am not in a position to fix this for you.
I'll keep track of the upstream bug, but consider this a placeholder for a request to the patched version of mysql as soon as it's released.
I'm sure others will be hitting this bug at some point so this should also hopefully be useful to point them to the upstream problem.
FWIW, 5.1.35 is in updates-testing now.
5.1.35 fixes this problem for me. Let me know if you want me to report this in the buildsystem to help get this pushed out.
Given that, I'll go ahead and mark it for stable --- it's been in testing a few days already.
mysql-5.1.35-1.fc11 has been pushed to the Fedora 11 stable repository. If problems still persist, please make note of it in this bug report.