Re: Problem setting up replication

[Marcel Vijfwinkel]

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 '[e-mail]: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.