Bug #31170 rpl_innodb_bug28430 fails: varying timing, ports, and log use
Submitted: 24 Sep 2007 8:48 Modified: 27 Nov 2007 18:47
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.1.22-rc OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Tags: pbfail

[24 Sep 2007 8:48] Joerg Bruehe
Description:
Test case protocol relies on optimum timing (no delay in replication), on the standard port being uesed, and on a certain size of the log info generated:

-------------------------------------------------------
*** /PATH/mysql-test/suite/rpl/r/rpl_innodb_bug28430.result
--- /PATH/mysql-test/suite/rpl/r/rpl_innodb_bug28430.reject
***************
*** 120,126
  Slave_IO_State        Waiting for master to send event
  Master_Host   127.0.0.1
  Master_User   root
! Master_Port   12000
  Connect_Retry 1
  Master_Log_File       master-bin.000001
  Read_Master_Log_Pos   945644
--- 120,126
  Slave_IO_State        Waiting for master to send event
  Master_Host   127.0.0.1
  Master_User   root
! Master_Port   10730
  Connect_Retry 1
  Master_Log_File       master-bin.000001
  Read_Master_Log_Pos   945644
***************
*** 149,155
  Master_SSL_Cert
  Master_SSL_Cipher
  Master_SSL_Key
! Seconds_Behind_Master 0
  Master_SSL_Verify_Server_Cert No
  Last_IO_Errno 0
  Last_IO_Error
--- 149,155
  Master_SSL_Cert
  Master_SSL_Cipher
  Master_SSL_Key
! Seconds_Behind_Master 1
  Master_SSL_Verify_Server_Cert No
  Last_IO_Errno 0
  Last_IO_Error
-------------------------------------------------------

-------------------------------------------------------
*** /PATH/mysql-test/suite/rpl/r/rpl_innodb_bug28430.result
--- /PATH/mysql-test/suite/rpl/r/rpl_innodb_bug28430.reject
***************
*** 124,131
  Connect_Retry 1
  Master_Log_File       master-bin.000001
  Read_Master_Log_Pos   945644
! Relay_Log_File        slave-relay-bin.000003
! Relay_Log_Pos 945790
  Relay_Master_Log_File master-bin.000001
  Slave_IO_Running      Yes
  Slave_SQL_Running     Yes
--- 124,131
  Connect_Retry 1
  Master_Log_File       master-bin.000001
  Read_Master_Log_Pos   945644
! Relay_Log_File        slave-relay-bin.000005
! Relay_Log_Pos 252
  Relay_Master_Log_File master-bin.000001
  Slave_IO_Running      Yes
  Slave_SQL_Running     Yes
***************
*** 139,145
  Last_Error
  Skip_Counter  0
  Exec_Master_Log_Pos   945644
! Relay_Log_Space       945945
  Until_Condition       None
  Until_Log_File
  Until_Log_Pos 0
--- 139,145
  Last_Error
  Skip_Counter  0
  Exec_Master_Log_Pos   945644
! Relay_Log_Space       553
  Until_Condition       None
  Until_Log_File
  Until_Log_Pos 0
-------------------------------------------------------

How to repeat:
Run the test suite on different machines.

Suggested fix:
Use "replace_result",
and/or reset the relay log.
[6 Nov 2007 16:43] 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/37199

ChangeSet@1.2617, 2007-11-06 18:43:10+02:00, aelkin@koti.dsl.inet.fi +1 -0
  Bug #31170 rpl_innodb_bug28430 fails: varying timing, ports, and log use
  
  Non-deterministic parameters  of  SHOW SLAVE STATUS are masked out
  by means of using the standard include-macro.
  
  The masked-out parameters are not needed by the logics of the original
  tests. What is need to demonstre that replication is not stopped remains.
[9 Nov 2007 8:10] 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/37409

ChangeSet@1.2617, 2007-11-09 10:10:15+02:00, aelkin@koti.dsl.inet.fi +2 -0
  Bug #31170 rpl_innodb_bug28430 fails: varying timing, ports, and log use
  
  Non-deterministic parameters  of  SHOW SLAVE STATUS are masked out
  by means of using the standard include-macro.
  
  The masked-out parameters are not needed by the logics of the original
  tests. What is need to demonstre that replication is not stopped remains.
[27 Nov 2007 10:49] Bugs System
Pushed into 5.1.23-rc
[27 Nov 2007 10:52] Bugs System
Pushed into 6.0.4-alpha
[27 Nov 2007 18:47] Paul DuBois
Test case change. No changelog entry needed.