MySQL Bugs: #50718: Missing relay log from index file message on startup not explicit enough

Bug #50718	Missing relay log from index file message on startup not explicit enough
Submitted:	29 Jan 2010 9:34	Modified:	18 Sep 2012 9:39
Reporter:	Roger David Nay	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	All	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
If the relay log is missing from the .index file, even though it exists on the server, the following messages are output.

100129 8:53:51 [ERROR] Failed to open the relay log '/mysql/off/log/relaylog.000545' (relay_log_pos 423880681)
100129 8:53:51 [ERROR] Could not find target log during relay log initialization
100129 8:53:51 [ERROR] Failed to initialize the master info structure

That seems to suggests that the file is missing, not that it is just missing from the .index file.

How to repeat:
I just copied over my server-bin.index to server-relay-bin.index to create the mismatch. Realistically this happens on restores or pointing to the wrong files in a more complicated non default configurations.

Suggested fix:
This may be better, need to indicate that it is missing from the .index file somehow, not just that the target couldn't be found.

100129 8:53:51 [ERROR] Failed to open the relay log '/mysql/off/log/relaylog.000545' (relay_log_pos 423880681)
100129 8:53:51 [ERROR] Could not find target log file mentioned in 'relay-log.info' in index file '../log/relaylog.index' during relay log initialization.
100129 8:53:51 [ERROR] Failed to initialize the master info structure

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Fixed in MySQL 5.6.8.

Closed.