Relay-Bin Log file is missing. How to skip?
Hi,
My server crashed a few days ago and now the slave is starting. I get the errors
"Failed to open the relay log '.\asafs1-relay-bin.005819' (relay_log_pos 236)"
"Could not find target log during relay log initialization"
"Failed to initialize the master info structure"
I tried to issue the command
CHANGE MASTER TO RELAY_LOG_FILE='asafs1-relay-bin.005820',
RELAY_LOG_POS=1;
It keeps giving me the same error as above and never skips to the next relay log.
Can anyone help solve this problem.
I do not want to purge all relay logs. My data is currently not in sync.
Thank you,
Mike
Subject
Views
Written By
Posted
Relay-Bin Log file is missing. How to skip?
33590
March 21, 2006 11:26AM
16118
March 21, 2006 11:27AM
17485
April 22, 2006 01:27PM
17551
November 25, 2007 03:54PM
15335
November 25, 2007 04:33PM
13297
November 25, 2007 04:54PM
8905
October 03, 2008 05:49PM
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.