MySQL Forums
Forum List  »  MyISAM

Re: "Incorrect key file for table XXXX"
Posted by: Wilfried Wolf
Date: July 14, 2005 05:42AM

hello,

exactly what i am experiencing for a while, no idea though how to reproduce the error.

i thought it would be a problem replicating a 3.53.x master to a 4.0.x slave but reading this error-descriptions it does not seem so to me.

maybe i have some hints, but i dont know.
in my case the error allways occurs in the same table "pagesContent2"

it has got an "int" primary key, three "text" fields, a "longtext" field and one of the text and the long text field have a fulltext key on them.

the application often checks other databases and does INSERT SELECT statements accross database borders.

when i check the consitency of the master table pagesContent2 it says "ok"

i always start the database again, which unfortunately causes downtimes of the server and the contentmanagementsystem.

so in addition to my report i wanted to ask, if issuing a "REPAIR TABLE" on the master might solve the problem. is there a way of "restarting" the slave after such an error?

thanks for your help.

best regards,

willi

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: "Incorrect key file for table XXXX"
24443
July 14, 2005 05:42AM
15671
September 16, 2005 07:32AM
11576
September 19, 2005 01:25AM
16725
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.