one of our backup slave systems had to be restarted and we forgot to start the slave. It was a few days before someone noticed and when we now try to start the slave we get an error:
Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
Running show slave status, shows the information below:
Master_Log_File: mysql-bin.001067
Read_Master_Log_Pos: 137138436
Relay_Log_File: relay-bin.000267
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.001067
I'm pretty sure I understand what's happening, in looking at the master directory where the bin files are stored, the earliest one is "mysql-bin.001077". Basically, b/c of the late restart, the slave is now to far behind to catch up via bin files, is that correct?
What is the best course of action? does the slave data have to be re-loaded?
Thanks
Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
Running show slave status, shows the information below:
Master_Log_File: mysql-bin.001067
Read_Master_Log_Pos: 137138436
Relay_Log_File: relay-bin.000267
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.001067
I'm pretty sure I understand what's happening, in looking at the master directory where the bin files are stored, the earliest one is "mysql-bin.001077". Basically, b/c of the late restart, the slave is now to far behind to catch up via bin files, is that correct?
What is the best course of action? does the slave data have to be re-loaded?
Thanks
Comment