MySQL Forums
Forum List  »  Replication

Re: Error 1236 'Could not find first log file name...'
Posted by: Rick James
Date: August 16, 2015 12:23PM

The Master's list of files and the Slave's ("relay"'s) list of files are different. Data is transferred, not whole files; the data usually lands in a differently-named file.

The binlog you copied from the Masterwas complete as of the time you did the copy.

If you have log_slave_updates ON, the Slave is writing binlog entries of its own. (They will generally mimic what the Master wrote to its binlogs.)

> I reset slave, then started the slave

This may be the problem.

Assuming you are not using a new version that has GTIDs, and have them turned on... At the time you took the dump of the Master, you needed to capture the location in the binlogs (filename and position). After loading the data, then do CHANGE MASTER to point the slave at that location so that it can receive changes since the time of the copy.

I have never seen a use for RESET SLAVE.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error 1236 'Could not find first log file name...'
1670
August 16, 2015 12:23PM


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.