Failure message - check_mssql_health

jfigueroa21 · February 16, 2023, 3:46pm

Hello :),

When I configure any “mode” of the plugin check_mssql_health as for example the one in the image “database-online” I get that message

DBD::Sybase::db DESTROY failed: Server message number=3903 severity=16 state=1 line=2 server=COLMOKSYS-52 text=The ROLLBACK TRANSACTION request does not have a corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=COLMOKSYS-52 text=The ROLLBACK TRANSACTION request does not have a corresponding BEGIN TRANSACTION. during global destruction.
(in cleanup) (in cleanup) during global destruction.

I would like to know if there is a way to remove or fix this message and/or why this message appears.

Thanks for your help.

ronnybremer · February 16, 2023, 4:00pm

You need to add “–commit” to the list of parameters, this seems to be required.

github.com/lausser/check_mssql_health

Transaction Error when running check_mssql_health

opened 03:41AM - 17 Jul 14 UTC

rajav2

I am getting the following transaction error for all modes. It is the same with …other DB servers. Please advice [nagios@nagiosprodxi1 libexec]$ ./check_mssql_health -V check_mssql_health (1.5.20.5) This nagios plugin comes with ABSOLUTELY NO WARRANTY. You may redistribute copies of this plugin under the terms of the GNU General Public License. [nagios@nagiosprodxi1 libexec]$ ./check_mssql_health --server CRDE_SG_UAT --username appsmonitor --password abc1\* --mode connection-time --warning 5 --critical 10 OK - 0.17 seconds to connect as appsmonitor | connection_time=0.17;5;10 DBD::Sybase::db DESTROY failed: Server message number=3903 severity=16 state=1 line=2 server=BHQKPK200020 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=BHQKPK200020 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. during global destruction. (in cleanup) DBD::Sybase::db DESTROY failed: Server message number=3903 severity=16 state=1 line=2 server=BHQKPK200020 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=BHQKPK200020 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. during global destruction.