I'm not sure what's going on with our replication. Everything was working fine, then all of a sudden it stopped. I did STOP SLAVE; RESET SLAVE; LOAD DATA FROM MASTER and it completed after a few minutes, but when I checked SHOW SLAVE STATUS it no longer had any information about the master. I look in the log and there are these messages:
040510 12:46:15 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4
040510 12:46:15 Error reading packet from server: Could not open log file (server_errno=1236)
040510 12:46:15 Got fatal error 1236: 'Could not open log file' from master when reading data from binary log
040510 12:46:15 Slave I/O thread exiting, read up to log 'FIRST', position 4
Any ideas what this is all about? I couldn't find any useful help in the manual or archives when I searched for those errors.
Gabriel:
Check the master error log to see what binary log it is trying to read, and why the read is not successful, eg. ownership/permission problems.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
