Bug #22442 "Slave_IO_Running" differs in test result
Submitted: 18 Sep 2006 12:36 Modified: 10 Nov 2008 17:37
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.0.25 OS:MacOS (OS X (PPC, 32 bit))
Assigned to: Serge Kozlov CPU Architecture:Any

[18 Sep 2006 12:36] Joerg Bruehe
Description:
Build + test of 5.0.25,
the failure occurred only once:

-------------------------------------------------------
*** r/rpl_flush_log_loop.result
--- r/rpl_flush_log_loop.reject
***************
*** 14,17
  flush logs;
  show slave status;
  Slave_IO_State        Master_Host     Master_User     Master_Port     Connect_Retry   Master_Log_File Read_Master_Log_Pos
        Relay_Log_File  Relay_Log_Pos   Relay_Master_Log_File   Slave_IO_Running        Slave_SQL_Running       Replicate_D
o_DB    Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table  Replicate_Wild_Do_Table Replicate_Wild_Igno
re_Table        Last_Errno      Last_Error      Skip_Counter    Exec_Master_Log_Pos     Relay_Log_Space Until_Condition Unt
il_Log_File     Until_Log_Pos   Master_SSL_Allowed      Master_SSL_CA_File      Master_SSL_CA_Path      Master_SSL_Cert Mas
ter_SSL_Cipher  Master_SSL_Key  Seconds_Behind_Master
! #     127.0.0.1       root    SLAVE_PORT      60      slave-bin.000001        208     #       #       slave-bin.000001  Yes      Yes                                                     0               0       208     #       None            0 No                                               #
--- 14,17
  flush logs;
  show slave status;
  Slave_IO_State        Master_Host     Master_User     Master_Port     Connect_Retry   Master_Log_File Read_Master_Log_Pos
        Relay_Log_File  Relay_Log_Pos   Relay_Master_Log_File   Slave_IO_Running        Slave_SQL_Running       Replicate_D
o_DB    Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table  Replicate_Wild_Do_Table Replicate_Wild_Igno
re_Table        Last_Errno      Last_Error      Skip_Counter    Exec_Master_Log_Pos     Relay_Log_Space Until_Condition Unt
il_Log_File     Until_Log_Pos   Master_SSL_Allowed      Master_SSL_CA_File      Master_SSL_CA_Path      Master_SSL_Cert Mas
ter_SSL_Cipher  Master_SSL_Key  Seconds_Behind_Master
! #     127.0.0.1       root    SLAVE_PORT      60      slave-bin.000001        208     #       #       slave-bin.000001  No       Yes                                                     0               0       208     #       None            0 No                                               #
-------------------------------------------------------

How to repeat:
Found while running the test suite.
[25 Aug 2008 9:22] 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/52422

2613 Serge Kozlov	2008-08-25
      Bug#22442:
      1. Added vertical output for SHOW SLAVE STATUS and waiting starting/stopping slave instead sleep.
      2. Updated the result file.
[25 Aug 2008 9:23] 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/52423

2613 Serge Kozlov	2008-08-25
      Bug#22442:
      1. Added vertical output for SHOW SLAVE STATUS and waiting starting/stopping slave instead sleep.
      2. Updated the result file.
[25 Aug 2008 17: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/52474

2613 Serge Kozlov	2008-08-25
      Bug#22442:
      1. Added vertical output for SHOW SLAVE STATUS
      2. Added waiting starting slave and flush logs instead sleep.
      3. Updated the result file.
[26 Oct 2008 18:53] 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/57071

2711 Serge Kozlov	2008-10-26
      Bug#22442. 
      1. Replace --sleep by wait_* primitive
      2. Vertical output for SHOW SLAVE STATUS
      3. Updated result file
[26 Oct 2008 19:34] 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/57073

2712 Serge Kozlov	2008-10-26
      Bug#22442, removed number of port
[10 Nov 2008 10:50] Bugs System
Pushed into 6.0.8-alpha  (revid:skozlov@mysql.com-20081026193424-jnkknkwgd8jpx2sq) (version source revid:epotemkin@mysql.com-20081029135504-eie3ebskfjuuq5vu) (pib:5)
[10 Nov 2008 10:59] Bugs System
Pushed into 5.0.72  (revid:skozlov@mysql.com-20081026193424-jnkknkwgd8jpx2sq) (version source revid:kgeorge@mysql.com-20081103095032-zv904ucm2e9lgyxf) (pib:5)
[10 Nov 2008 11:19] Joerg Bruehe
Last entry is wrong - push was into 5.0.74.
[10 Nov 2008 11:35] Bugs System
Pushed into 5.1.30  (revid:skozlov@mysql.com-20081026193424-jnkknkwgd8jpx2sq) (version source revid:holyfoot@mysql.com-20081027155643-eo4ufcb5tf8zed7v) (pib:5)
[10 Nov 2008 17:37] Paul DuBois
Test case changes. No changelog entry needed.
[19 Jan 2009 11:31] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:08] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:14] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)