SQL Stack dump errors

  • Hi All,

    My SQL Servers started throwing the stack dumps since yesterday.

    It is dumping stacks of some of the system processes. All jobs execute properly. here is the dump.

    ERROR : net_readdata: Process 4968 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    DUMP : ( Providing only part of the dump as it is a very long dump )

    Windows NT 5.0 Build 2195 CSD Service Pack 4.

    NULL

    Memory

    ------

    MemoryLoad = 54% TotalPhys = 3711 MB AvailPhys = 1679 MB

    TotalPageFile = 4095 MB

    -------------------------------------------------------------------------------

    Short Stack Dump

    0x4106a700 Module(opends60+a700) (net_completionroutine+2a)

    0x41065db0 Module(opends60+5db0) (net_readdata+121)

    0x78008454 Module(MSVCRT+8454) (endthread+c1)

    0x7c57438b Module(KERNEL32+438b) (TlsSetValue+f0)

    -------------------------------------------------------------------------------

    Location : 0x4106a700 Module(opends60+a700) (net_completionroutine+2a)

    Return Addr: 0x41065db0 Module(opends60+5db0) (net_readdata+121)

    Frame : 056cff10

    Parameters:

    [1] 5BF763F0: 00000000 0480eac0 5be66028 00000001 5be66028 bd988e85

    [2] 00000000:

    [3] 5BF76424: 00000000 00000001 6d278a67 019d0003 00000000 00000000

    [4] 77F82AD0: c22ecd04 24548d00 000047b8 77fb778d 77fb7789 ffffffff

    160 bytes of stack data from 056cfe70 to 056cff10

    056cfe70: 00d80178 00000000 00000003 04dd0000 [x...............]

    056cfe80: 7c5d3028 00000409 00000000 7c5d6a28 [(0]|........(j]|]

    056cfe90: 00101420 00000058 00000000 00007fd8 [ ...X...........]

    056cfea0: 00007fd8 0537f294 77f81f55 77f82518 [......7.U..w.%.w]

    056cfeb0: ffffffff 0537f2a4 7c57374e 000b01b8 [......7.N7W|....]

    056cfec0: 000b01b8 00000001 00000001 000b01b8 [................]

    056cfed0: 00101418 00101420 000b0188 000b0188 [.... ...........]

    056cfee0: 00d80178 00d80178 00d80178 00d80178 [x...x...x...x...]

    056cfef0: 00000000 00000010 000b0198 00000010 [................]

    056cff00: 000b01d8 5bf763f0 5be66028 41091d73 [.....c.[(`.[s..A]

    Dump thread - spid = 1, PSS = 0x411da084, EC = 0x411da234

    Stack Dump being sent to e:\MSSQL7\log\SQL00021.dmp

    *******************************************************************************

    *

    * BEGIN STACK DUMP:

    * 03/30/05 18:19:53 spid 1

    *

    *

    *******************************************************************************

    -------------------------------------------------------------------------------

    Short Stack Dump

    0x77f82870 Module(ntdll+2870) (NtWaitForSingleObject+b)

    0x41092bd7 Module(ums+2bd7) (UmsThreadScheduler::Switch+59)

    0x41091796 Module(ums+1796) (UmsScheduler::Suspend+b2)

    0x41091614 Module(ums+1614) (UmsEvent::Wait+85)

    0x004a6091 Module(sqlservr+a6091) (SignalProc+be)

    0x004a65eb Module(sqlservr+a65eb) (init_routine+49f)

    0x41092a15 Module(ums+2a15) (ProcessWorkRequests+ed)

    0x410932cb Module(ums+32cb) (ThreadStartRoutine+139)

    0x78008454 Module(MSVCRT+8454) (endthread+c1)

    0x7c57438b Module(KERNEL32+438b) (TlsSetValue+f0)

    Dump thread - spid = 2, PSS = 0x4122c084, EC = 0x4122c234

    Stack Dump being sent to e:\MSSQL7\log\SQL00021.dmp

    *******************************************************************************

    *

    * BEGIN STACK DUMP:

    * 03/30/05 18:19:55 spid 2

    *

    *

    *******************************************************************************

    -------------------------------------------------------------------------------

    Short Stack Dump

    0x77f82870 Module(ntdll+2870) (NtWaitForSingleObject+b)

    0x41092bd7 Module(ums+2bd7) (UmsThreadScheduler::Switch+59)

    0x41091796 Module(ums+1796) (UmsScheduler::Suspend+b2)

    0x41091614 Module(ums+1614) (UmsEvent::Wait+85)

    0x00401479 Module(sqlservr+1479) (ExecutionContext::WaitForSignal+192)

    0x00401738 Module(sqlservr+1738) (ResQueueBase::Wait+36)

    0x00401650 Module(sqlservr+1650) (ResQueueBase:equeue+6d)

    0x004a7e2e Module(sqlservr+a7e2e) (lockMonitor+e8)

    0x004a7bf4 Module(sqlservr+a7bf4) (lockMonitorThread+a7)

    0x41092a15 Module(ums+2a15) (ProcessWorkRequests+ed)

    0x410932cb Module(ums+32cb) (ThreadStartRoutine+139)

    0x78008454 Module(MSVCRT+8454) (endthread+c1)

    0x7c57438b Module(KERNEL32+438b) (TlsSetValue+f0)

    Dump thread - spid = 3, PSS = 0x4122e084, EC = 0x4122e23

    ---------------------------------------------------------------

    There is lot more in this dump.

    - This is SQL Server 7.0 with SP4

    - I am unable to get any solution from Microsoft.

    - Do I need to upgrade this to SP4 ?

    - Recently I found this "memory module" warning in event viewer.

    "Warning: Memory module #3 on board #1 has exceeded its threshold of correctable errors. Subsequent correctable memory errors will continue to be corrected, but memory error reporting will cease until the system is rebooted".

    - Some times the SQL Server stops responding. I wont be able to

    log into the server from QA unless the SQL services are

    restarted.

    Sorry for the very long material pasted here.

    Any Help Would be Greatly Appreciated

    Thanks

    Phani

  • I think you might have answered your own questions.  It sounds to me as if you have some bad memory in the server and it's causing SQL to throw an exception whenever it's being referenced.

    Of course others might have a different point of view?

  • Nothing in the min dump explicitly points to a memory error, but it is only dumping out what is in memory at the time. I agree that the memory module is a prime suspect. You could limit the amount of memory SQL is using to stop it dumping - maybe to 2048MB. Also your page file might be a bit small for the amount of RAM - maybe increase to 5GB or 6GB.

  • If you are running SQL 7 Service Pack 1

    Denial of Service attacks can cause the server to abend and stackdump

    Bug fix -- upgrade to latest Service Pack for SQL7

    check out Microsoft Q248749

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply