MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error on master: 'Incorrect key file for table '%-.64s'
4038
Arnaud Lesauvage
September 06, 2005 05:01AM
Re: Error on master: 'Incorrect key file for table '%-.64s'
2511
Wolfgang Riedel
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.