MySQL Forums
Forum List  »  MyISAM

Re: ERROR 126 (HY000): Incorrect key file for table
Posted by: michael brenden
Date: May 23, 2008 04:26AM

Experienced same problem here (err 126) 4 times in a row 12 hours ago, on 5.1.22rc on ubuntu 6.06 on amd 64 w/ 2G RAM. Repairs with myisamchk -r and then myisamchk -o succeeded, but deletion of one row (out of 74,500) failed with err 126 four times. "Repair table" with phpMyAdmin finally worked and stuck.

Never a problem after least two years solid use (and maybe two months since upgrading to 5.1.22rc). Only recent change was, yesterday, getting part of the first-time master-master replication working (it's currently one way, from the main master to its slave)...then the corruption tantrum flared up (in a database not replicated). Replication still running, though no corruption in 12 hours since repair with phpmyadmin worked and stuck.

Very strange and unwelcome. Will report any further problems here.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 126 (HY000): Incorrect key file for table
7875
May 23, 2008 04:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.