Bug #19208 Test 'rpl000017' hangs on Windows
Submitted: 20 Apr 2006 0:10 Modified: 4 Jul 2006 14:11
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.0.20a OS:Microsoft Windows (Windows 2003)
Assigned to: CPU Architecture:Any
Tags: binlog

[20 Apr 2006 0:10] Kent Boortz
Description:
Test 'rpl000017' hangs on Windows, last statements
in the "master.log" file was

                       6 Connect     replicate@localhost on 
                       6 Query       SELECT UNIX_TIMESTAMP()
                       6 Query       SHOW VARIABLES LIKE 'SERVER_ID'
                       5 Query       insert into t1 values(24)
                       6 Query       SHOW SLAVE HOSTS
                       6 Binlog Dump Log: 'master-bin.000001'  Pos: 4
                       5 Query       show master status

Last part of "slave.log" was

 060420  1:43:20       1 Connect     root@localhost on test
                       1 Query       start slave
                       2 Connect Out replicate@127.0.0.1:9306
                       1 Query       select master_pos_wait('master-bin.000002', 655)

Last part of "slave.err" was

 CURRENT_TEST: rpl000017
 060420  1:43:19 [Note] e:\build\mysql-pro-gpl-5.0.20a-build\mysql-pro-gpl-5.0.20a-win32\bin\mysqld-nt.exe: ready for connections.
 Version: '5.0.20a-nt-log'  socket: ''  port: 9308  MySQL Pro (GPL)
 060420  1:43:20 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log 'e:\build\mysql-pro-gpl-5.0.20a-build\mysql-pro-gpl-5.0.20a-win32\mysql-test\var\log\slave-relay-bin.000001' position: 4
 060420  1:43:20 [Note] Slave I/O thread: connected to master 'replicate@127.0.0.1:9306',  replication started in log 'master-bin.000001' at position 4
 060420  1:43:20 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
 060420  1:43:20 [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
 060420  1:43:20 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 4

How to repeat:
Run the test on Windows.
[12 Jun 2006 7:49] Lars Thalmann
See also BUG#18986.
[27 Jun 2006 17:16] 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/8338
[27 Jun 2006 20: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/8348
[29 Jun 2006 13:50] Lars Thalmann
Pushed into release clone for 5.0.23.
[29 Jun 2006 14:31] Lars Thalmann
Pushed into 5.0 main tree
[4 Jul 2006 14:11] MC Brown
This has been documented in the 5.0 changelog: 

On Windows, removal of binary log files would fail if the files were already open.