Monitoring sql server 2012 - Error - Length specified in network packet payload did not match number of bytes read
Hello, I am trying to implement an Sql server 2012 monitoring script. Installed the dbcheck.pl script from this link : http://sourceforge.net/projects/hobbit-perl-cl/ . While running I am getting an error.
Sql server log : "Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: XXXXXXXXx]"
xymon log : ERROR on 192.168.1.1 : Timeout connecting to DBI:Sybase:host=192.168.1.1;port=1433;encryptPassword=1!
Can anybody please help me to resolve this error ?
Thanks Anoop
Hello, Please find the debug log of dbcheck.pl script. I checked with wireshark and no request is generating to sql server port 1433.
Can anybody help please ?
Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::get_disabled_hosts line 1235 Wed Nov 26 11:29:51 2014:DEBUG: GET DISABLED HOSTS Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::get_disabled_hosts line 1235 Wed Nov 26 11:29:51 2014:DEBUG: /usr/local/xymon/server/data/disabled Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::exec_local_cmd line 442 Wed Nov 26 11:29:51 2014:DEBUG: RESULT= 0, COMMAND= /usr/local/xymon/server/bin/bbhostgrep dbcheck ,VALUE=0.0.0.0 192.168.1.1 # dbcheck Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::exec_local_cmd line 442 Wed Nov 26 11:29:51 2014:DEBUG: RESULT= 0, COMMAND= /usr/local/xymon/server/bin/bbhostgrep dbcheck ,VALUE=0.0.0.0 192.168.1.1 # dbcheck Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::initialize_host_test line 318 Wed Nov 26 11:29:51 2014:DEBUG: hostname: 192.168.1.1 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::initialize_host_test line 318 Wed Nov 26 11:29:51 2014:DEBUG: hostadress: 192.168.1.1 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 276 Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0 data0=uptime, data1=status+60 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 65 Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0 data0=DBCheck, data1=status+60 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::load_test_config line 1309 Wed Nov 26 11:29:51 2014:DEBUG: LINE=fulltest, EVENT=DBCheck, CHECK=status+60 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 65 Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0 data0=ChkConn, data1=status+60 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::load_test_config line 1309 Wed Nov 26 11:29:51 2014:DEBUG: LINE=conn, EVENT=ChkConn, CHECK=status+60 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::check_test line 65 Wed Nov 26 11:29:51 2014:DEBUG: mode=0, tocheck=0, testmode=0 data0=TblSpace, data1=status+60 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::load_test_config line 1309 Wed Nov 26 11:29:51 2014:DEBUG: LINE=tablespace, EVENT=TblSpace, CHECK=status+60 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=pinlib, DEFW=95, DEFA=90, WARN=95, ALERT=90 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=blbuff, DEFW=95, DEFA=90, WARN=95, ALERT=90 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=rowcache, DEFW=95, DEFA=90, WARN=95, ALERT=90 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::get_disk_level line 1312 Wed Nov 26 11:29:51 2014:DEBUG: KEY=tblspcheck, hostname=192.168.1.1, WP(1=%)=1, WARN=90, AP(1=%)=1, ALERT=95 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=tblsp, DEFW=90, DEFA=95, WARN=90%, ALERT=95% Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=hitcache, DEFW=95, DEFA=90, WARN=95, ALERT=90 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=rollback, DEFW=90, DEFA=95, WARN=90, ALERT=95 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=session, DEFW=90, DEFA=95, WARN=90, ALERT=95 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=process, DEFW=90, DEFA=95, WARN=90, ALERT=95 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=memreq, DEFW=90, DEFA=95, WARN=90, ALERT=95 Wed Nov 26 11:29:51 2014:CALL : main::get_host_parameters line 319 Wed Nov 26 11:29:51 2014:DEBUG: KEY=extent, DEFW=90, DEFA=95, WARN=90, ALERT=95 Wed Nov 26 11:29:51 2014:ERROR on 192.168.1.1: Timeout connecting to DBI:Sybase:host=192.168.1.1;port=1433;encryptPassword=1! Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1235 Wed Nov 26 11:29:51 2014:DEBUG: TEST=conn, TYPE=status+60, EVENT=ChkConn, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1235 Wed Nov 26 11:29:51 2014:DEBUG: BBDISPLAY: 192.168.2.1, hostname: 192,168,1,1, type: status+60, event: ChkConn, time: 00:00:00, color=red Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 352 Wed Nov 26 11:29:51 2014:DEBUG: TEST=tablespace, TYPE=status+60, EVENT=TblSpace, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 352 Wed Nov 26 11:29:51 2014:DEBUG: BBDISPLAY: 192.168.2.1, hostname: 192,168,1,1, type: status+60, event: TblSpace, time: 00:00:00, color=clear Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1347 Wed Nov 26 11:29:51 2014:DEBUG: TEST=uptime, TYPE=status+60, EVENT=uptime, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1347 Wed Nov 26 11:29:51 2014:DEBUG: BBDISPLAY: 192.168.2.1, hostname: 192,168,1,1, type: status+60, event: uptime, time: 00:00:00, color=clear Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::exec_time line 889 Wed Nov 26 11:29:51 2014:DEBUG: exec 0.0.0.0 192.168.1.1 # dbcheck, TIME=00:00:00 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1265 Wed Nov 26 11:29:51 2014:DEBUG: TEST=dbcheck, TYPE=status+60, EVENT=dbcheck, SENDTYPE=2, TESTLIVE=60, SUMREPTIME=0 Wed Nov 26 11:29:51 2014:CALL : Hobbit_fd_lib::send_bb line 1265
Thanks Anoop
On 21 November 2014 at 11:58, Anoop Mohan <anoopw14 at gmail.com> wrote:
Hello, I am trying to implement an Sql server 2012 monitoring script. Installed the dbcheck.pl script from this link : http://sourceforge.net/projects/hobbit-perl-cl/ . While running I am getting an error.
Sql server log : "Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: XXXXXXXXx]"
xymon log : ERROR on 192.168.1.1 : Timeout connecting to DBI:Sybase:host=192.168.1.1;port=1433;encryptPassword=1!
Can anybody please help me to resolve this error ?
Thanks Anoop
participants (1)
-
anoopw14＠gmail.com