Bug #12330 rpl_slave_status test fails
Submitted: 3 Aug 2005 0:51 Modified: 3 Aug 2005 20:32
Reporter: Jim Winstead Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:4.1-bk OS:Linux (Linux, x86_64)
Assigned to: Elliot Murphy CPU Architecture:Any

[3 Aug 2005 0:51] Jim Winstead 
Description:
it fails with the following diff on a 5.0 tree, but i believe it also fails on 4.1:

-------------------------------------------------------
*** r/rpl_slave_status.result   2005-08-02 03:08:45.000000000 +0300
--- r/rpl_slave_status.reject   2005-08-03 03:42:10.085715528 +0300
***************
*** 25,33 ****
  Master_Port   MASTER_MYPORT
  Connect_Retry 1
  Master_Log_File       master-bin.000001
! Read_Master_Log_Pos   357
! Relay_Log_File        slave-relay-bin.000001
! Relay_Log_Pos 401
  Relay_Master_Log_File master-bin.000001
  Slave_IO_Running      No
  Slave_SQL_Running     Yes
--- 25,33 ----
  Master_Port   MASTER_MYPORT
  Connect_Retry 1
  Master_Log_File       master-bin.000001
! Read_Master_Log_Pos   488
! Relay_Log_File        slave-relay-bin.000002
! Relay_Log_Pos 626
  Relay_Master_Log_File master-bin.000001
  Slave_IO_Running      No
  Slave_SQL_Running     Yes
***************
*** 40,47 ****
  Last_Errno    0
  Last_Error
  Skip_Counter  0
! Exec_Master_Log_Pos   357
! Relay_Log_Space       401
  Until_Condition       None
  Until_Log_File
  Until_Log_Pos 0
--- 40,47 ----
  Last_Errno    0
  Last_Error
  Skip_Counter  0
! Exec_Master_Log_Pos   488
! Relay_Log_Space       626
  Until_Condition       None
  Until_Log_File
  Until_Log_Pos 0
-------------------------------------------------------

How to repeat:
run the rpl_slave_status test.
[3 Aug 2005 13:02] Valeriy Kravchuk 
It failed on today's build too (Linux Fedora 2.4.22-1.2115.nptl):

-------------------------------------------------------
*** r/rpl_slave_status.result   Wed Aug  3 14:29:37 2005
--- r/rpl_slave_status.reject   Wed Aug  3 15:55:06 2005
***************
*** 25,33 ****
  Master_Port   MASTER_MYPORT
  Connect_Retry 1
  Master_Log_File       master-bin.000001
! Read_Master_Log_Pos   357
! Relay_Log_File        slave-relay-bin.000001
! Relay_Log_Pos 401
  Relay_Master_Log_File master-bin.000001
  Slave_IO_Running      No
  Slave_SQL_Running     Yes
--- 25,33 ----
  Master_Port   MASTER_MYPORT
  Connect_Retry 1
  Master_Log_File       master-bin.000001
! Read_Master_Log_Pos   590
! Relay_Log_File        slave-relay-bin.000002
! Relay_Log_Pos 728
  Relay_Master_Log_File master-bin.000001
  Slave_IO_Running      No
  Slave_SQL_Running     Yes
***************
*** 40,47 ****
  Last_Errno    0
  Last_Error
  Skip_Counter  0
! Exec_Master_Log_Pos   357
! Relay_Log_Space       401
  Until_Condition       None
  Until_Log_File
  Until_Log_Pos 0
--- 40,47 ----
  Last_Errno    0
  Last_Error
  Skip_Counter  0
! Exec_Master_Log_Pos   590
! Relay_Log_Space       728
  Until_Condition       None
  Until_Log_File
  Until_Log_Pos 0
-------------------------------------------------------
[3 Aug 2005 17:18] Lenz Grimmer 
Changed version to 4.1-bk, as it occurs in the 4.1 daily builds, too. Linux/x86 compiled with BUILD/compile-dist
[3 Aug 2005 19:08] 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/internals/27860
[3 Aug 2005 20:12] 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/internals/27862
[3 Aug 2005 20:25] Elliot Murphy 
Fixed for 5.0.11