March 31, 2005 at 2:28 am
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
March 31, 2005 at 5:06 am
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?
April 1, 2005 at 3:08 am
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.
February 28, 2006 at 10:25 am
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