MySQL Forums
Forum List  »  MyISAM

"Incorrect key file for table XXXX"
Posted by: Christian Neise
Date: March 11, 2005 04:40PM

Hallo,

on a mysql replication slave i often get the following error message:

Error 'Incorrect key file for table: 'XXXXX'. Try to repair it'

This error occurs for different tables, but on the same slave. It occurs 1-3 time a week. After doing a "repair table XXXXX" everything is fine.

I suspected a hardware problem, but i did a badblocks -w without errors (bevor installing the system). The provider i rented the server from has done a memtest widthout errors (so he says).

Server is a AMD 64 with the current version of Gentoo Linux.

Kernel logs show no hardware problems.

Any hints?

Thanks & best regards,

Christian.

Options: ReplyQuote


Subject
Views
Written By
Posted
"Incorrect key file for table XXXX"
80130
March 11, 2005 04:40PM
15587
September 16, 2005 07:32AM
11517
September 19, 2005 01:25AM
16614
November 01, 2007 01:12PM


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.