MySQL Forums
Forum List  »  Replication

Re: Problem setting up replication
Posted by: Marcel Vijfwinkel
Date: July 20, 2007 09:54AM

Ok, I'm trying to pick this up again after not being able to work on it a few days.

This tells me the slave is not running:

mysql> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: xxx.xxx.xxx.xxx
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: bin.log
Read_Master_Log_Pos: 4
Relay_Log_File: xxxxx-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: bin.log
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 98
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)

This is the error I get in the error.log:

070720 19:36:10 [Note] Slave I/O thread: connected to master 'replication@xxx.xxx.xxx.xxx:3306'070720 19:36:10 [ERROR] Error reading packet from server: Could not find first log file name
070720 19:36:10 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary

My question is, what does this error apply to? Can't MySql find the first log file on the master server, or on the slave server?

I can see the .bin files on the slave server, and they are correctly referenced in index.bin, so I don't understand where the error comes from.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem setting up replication
1906
July 20, 2007 09:54AM


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.