When you said that: " (...) 2.change master to where it was stopped", what did you do?
CHANGE MASTER TO .... ?
Did you stopped the slave before executing that command?
Have you tried to delete the file master.info?
On Mar 17, 2010, at 3:00 PM, Database System wrote:
> I have master to master replication ran was fine. One time admin re-booted one host
> and followed rebooted another one. After that, one of the masters was able to
> automatically re-connect to master and continue replication, but another master caould not
> resume replication.
> I did three things and all got same error message on the screen. (1. re-started
> slave; 2.change master to where it was stopped; 3. change master to current log file and
> position). The error message is:
> ERROR 1201 Could not initialize master info structure; more error messages can be
> found in the MySQL error log.
> In the error log, it only said cannot connect to sserver... Error reading relay
> log... read up to .... SQL thread killed ... Normal shutdown
> this log is the same as in another master and that server was able to re-connect.
> Any idea of how to recover the replication without dump and sync database?
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1