Page 1 of 1

Random error with check_mssql

Posted: Fri Apr 10, 2020 9:49 am
by gixxx11
On occasion I get the following error when runing a mssql check:

ERROR: In range threshold START:END, START must be less than or equal to END

But 90% of the time I get the expect output of a 1 or 0. I'm not sure where to even begin on fixing this.

Code: Select all

/usr/local/nagios/libexec/check_mssql -H 192.168.#.# -d dbname -U user -P 'password' -w 1 -c 1 -p 1433 -r "0" -q "exec dbo.usp_AutoEmailMonitor"

Re: Random error with check_mssql

Posted: Fri Apr 10, 2020 12:46 pm
by jdunitz
This appears to have been a bug in an older version of check_mssql.

Someone else had a similar problem a few years ago:
https://support.nagios.com/forum/viewto ... =6&t=36336


Check the version you're running, in case you somehow ended up with an old one.

If yours is current, and you're still having this problem, let us know and we'll go from there.

Thanks!
--Jeffrey