Bug #25012 reconfiguring log-bin on master fails slave (confused by index filename change)
Submitted: 12 Dec 2006 14:43 Modified: 26 Dec 2006 23:26
Reporter: Amit Dor-Shifer Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.1.21 OS:
Assigned to: CPU Architecture:Any

[12 Dec 2006 14:43] Amit Dor-Shifer
Description:
I've a master-slave configuration, running for a while with the default configuration for binary log filename ($HOST.bin).

I've changed that, and now replication won't start: 

061212 14:28:33 [Note] Slave I/O thread: connected to master 'me@1.2.3.4',  replication started in log 'amit0-bin.000001' at position 9480
061212 14:28:33 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236)
061212 14:28:33 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
061212 14:28:33 [ERROR] Slave I/O thread exiting, read up to log 'amit0-bin.000001', position 9480

Shouldn't the master direct the slave to the newly created index file? Is there a procedure to perform when changing binary log filenames? Couldn't find none in the manual.

How to repeat:
* Stop slave.
* modify my.cnf, so that binlogs are explicitly named:
log-bin=repl
* restart mysqld on master.
*restart slave

Suggested fix:
Either affect all parameters requiring change when 'log-bin' parameter changes, or supply the appropriate procedure for such a change.
[26 Dec 2006 23:26] Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

There is existant procedure which allows to change master binary log position on slave. Read http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html, http://dev.mysql.com/doc/refman/4.1/en/replication-faq.html and http://dev.mysql.com/doc/refman/4.1/en/binary-log.html