Bug #20314 SHOW MASTER STATUS showing latest error/errno

• Submitted: 7 Jun 2006 10:25
• Modified: 7 Jun 2006 10:59
• Reporter: Geert Vanderkelen
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S4 (Feature request)
• Version: 5.1
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[7 Jun 2006 10:25] Geert Vanderkelen

Description:
It would be helpful to put, just like SHOW SLAVE STATUS, the last error and errno in the output of SHOW MASTER STATUS.

Something like this:

mysql> SHOW MASTER STATUS\G
*************************** 1. row ***************************
File: ndbsup-1.000002
Position: 13850
Binlog_Do_DB: 
Binlog_Ignore_DB:
Last_Errno: <last errno>
Last_Error: <last errmsg>

This information should be available in the error logs, but would be useful for monitoring failures, especially with RBR and Cluster.

How to repeat:
(Feature request)

[7 Jun 2006 10:59] Valeriy Kravchuk

Thank you for a reasonable feature request.