Question on check_mysql_query

[Heeres, Ken]

I have a query that says it returns 0.0000 and have a warning value of 2:6 and critical value of 7 and am getting a warning.

This is from the debug file:

[1361472169.305131] [2048.1] [pid=2302] **** BEGIN MACRO PROCESSING ***********
[1361472169.305133] [2048.1] [pid=2302] Processing: '$USER1$/check_mysql_query --hostname=$ARG1$ --port
=$ARG2$ --database=$ARG3$ --username=$ARG4$ --password=$ARG5$ --warning=$ARG6$ --critical=$ARG7$ --quer
y=$ARG8$'
[1361472169.305154] [2048.1] [pid=2302]   Done.  Final output: '/export/nagios/libexec/check_mysql_quer
y --hostname=sd-mysql --port=3308 --database=it_administration --username=ituser --password=########## -
-warning=2:6 --critical=7 --query="select format(datediff(current_timestamp,UPDATE_TIME),0) from inform
ation_schema.tables where TABLE_SCHEMA = 'it_administration' and TABLE_NAME = 'SD_AD_USERS'"'
[1361472169.305157] [2048.1] [pid=2302] **** END MACRO PROCESSING *************

This is from the status:
QUERY WARNING: 'select format(datediff(current_timestamp,UPDATE_TIME),0) from information_schema.tables where TABLE_SCHEMA = 'it_administration' and TABLE_NAME = 'SD_AD_USERS'' returned 0.000000

What am I doing wrong?


Thanks,

Ken

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20130221/0397a0f1/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
-------------- next part --------------
_______________________________________________
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