MySQL Forums
Forum List  »  Replication

Can't restart slave - Could not initialize master info structure
Posted by: Rasmus U
Date: April 23, 2009 07:03AM

Hi, I've set up replication for backup/logging/statistics purposes. Everything is working okay, EXCEPT if the slave server i down more than a few hours/days, I can't restart the slave process.

The error message is
ERROR 1201 (HY000): Could not initialize master info structure;


[ERROR]Failed to open the relay log '/var/run/mysqld/....'
[ERROR] Could not find target log during relay log initialization

As I understand, the logs get flushed after prolonged downtime/reboot.

Is it any way I can configure the slave server, so that it'll catch up with the master server, without me having to get a new snapshot/master position etc (which is a cumbersome process). - The slave already knows the last position it has reached at the master, so I do not understand the significance of the relay log...

Does it make a difference whether the slave is STOPped before stopping the mysqld service?

Thanks for your help!

Edited 1 time(s). Last edit at 04/23/2009 07:03AM by Rasmus U.

Options: ReplyQuote

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.