Bug #57771 | Master losing track of binary log file after configuration change | ||
---|---|---|---|
Submitted: | 27 Oct 2010 13:51 | Modified: | 17 Jan 2011 8:12 |
Reporter: | Roger David Nay | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.1.49 | OS: | Any |
Assigned to: | Luis Soares | CPU Architecture: | Any |
[27 Oct 2010 13:51]
Roger David Nay
[14 Jan 2011 16:11]
Luis Soares
See also: BUG#12133.
[14 Jan 2011 17:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/128828 3507 Luis Soares 2011-01-14 BUG#57771: Master losing track of binary log file after configuration change Sketch of a test case.
[14 Jan 2011 17:10]
Luis Soares
Using the above test case and testing it against current mysql-trunk: - tree: mysql-trunk - revid: sven.sandberg@oracle.com-20110114104020-j0l7jpwzegs3d401 - OS: Ubuntu linux I get the following result: include/master-slave.inc [connection master] /home/lsoares/Workspace/bzr/work/reviews/b12133/mysql-trunk-vanilla/mysql-test/var /home/lsoares/Workspace/bzr/work/reviews/b12133/mysql-trunk-vanilla/mysql-test/var/mysqld.1/data/mysqld-bin.000001 # Shutdown master # Restart master with log-bin option set to the new path /home/lsoares/Workspace/bzr/work/reviews/b12133/mysql-trunk-vanilla/mysql-test/var/mysqld.1/data/mysqld-bin.000001 ./mysqld-bin.000002 CREATE TABLE t1 (a INT); DROP TABLE t1; STOP SLAVE; include/wait_for_slave_to_stop.inc START SLAVE; Last_IO_Errno = '1236' Last_IO_Error = '110114 20:03:18 Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'' Note that I get the same error as Roger did. Now, trying the same test case against a mysql-trunk patched with BUG#12133 proposed patch, I get: include/master-slave.inc [connection master] /home/lsoares/Workspace/bzr/work/reviews/b12133/mysql-trunk/mysql-test/var mysqld-bin.000001 # Shutdown master # Restart master with log-bin option set to the new path mysqld-bin.000001 mysqld-bin.000002 CREATE TABLE t1 (a INT); DROP TABLE t1; STOP SLAVE; include/wait_for_slave_to_stop.inc START SLAVE; Last_IO_Errno = '0' Last_IO_Error = '' include/check_slave_no_error.inc include/check_slave_is_running.inc rpl.rpl_bug57771 'stmt' [ pass ] 5714 Therefore, seems that patch for BUG#12133 fixes this one as well.
[17 Jan 2011 8:13]
Zhenxing He
Duplicate of BUG#12133