Nagios Support Forum

Code: Select all

[nagios@nagiosprodxi1 libexec]$ ./check_mssql_health --server XXX_UAT --port 1433 --username monitor --password abc123 --mode connection-time
OK - 0.08 seconds to connect as monitor | connection_time=0.08;1;5
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.
[nagios@nagiosprodxi1 libexec]$

Code: Select all

./check_mssql_health -h
./check_mssql_health -V

Code: Select all

[nagios@nagiosprodxi1 libexec]$ ./check_mssql_health -V
check_mssql_health (1.5.19.3)
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]$

Code: Select all

yum list installed perl-DBD-Sybase
yum list installed freetds
uname -a
cat /etc/*release

Code: Select all

[nagios@nagiosprodxi1 libexec]$ sudo yum list installed perl-DBD-Sybase
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
This system is receiving updates from RHN Classic or RHN Satellite.
rhel-6-server-cf-tools-1-rpms                                                                    | 2.8 kB     00:00
rhel-6-server-rpms                                                                               | 3.7 kB     00:00
Error: No matching Packages to list
[nagios@nagiosprodxi1 libexec]$ sudo yum list installed freetds
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
This system is receiving updates from RHN Classic or RHN Satellite.
rhel-6-server-cf-tools-1-rpms                                                                    | 2.8 kB     00:00
rhel-6-server-rpms                                                                               | 3.7 kB     00:00
Installed Packages
freetds.x86_64                                             0.91-2.el6                                              @epel
[nagios@nagiosprodxi1 libexec]$ uname -a
Linux nagiosprodxi1 2.6.32-431.11.2.el6.x86_64 #1 SMP Mon Mar 3 13:32:45 EST 2014 x86_64 x86_64 x86_64 GNU/Linux
[nagios@nagiosprodxi1 libexec]$ cat /etc/*release
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Red Hat Enterprise Linux Server release 6.5 (Santiago)
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[nagios@nagiosprodxi1 libexec]$

Code: Select all

Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-Sybase.x86_64 0:1.10-1.el6.rf will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================
 Package                         Arch                   Version                          Repository                Size
========================================================================================================================
Installing:
 perl-DBD-Sybase                 x86_64                 1.10-1.el6.rf                    rpmforge                 192 k

Transaction Summary
========================================================================================================================
Install       1 Package(s)

Total download size: 192 k
Installed size: 518 k
Is this ok [y/N]: y
Downloading Packages:
perl-DBD-Sybase-1.10-1.el6.rf.x86_64.rpm                                                         | 192 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : perl-DBD-Sybase-1.10-1.el6.rf.x86_64                                                                 1/1
rhel-6-server-rpms/productid                                                                     | 1.7 kB     00:00
  Verifying  : perl-DBD-Sybase-1.10-1.el6.rf.x86_64                                                                 1/1

Installed:
  perl-DBD-Sybase.x86_64 0:1.10-1.el6.rf

Complete!

Code: Select all

[nagios@nagiosprodxi1 libexec]$ ./check_mssql_health --server CRDE_SG_UAT -port 1433 --username monitor --password abc123 --mode connection-time
OK - 0.16 seconds to connect as monitor | connection_time=0.16;1;5
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.

Code: Select all

heck_mssql              
check_mssql_database.py  
check_mssql_server.py

Code: Select all

The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

Code: Select all

BEGIN TRANSACTION
  <update some rows>
  <if failure>
      ROLLBACK TRANSACTION
  <else>
      COMMIT
END TRANSACTION