MySQL Forums
Forum List  »  Replication

Re: Error on master: 'Incorrect key file for table '%-.64s'
Posted by: Wolfgang Riedel
Date: September 16, 2005 07:03AM

I've a similar problem, but unfortunetaly no solution.
After running my mysql server 4.1.7 (LInux) with replication over some months without any problem, suddenly the slave's sql thread crashes:
Error on master: 'Table '%-.64s.%-.64s' doesn't exist' (1146), Error on slave: 'no error' ...
I have searched the position in err-log: the return code 1146 occurs for a "OPTIMIZE TABLE ..." and the following "SET ONE_SHOT CHARACTER_SET_CLIENT=...". If I execute these commands by hand at the master server, no error returns.
What does it all mean? Which table doesn't exist?

Thanx, Wolfgang

Options: ReplyQuote

Written By
Re: Error on master: 'Incorrect key file for table '%-.64s'
September 16, 2005 07:03AM

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.