Hi everyone,
Replication has been working OK for me for the last month or
with mysql 3.23.38, however following a crash I am having a lot of problems.
This is happening constantly: replication will work for a while
and then stop with the following:
mysql> show slave status;
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File
| | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno |
|Last_error
|
| | Skip_counter |
| unisondb1.internal.nw | repl | 3306 | 60 |
|unisondb1-bin.001 | 20887103 | No | |
|| 1016 | error 'Can't open file: 'stories.MYD'. (errno: 145)' on query 'INSERT
|into stories(issue_id,category_id,rank,story_content_id,dated,timed,valid_until)
values('39','38','3','443498','2001-07-05','17:15:25','2001-07-15')'
| 0 |
error 145 indicates that the table has a problem and needs to be repaired.
However, I have no problem in running the sql manually!
So, off I go and do a bunch of myisamchks on the table with every incantation
I can think of, all showing no problems at all.
I have tried going through the binlog on the master manually adding each
bit of sql that fails (always on this one table) - which has worked before -
and eventually the slave thread fires up again.
Any ideas at all would be much appreciated.
Many thanks,
John.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
