Bug #72772 mysqlrplshow does not detect stopped master and slave server server
Submitted: 28 May 2014 7:45 Modified: 29 May 2014 20:52
Reporter: Shahriyar Rzayev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Utilities Severity:S1 (Critical)
Version:1.4.3 OS:Linux (CentOS 6.5)
Assigned to: CPU Architecture:Any

[28 May 2014 7:45] Shahriyar Rzayev
Description:
Dear experts,

I have Stopped Master server and used:

[root@linuxsrv3 ~]# mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
# master on localhost: ... FAILED.

ERROR: Cannot connect to the master server.
Error Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)

Also Stopped slave server:

[root@linuxsrv3 ~]# mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
# master on localhost: ... connected.
# Finding slaves for master: localhost:3306
Error connecting to a slave as remote2@192.168.1.88: Cannot connect to the slave server.
Error Can't connect to MySQL server on '192.168.1.88:3306' (111 Connection refused)

WARNING: There are slaves that had connection errors.

# Replication Topology Graph
No slaves found.

On both sutiations it shows "Connection refused" instead of Master MySQL has stopped or Slave Server has stopped etc.

How to repeat:
Stop Master server and use:

 mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv

Stop Slave server:

 mysqlrplshow  --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv

Suggested fix:
Maybe, detecting if master server running or not and slave server is running or not and show an informative error message instead of "Connection refused".
[28 May 2014 9:49] MySQL Verification Team
Hello Shahriyar,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[29 May 2014 20:52] Chuck Bell
Duplicate of BUG#72707.