Bug #19208 Test 'rpl000017' hangs on Windows
Submitted: 20 Apr 2006 2:10 Modified: 4 Jul 2006 16:11
Reporter: Kent Boortz
Status: Closed
Category:Server: Replication Severity:S2 (Serious)
Version:5.0.20a OS:Microsoft Windows (Windows 2003)
Assigned to: Target Version:
Tags: binlog

[20 Apr 2006 2: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 9:49] Lars Thalmann
See also BUG#18986.
[27 Jun 2006 19: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 22: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 15:50] Lars Thalmann
Pushed into release clone for 5.0.23.
[29 Jun 2006 16:31] Lars Thalmann
Pushed into 5.0 main tree
[4 Jul 2006 16: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.