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.
Subject
Views
Written By
Posted
4003
August 12, 2015 07:40PM
Re: Error 1236 'Could not find first log file name...'
1688
August 16, 2015 12:23PM
2036
August 17, 2015 09:45AM
1408
August 18, 2015 09:20PM
1479
September 09, 2015 02:42PM
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.