MySQL Forums
Forum List  »  Replication

Could not initialize master info structure, more error messages can be found in the MySQL error log
Posted by: Prakash Nallusamy
Date: July 19, 2007 09:23AM

Hi,
I am facing this issue.

I am having 1 master server and 7 slaves .

due to some problem one of my slave got out of sync with master.

wen i tried to start the slave am getting this error :

mysql> start slave;
ERROR 1201: Could not initialize master info structure, more error messages can be found in the MySQL error log

my mysqlbinlog file contains :

070719 15:53:36 Could not find target log during relay log initialization070719 15:57:38 Failed to open the relay log 'sn-uk-1-relay-bin.027' (relay_log_pos 458832187)


and I have searched google and i got some information with that i have tried in this way



mysql> CHANGE MASTER TO master_log_file='sn-sj-1-bin.021',master_log_pos=275410644;
ERROR 1201: Could not initialize master info structure, more error messages can be found in the MySQL error log

but still am getting this error.

Note :

My master server is having the version :4.0.20

One of my slave which is out of sync with master is having the version :4.0.18

Above problem is because of version problem ?.
If version is the problem then how to make the slave with sync with master without changing the version.

else

if version differ is not the problem then how can i reslove this problem .
please help me.

Thanks
Prakash



Edited 1 time(s). Last edit at 07/26/2007 04:04AM by Prakash Nallusamy.

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.