Bug #51089 SHOW STATUS LIKE 'Slave_running' is not compatible with `SHOW SLAVE STATUS'
Submitted: 11 Feb 2010 12:05 Modified: 21 Jun 2010 0:54
Reporter: Bogdan Kecman Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0, 5.1 OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[11 Feb 2010 12:05] Bogdan Kecman
Description:
When Slave_IO_Running is No, as reported e.g by running `SHOW SLAVE STATUS' right after wait_for_slave_io_to_stop.inc (and no more activities with slave's thread is possible), SHOW STATUS LIKE 'Slave_running' still can report YES.

How to repeat:
as explained in http://bugs.mysql.com/bug.php?id=30703

Suggested fix:
There is already a fix for 5.5 and 6.0 but wee need this fixed in 5.1 as well.
[11 Feb 2010 15:32] Andrei Elkin
W is to 3 as in the parent's bug#30703.
[25 Feb 2010 10:40] 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/101427

3354 Andrei Elkin	2010-02-25
      Bug #51089   SHOW STATUS LIKE 'Slave_running' is not compatible with `SHOW SLAVE STATUS' 
      
      backporting of bug@30703 to 5.1.
      The fixes are backed up with a regression test.
     @ mysql-test/include/test_fieldsize.inc
        waiting to stop is to be actually exclusively for SQL thread.
     @ mysql-test/suite/rpl/r/rpl_show_slave_running.result
        new results file is added.
     @ mysql-test/suite/rpl/t/rpl_show_slave_running.test
        regression test for bug#30703 is added.
     @ sql/mysqld.cc
        refining `show status like slave_running' handler to correspond to one of
        `show slave status'.
     @ sql/slave.cc
        A dbug-sync point is added to complement the regression test.
[26 Feb 2010 12: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/commits/101601

3355 Andrei Elkin	2010-02-26
      bug#51089
      correcting c&p typos in the test
[26 Feb 2010 12: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/101602

3356 Andrei Elkin	2010-02-26
      bug#51089
      correcting c&p typos in the results
[27 Feb 2010 15:14] Andrei Elkin
Pushed to 5.1-bt, mysql-pe trees.
[2 Mar 2010 14:34] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100302142746-u1gxdf5yk2bjrq3e) (version source revid:alik@sun.com-20100301095421-4cz64ibem1h2quve) (merge vers: 6.0.14-alpha) (pib:16)
[3 Mar 2010 5:10] Jon Stephens
Already documented in 6.0.11 changelog (see BUG#30703 / BUG#41613).

Waiting for merge to 5.1 release tree.
[26 Mar 2010 8:21] Bugs System
Pushed into 5.5.4-m3 (revid:alik@sun.com-20100326080914-2pz8ns984e0spu03) (version source revid:alexey.kopytov@sun.com-20100307164059-cri8typa32cypq0l) (merge vers: 5.5.3-m2) (pib:16)
[26 Mar 2010 8:25] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100326081116-m3v4l34yhr43mtsv) (version source revid:alik@sun.com-20100325072612-4sds00ix8ajo1e84) (pib:16)
[26 Mar 2010 16:09] Paul Dubois
Noted in 5.5.4 changelog.

Setting report to Need Merge pending push into 5.1.x.
[26 Mar 2010 16:10] Paul Dubois
Cancel "Noted in 5.5.4 changelog" from previous comment.
[6 Apr 2010 8:00] Bugs System
Pushed into 5.1.46 (revid:sergey.glukhov@sun.com-20100405111026-7kz1p8qlzglqgfmu) (version source revid:joro@sun.com-20100301084434-ytctk3ceebjvqo7a) (merge vers: 5.1.45) (pib:16)
[6 Apr 2010 11:31] Jon Stephens
Documented in the 5.1.46 changelog - see BUG#30703/BUG#41613 for docs info. Also updated info in 5.1 version of 'SHOW SLAVE STATUS Syntax' in the Manual. Closed.
[17 Jun 2010 12:01] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:41] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:martin.skold@mysql.com-20100609211156-tsac5qhw951miwtt) (merge vers: 5.1.46-ndb-6.2.19) (pib:16)
[17 Jun 2010 13:28] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)