Re: Relay-Bin Log file is missing. How to skip?

[Scott Paterson]

Hello,

I have the same problem as the original poster, we are missing a relay-log (sun-relay-bin.237630) file due to server crash.

There are other files sun-relay-bin.237631, sun-relay-bin.237632 but not sun-relay-bin.237630.

Could someone please explain in a little more detail what needs to be done to get James' #1 working?

Here is my error log:
071126 9:59:04 [ERROR] Failed to open the relay log '.\sun-relay-bin.237630' (relay_log_pos 233)
071126 9:59:04 [ERROR] Could not find target log during relay log initialization
071126 9:59:04 [ERROR] Failed to initialize the master info structure

SHOW SLAVE STATUS:
Master_Log_File: sun-bin.000271
Read_Master_Log_Pos: 105808880
Relay_Log_File: sun-relay-bin.237630
Relay_Log_Pos: 233
Relay_Master_Log_File: sun-bin.000271
Slave_IO_Running: No


I tried CHANGE MASTER TO MASTER_LOG_POS=233; and it returned the same error.

Thanks for any pointers.

Scott


James Day Wrote:
-------------------------------------------------------
> You lose data if you skip. There are two
> solutions:
>
> 1. CHANGE MASTER TO the positon _on the master_
> where the slave was, the slave will get the
> transactions from the master binary logs again and
> you will lose nothing. Requires that the master
> still has those binary logs.
>
> 2. Recopy everything to the slave as a new slave
> setup.
>
> James Day
> Support Engineer, MySQL AB