SNMP with PerfMib and SQL Server 7/2000

SNMP with PerfMib and SQL Server 7/2000

Post by Gre » Sun, 10 Jun 2001 06:50:42



we've installed SNMP with PerfMib extension agent.  then on systems
running SQL Server 7 or 2000 we get crashes 2 hours after re-starting
SNMP.  it gives Dr. Watson Crashes which are tough to debug because
none of the code is mine. it seems to be dying in fcloseall in the
perfmib, but i have no debugging information.  it is pretty
reproductible.   anyone seen this?   how would you go about debugging
such a crash?  any idea what's not compatible?

please help!!  thanks!

/greg

from drwtson32.log:

Application exception occurred:
        App: exe\snmp.dbg (pid=97)
        When: 6/4/2001 @ 14:17:55.0
        Exception number: c0000005 (access violation)

*----> System Information <----*
        Computer Name:
        User Name: SYSTEM
        Number of Processors: 2
        Processor Type: x86 Family 6 Model 8 Stepping 1
        Windows Version: 4.0
        Current Build: 1381
        Service Pack: 6
        Current Type: Multiprocessor Free
        Registered Organization:
        Registered Owner: NTSERVER

*----> Task List <----*
   0 Idle.exe
   2 System.exe
  25 SMSS.exe
  33 CSRSS.exe
  39 WINLOGON.exe
  45 SERVICES.exe
  48 LSASS.exe
  73 SPOOLSS.exe
  89 RPCSS.exe
  82 msdtc.exe
 115 LLSSRV.exe
 120 sqlservr.exe
 131 ORACLE80.exe
 146 ORACLE80.exe
 149 ORACLE80.exe
 152 TNSLSNR80.exe
 156 OWASTSVR.exe
 161 PSTORES.exe
 164 mstask.exe
 183 mssearch.exe
 195 STRTDB80.exe
 198 STRTDB80.exe
 201 STRTDB80.exe
 261 NDDEAGNT.exe
  52 EXPLORER.exe
 269 PROMon.exe
  44 LOADWC.exe
  49 sqlmangr.exe
  97 SNMP.exe
 278 DRWTSN32.exe
   0 _Total.exe

(023f0000 - 023f7000) exe\snmp.dbg
(77f60000 - 77fbe000) dll\ntdll.dbg
(74ba0000 - 74ba9000) dll\snmpapi.dbg
(78000000 - 78040000)
(77f00000 - 77f5e000) dll\kernel32.dbg
(776d0000 - 776d8000) dll\wsock32.dbg
(776b0000 - 776c4000) dll\ws2_32.dbg
(77e70000 - 77ec5000) dll\user32.dbg
(77ed0000 - 77efc000) dll\gdi32.dbg
(77dc0000 - 77dff000) dll\advapi32.dbg
(77e10000 - 77e67000) dll\rpcrt4.dbg
(776a0000 - 776a7000) dll\ws2help.dbg
(77bf0000 - 77bf7000) dll\rpcltc1.dbg
(77660000 - 7766f000) dll\msafd.dbg
(77690000 - 77699000) dll\wshtcpip.dbg
(765d0000 - 765dc000) dll\lmmib2.dbg
(77c00000 - 77c18000) drv\winspool.dbg
(77800000 - 7783a000) dll\netapi32.dbg
(77840000 - 77849000) dll\NetRap.dbg
(777e0000 - 777ed000) dll\samlib.dbg
(76a90000 - 76a9f000) dll\inetmib1.dbg
(10000000 - 10007000) dll\perfmib.dbg
(74ff0000 - 74ffe000) dll\rnr20.dbg
(60000000 - 60006000) msscntrs.dbg
(62000000 - 6200f000)
(74a00000 - 74a06000) dll\tapiperf.dbg
(75460000 - 7546f000) dll\perfctrs.dbg

State Dump for Thread Id 0xcb

eax=00135f48 ebx=0012fe84 ecx=001357b8 edx=00000000 esi=0000004c
edi=00000000
eip=77f67f07 esp=0012fda4 ebp=0012fe0c iopl=0         nv up ei pl zr
na po nc
cs=001b  ss=0023  ds=0023  es=0023  fs=0038  gs=0000            
efl=00000246

function: ZwReadFile
        77f67efc b886000000       mov     eax,0x86
        77f67f01 8d542404         lea     edx,[esp+0x4]        
ss:0117e7ab=????????
        77f67f05 cd2e             int     2e
        77f67f07 c22400           ret     0x24
        77f67f0a 8bc0             mov     eax,eax

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1  Param#2  Param#3  Param#4  Function Name
0012fe0c 77dd8a35 0000004c 00132398 0000021a 0012fe3c ntdll!ZwReadFile
0012fe40 77dd8481 0000004c 00132398 0000021a 0012fe84
advapi32!RegisterServiceCtrlHandlerA
0012fea4 77dd829e 0000004c 00132398 0000021a 00000000
advapi32!StartServiceCtrlDispatcherW
0012fec8 023f1431 023f4038 00000094 00000004 00000000
advapi32!StartServiceCtrlDispatcherA
0012ffc0 77f1b9ea 00000000 00000000 7ffdf000 7ffdf000 snmp!<nosymbols>
0012fff0 00000000 023f2a10 00000000 000000b0 00000100
kernel32!GetProcessPriorityBoost
00000000 00000000 00000000 00000000 00000000 00000000 snmp!<nosymbols>

*----> Raw Stack Dump <----*
0012fda4  a6 d2 f0 77 4c 00 00 00 - 00 00 00 00 00 00 00 00
...wL...........
0012fdb4  00 00 00 00 e0 fd 12 00 - 98 23 13 00 1a 02 00 00
.........#......
0012fdc4  00 00 00 00 00 00 00 00 - 00 00 00 00 98 23 13 00
.............#..
0012fdd4  84 fe 12 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
0012fde4  0c fe 12 00 54 fe 12 00 - 04 00 00 00 00 00 00 00
....T...........
0012fdf4  cc fd 12 00 00 00 00 00 - 94 fe 12 00 44 b9 f3 77
............D..w
0012fe04  40 ca f3 77 ff ff ff ff - 40 fe 12 00 35 8a dd 77
@..w....@...5..w
0012fe14  4c 00 00 00 98 23 13 00 - 1a 02 00 00 3c fe 12 00
L....#......<...
0012fe24  00 00 00 00 00 00 00 00 - 00 00 00 00 44 5b 13 00
............D[..
0012fe34  4c 00 00 00 54 fe 12 00 - 00 00 00 00 a4 fe 12 00
L...T...........
0012fe44  81 84 dd 77 4c 00 00 00 - 98 23 13 00 1a 02 00 00
...wL....#......
0012fe54  84 fe 12 00 98 23 13 00 - 00 00 00 00 1a 02 00 00
.....#..........
0012fe64  02 01 00 00 00 00 00 00 - 00 00 00 00 01 00 00 00
................
0012fe74  9c 23 13 00 00 00 00 00 - 01 00 00 00 68 2e 13 00
.#..........h...
0012fe84  00 00 00 00 00 00 00 00 - 58 fe 12 00 04 00 00 00
........X.......
0012fe94  b0 ff 12 00 c4 10 de 77 - d8 de de 77 ff ff ff ff
.......w...w....
0012fea4  c8 fe 12 00 9e 82 dd 77 - 4c 00 00 00 98 23 13 00
.......wL....#..
0012feb4  1a 02 00 00 00 00 00 00 - 00 00 00 00 00 f0 fd 7f
................
0012fec4  4c 00 00 00 c0 ff 12 00 - 31 14 3f 02 38 40 3f 02
L.......1.?.8@?.
0012fed4  94 00 00 00 04 00 00 00 - 00 00 00 00 65 05 00 00
............e...

State Dump for Thread Id 0x102

eax=00000000 ebx=00cbfd0c ecx=00000044 edx=00000000 esi=7ffdf000
edi=00cbfd2c
eip=77f682cb esp=00cbfce8 ebp=00cbfd3c iopl=0         nv up ei pl nz
ac pe cy
cs=001b  ss=0023  ds=0023  es=0023  fs=0038  gs=0000            
efl=00000213

function: NtWaitForMultipleObjects
        77f682c0 b8c4000000       mov     eax,0xc4
        77f682c5 8d542404         lea     edx,[esp+0x4]        
ss:01d0e6ef=????????
        77f682c9 cd2e             int     2e
        77f682cb c21400           ret     0x14
        77f682ce 8bc0             mov     eax,eax

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1  Param#2  Param#3  Param#4  Function Name
00cbfd3c 77f1cd76 00000003 00142fc8 00000000 000493e0
ntdll!NtWaitForMultipleObjects
00cbfd58 023f1d1a 00000003 00142fc8 00000000 000493e0
kernel32!WaitForMultipleObjects
00cbfda4 023f1930 00000000 00135b44 00000000 00135b38 snmp!<nosymbols>
00cbff94 023f1145 77f9d870 00135b38 806b91cc 00cbffec snmp!<nosymbols>
00cbffa8 77dd8c15 00000001 00135b40 ffffffff 77f04ede snmp!<nosymbols>
00cbffec 00000000 77dd8c07 00135b38 00000000 000000b0
advapi32!RegisterServiceCtrlHandlerA
00000000 00000000 00000000 00000000 00000000 00000000 snmp!<nosymbols>

*----> Raw Stack Dump <----*
00cbfce8  6b ce f1 77 03 00 00 00 - 0c fd cb 00 01 00 00 00
k..w............
00cbfcf8  00 00 00 00 2c fd cb 00 - e0 2f 14 00 c8 2f 14 00
....,..../.../..
00cbfd08  01 00 00 00 84 00 00 00 - 7c 00 00 00 a4 00 00 00
........|.......
00cbfd18  01 00 00 00 0b 00 00 00 - c8 e6 16 00 02 ff ff ff
................
00cbfd28  01 00 00 00 00 a2 2f 4d - ff ff ff ff 00 00 00 00
....../M........
00cbfd38  01 00 00 00 58 fd cb 00 - 76 cd f1 77 03 00 00 00
....X...v..w....
00cbfd48  c8 2f 14 00 00 00 00 00 - e0 93 04 00 00 00 00 00
./..............
00cbfd58  a4 fd cb 00 1a 1d 3f 02 - 03 00 00 00 c8 2f 14 00
......?....../..
00cbfd68  00 00 00 00 e0 93 04 00 - 00 00 00 00 90 00 00 00
................
00cbfd78  01 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
00cbfd88  00 00 00 00 d7 a7 0f 00 - 00 00 00 00 03 00 00 00
................
00cbfd98  0c 00 00 00 68 01 00 00 - 03 00 00 00 94 ff cb 00
....h...........
00cbfda8  30 19 3f 02 00 00 00 00 - 44 5b 13 00 00 00 00 00
0.?.....D[......
00cbfdb8  38 5b 13 00 01 01 02 02 - 57 69 6e 53 6f 63 6b 20
8[......WinSock
00cbfdc8  32 2e 30 00 00 00 00 00 - c4 65 13 00 2c 00 00 00
2.0......e..,...
00cbfdd8  00 00 00 00 00 00 00 00 - 01 00 00 00 00 00 00 00
................
00cbfde8  00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
00cbfdf8  00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
00cbfe08  11 ad dc 77 42 ad dc 77 - 58 ff cb 00 03 00 00 00
...wB..wX.......
00cbfe18  50 06 13 00 80 5b 13 00 - 88 df de 77 00 00 00 00
P....[.....w....

State Dump for Thread Id 0xd2

eax=00853b02 ebx=00000053 ecx=00853b02 edx=7fffffff esi=7ffffffe
edi=10001228
eip=7800fefc esp=00e3f710 ebp=00e3f964 iopl=0         nv up ei pl nz
na po nc
cs=001b  ss=0023  ds=0023  es=0023  fs=0038  gs=0000            
efl=00000206

function: fcloseall
        7800fedb 85c9             test    ecx,ecx
        7800fedd 7509             jnz     fcloseall+0x37f (7800fee8)
        7800fedf 8b0d50950378                                  
ds:78039550=7802f318
                                  mov     ecx,[_badioinfo+0x88
(78039550)]
        7800fee5 894df8           mov     [ebp-0x8],ecx        
ss:01e8e36a=????????
        7800fee8 c745dc01000000   mov   dword ptr [ebp-0x24],0x1
ss:01e8e36a=????????
        7800feef 8bc1             mov     eax,ecx
        7800fef1 8bd6             mov     edx,esi
        7800fef3 4e               dec     esi
        7800fef4 85d2             test    edx,edx
        7800fef6 0f849f030000     je      fcloseeall+0x732 (7801029b)
FAULT ->7800fefc 66833800         cmp     word ptr [eax],0x0        
ds:00853b02=????
        7800ff00 0f8495030000     je      fcloseall+0x732 (7801029b)
        7800ff06 40               inc     eax
        7800ff07 40               inc     eax
        7800ff08 ebe7             jmp     fcloseall+0x388 (7800fef1)
        7800ff0a c745cc01000000   mov   dword ptr [ebp-0x34],0x1
ss:01e8e36a=????????
        7800ff11 80c320           add     bl,0x20
        7800ff14 834dfc40         or    dword ptr [ebp-0x4],0x40
ss:01e8e36a=????????
        7800ff18 8dbdb8fdffff     lea     edi,[ebp+0xfffffdb8]  
ss:00e3f71c=002f3ab0
        7800ff1e 3bca             cmp     ecx,edx
        7800ff20 897df8           mov     [ebp-0x8],edi        
ss:01e8e36a=????????
        7800ff23 0f8d3e020000     jnl     fcloseall+0x5fe (78010167)

*----> Stack Back Trace <----*

FramePtr ReturnAd Param#1  Param#2  Param#3  Param#4  Function Name
00e3f964 78022bc8 00e3f97c 10001228 00e3f9b4 002f3134 !fcloseall
00e3f99c 10002a92 00e3f9c0 10001224 00e3fac0 00853b02 !sprintf
00e3fbc0 10002cb0 002f3ab0 002f2a58 00e3fbe0 00e44a98
perfmib!<nosymbols>
00e3fd84 10002271 002f3134 00e3fda4 00000001 00e44a98
perfmib!<nosymbols>
00e3feb0 10001de7 000000a1 00e44a98 00000007 00000000
perfmib!<nosymbols>
00e3fed8 10001c99 0017a918 000000a1 00000000 00000000
perfmib!<nosymbols>
00e3fef8 023f2477 000000a1 000000a1 00e3ff80 00e3ff7c
perfmib!<nosymbols>
00e3ff84 023f1af8 023f4464 00e3ffb4 00cbfc84 00cbfc78 snmp!<nosymbols>
00e3ffb8 77f04ede 00000000 00cbfc84 00cbfc78 00000000 snmp!<nosymbols>
00e3ffec 00000000 023f1956 00000000 00000000 00000007
kernel32!lstrcmpiW
00000000 00000000 00000000 00000000 00000000 00000000 snmp!<nosymbols>

*----> Raw Stack Dump <----*
00e3f710  06 00 00 00 34 31 2f 00 - b0 3a 2f 00 b0 3a 2f 00
....41/..:/..:/.
00e3f720  01 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00
................
00e3f730  06 00 00 00 ff ff ff ff - 06 00 00 00 80 30 2f 00
.............0/.
00e3f740  00 08 00 00 7c f7 e3 00 - c8 2b 02 78 5c f7 e3 00
....|....+.x\...
00e3f750  29 12 00 10 94 f7 e3 00 - 35 11 00 10 a6 f7 e3 00
).......5.......
00e3f760  f8 ff ff 7f a0 f7 e3 00 - 42 00 00 00 42 00 00 00
........B...B...
00e3f770  4b 3b 02 00 30 3a 00 00 - 00 5c 26 05 a0 f9 e3 00
K;..0:...\&.....
00e3f780  92 2a 00 10 a0 f7 e3 00 - 24 12 00 10 a0 f8 e3 00
.*......$.......
00e3f790  80 30 2f 00 02 00 00 00 - c0 2a 2f 00 e4 39 2f 00
.0/......*/..9/.
00e3f7a0  5f 54 6f 74 61 6c 00 00 - 58 2a 2f 00 90 2a 2f 00
_Total..X*/..*/.
00e3f7b0  01 00 00 00 98 f1 17 00 - 1c 40 18 00 88 fb e3 00
.........@......
00e3f7c0  98 f5 17 00 5a 4b de 77 - c0 2a 2f 00 00 00 00 00
....ZK.w.*/.....
00e3f7d0  00 00 00 00 40 02 00 00 - 00 00 00 00 00 00 00 00
....@...........
00e3f7e0  00 20 07 01 00 d0 4b 01 - 2e 48 00 00 ec f6 e3 00  .
....K..H......
00e3f7f0  02 08 00 00 dc ff e3 00 - c4 10 de 77 b8 f2 de 77
...........w...w
00e3f800  3a ff ff ff 00 00 00 00 - 07 00 00 00 01 06 00 00
:...............
00e3f810  00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00
................
00e3f820  98 fc e3 00 02 00 00 00 - ff ff ff ff 02 00 00 00
................
00e3f830  ec 35 2f 00 00 08 00 00 - 70 f8 e3 00 c8 2b 02 78
.5/.....p....+.x
00e3f840  50 f8 e3 00 29 12 00 10 - 88 f8 e3 00 35 11 00 10
P...).......5...

 
 
 

1. SNMP, is it still supported in SQL Server 6.5 (sp5a)/2000

I'm trying to write an application that requests some paramters from
SQL-Server 6.5 (SP5a) but my requests don't seem to get any answer from the
SQL-Server (other devices / SNMP agents on the same machine answer as
expected, support for SNMP in Setup is enabled)
My questions:
1. Is there any known problem with SNMP support for SQL-Server 6.5 (Sp5a) in
NT4.0 Server(Sp6a)
2. For scalability reasons, can I request the same parameters from SQL
Server 2000 as I (possibly) can from 6.5.

Thanx for any idea about these issues
Matthias

2. upgrade 6.5 to SQL 7 or 2K in a cluster enviroment

3. SNMP Traps with in MS SQL Server 2000

4. NewEra 3.0 Crystal Report Class Library

5. How to enable snmp on SQL Server 2000 ?

6. fastest way to search in 'names'

7. Enabling SNMP in SQL Server 2000

8. Update Query with date value

9. SNMP SQL Server 2000

10. SQL SERVER 2000 SNMP AGENT PROBLEM

11. SNMP, is it still supported in SQL Server 6.5 (sp5a)/2000

12. Monitoring SQL 2000 w/ SNMP