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

[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)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.079 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.