Bug #70996 show slave status should emit a warning if multisource is active

• Submitted: 25 Nov 2013 7:32
• Modified: 30 Nov 2013 9:03
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S4 (Feature request)
• Version: 5.7.2-labs-multi-src-rep-log
• OS: Any
• CPU Architecture: Any
• Tags: labs, multisource replication

[25 Nov 2013 7:32] Daniël van Eeden

Description:
If multisource replication is active the 'SHOW SLAVE STATUS' command returns an empty result. This looks like replication is not active, but that's not the case.

How to repeat:
Setup multisource replication 

Suggested fix:
If multisource replication is active then 'SHOW SLAVE STATUS' should emit a warning like 'Warning: Multisource replication is active and no channel was supplied.'

[30 Nov 2013 9:03] MySQL Verification Team

Hello Daniel,

Thank you for the feature request!
I agree, when the multisource replication is in effect it should warn to the user if tried non-multisource(SHOW SLAVE STATUS) way rather than channel specific i.e SHOW SLAVE STATUS FOR CHANNEL=..

Thanks,
Umesh