MySQL Forums :: Replication :: Can't restart slave - Could not initialize master info structure


Advanced Search

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;

and

[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


Subject Views Written By Posted
Can't restart slave - Could not initialize master info structure 9213 Rasmus U 04/23/2009 07:03AM
Re: Can't restart slave - Could not initialize master info structure 4149 Rick James 04/24/2009 10:44PM
Re: Can't restart slave - Could not initialize master info structure 3308 Rasmus U 04/28/2009 03:11AM
Re: Can't restart slave - Could not initialize master info structure 3046 Rick James 04/28/2009 10:44PM
Re: Can't restart slave - Could not initialize master info structure 2893 Rasmus U 04/29/2009 09:19AM
Re: Can't restart slave - Could not initialize master info structure 3011 Rick James 04/29/2009 08:39PM
Re: Can't restart slave - Could not initialize master info structure 3632 Rasmus U 04/30/2009 04:42AM
Re: Can't restart slave - Could not initialize master info structure 2816 Vishwanath Patil 06/19/2009 03:51AM


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.