check_mysql -S isn't working {Disarmed} {Fraud?}

[Marc Powell]

> -----Original Message-----
> From: nagios-users-bounces at lists.sourceforge.net [mailto:nagios-users-
> bounces at lists.sourceforge.net] On Behalf Of alexus
> Sent: Thursday, August 02, 2007 2:24 PM
> To: Nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] check_mysql -S isn't working {Disarmed}
{Fraud?}
> 
> # ./check_mysql -H 10.52.208.9910. <http://10.52.208.99>  -u xxxx -p
> xxxxxxxxx -S
> Slave IO: Yes Slave SQL: No Seconds Behind Master: (null)
> #
> 
> how come I get "null" in "No Seconds Behind Master?
> anyone?

Ok. I'll bite on the second time around...

My GUESS- The Seconds_Behind_Master column of the of the mysql command
'show slave status' has the value 'null' or is empty. Connect to mysql,
issue the 'show slave status;' command and verify if that's the case.

Alternately, the version of mysql that you are using, whatever it is,
changed that column such that the plugin can no longer parse it.

Alternately, the slave is broken in some way.

--
Marc

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null