[Nagiosplug-devel] [ nagiosplug-Patches-3351505 ] check_mysql - allow until condition on a slave

[SourceForge.net]

Patches item #3351505, was opened at 2011-07-03 10:51
Message generated for change (Tracker Item Submitted) made by megamaddin
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=3351505&group_id=29880

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Enhancement
Group: release-1.4.15
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Mega Maddin (megamaddin)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_mysql - allow until condition on a slave

Initial Comment:
Patch against Plugin Version (-V output): check_mysql v1.4.15 (nagios-plugins 1.4.15)
Plugin Name: check_mysql
Example Plugin Commandline: check_mysql -H localhost -S
Tested on operating system: CentOS 5.5
Tested on architecture: AMD64
Tested with compiler: gcc-Version 4.1.2 20080704 (Red Hat 4.1.2-50)

The check_mysql plugin fails with a wrong exit code, if the mysql slave server is started with an UNTIL condition and the sever reaches its desired binlog position. If the binlog position is reached, the slave sql thread stops running, until it's started again, and that is the problem. This patch solves this error by looking if the slave thread is started with an until condition and throws only an error if the Last_Errno variable in mysql is set.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=3351505&group_id=29880