We have Nagios Configured to Monitor SQL Server. Below is detailed information.
On Server we have 3 SQL instance. Instance1, Instance2, Instance3.
on Instance3, Full-scan is reporting as error_handler: Data-conversion resulted in overflow. while on the other 2 instance its working. Also please note on Instance3 other parameters like database free space is working.
Also we try with different user, through command line. Still FULL SCANS alone has the issue. we don't have any error message in SQL.
Below is the error message.
root@servername:/usr/lib/nagios/plugins# ./check_mssql_health –server Servername –username “Domain\\\\usename” –password password –mode full-scans
error_handler: Data-conversion resulted in overflow.
UNKNOWN – unable to aquire counter data
root@server:/usr/lib/nagios/plugins#
Data-conversion resulted in overflow - FULL SCANS
Re: Data-conversion resulted in overflow - FULL SCANS
I see you are using check_mssql_health but can you please specify the database type and version you are checking against?
Former Nagios employee
Re: Data-conversion resulted in overflow - FULL SCANS
This issue we are facing on Microsoft SQL Server 2008 R2 (SP2) - SQL instance.
Re: Data-conversion resulted in overflow - FULL SCANS
Please check with your DBA and make sure that the user that you're using has the same permissions on instance 3 that they have one 1 and 2, that's the likely cause.
Let us know the results.
Thank you
Let us know the results.
Thank you
Re: Data-conversion resulted in overflow - FULL SCANS
Also, what is the output of this command on the XI server:
Code: Select all
/usr/local/nagios/libexec/check_mysql_health -V
Re: Data-conversion resulted in overflow - FULL SCANS
SQL Server Instance has sysadmin rights. Below is the result of the code. Only FULL scans is showing error. other parameter like database free, etc is working
root@ABCDEF:/usr/local/nagios/libexec# ./check_mssql_health -V
check_mssql_health (1.5.8.2)
This nagios plugin comes with ABSOLUTELY NO WARRANTY. You may redistribute
copies of this plugin under the terms of the GNU General Public License.
root@ABCDEF:/usr/local/nagios/libexec#
root@ABCDEF:/usr/local/nagios/libexec# ./check_mssql_health -V
check_mssql_health (1.5.8.2)
This nagios plugin comes with ABSOLUTELY NO WARRANTY. You may redistribute
copies of this plugin under the terms of the GNU General Public License.
root@ABCDEF:/usr/local/nagios/libexec#
Re: Data-conversion resulted in overflow - FULL SCANS
That's a pretty old version, please upgrade to the latest and see if that resolves the issue for you:
https://labs.consol.de/nagios/check_mss ... index.html
https://labs.consol.de/nagios/check_mss ... index.html