check_mssql_health plugin - DBD::Sybase::db DESTROY failed

[sureshkraj2012]

Hello,

Could you please help me to resolve this issue?

check_mssql_health plugin gives below message along with the output.
I verified that perl-DBD-Sybase-1.10-1.el6.rf.x86_64 installed on the server. It would be great if you help to solve this problem

~~~~~~~~~~~~~~~~~~
OK - buffer cache hit ratio is 100.00% | buffer_cache_hit_ratio=100.00%;90:;80:
DBD::Sybase::db DESTROY failed: Server message number=3903 severity=16 state=1 line=2 server=Server1 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=Server1 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=Server1 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=Server1 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. during global destruction.
~~~~~~~~~~~~~~~~~~

[abrist]

What is the full command/query you are running?

[sureshkraj2012]

Here is the command and output

[root@NServer ~]# /usr/local/nagios/libexec/check_mssql_health --server Server1 --username 'xxx' --password 'xxxx' --mode mem-pool-data-buffer-hit-ratio
OK - buffer cache hit ratio is 100.00% | buffer_cache_hit_ratio=100.00%;90:;80:
DBD::Sybase::db DESTROY failed: Server message number=3903 severity=16 state=1 line=2 server=Server1 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=Server1 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=Server1 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server message number=3903 severity=16 state=1 line=2 server=Server1 text=The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. during global destruction.

[abrist]

There have been other reported issues with the Sybase related plugins. What version are you running:

Code: Select all

./check_mssql_health -h
./check_mssql_health -V

[sureshkraj2012]

Am using check_mssql_health-1.5.19.3

http://labs.consol.de/lang/en/nagios/ch ... ql_health/

[abrist]

This looks like a bug. Have you reported it to the consol labs guys?

[P3dr0]

Hi all,

I had the same issue for months and today, Gerhard Lausser gave me an explanation today ( true story ! thanks to him )

Gerhard Lausser ([email protected])

Ajouter aux contacts
11:07

À : [email protected]
From: [email protected]
Hi,

the behavior of either dbd::sybase or freetds changed (this error message appeared suddenly at the beginning of this year and only with certain linux distributions)

You have to add „—commit“

Gerhard

So, i configured my nagios server for monitoring my SQL Server and it seems it works.

I'm expecting the answer on where we have to add "--commit" instruction.

I'm working with Nagios 4.0 on Red Hat Enterprise 6.5.

Hope it help,

Pierre

[abrist]

@OP: Did P3dr0's solution work for you?

[whitest]

@OP: Did P3dr0's solution work for you?

It solution works for me.
Thanks!

[jolson]

Thanks for the answer P3dr0! I'll close this thread out - feel free to open additional threads in the future if necessary.