Re: SQL Server 2005 hang up

From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
Date: Thu, 20 Aug 2009 21:00:34 +0200

Having stack dumps, I'd open a case with MS Support if I were you.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"yong" <yong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:47ED1CE6-9B0C-4078-B9AA-4AE39FC2707C@xxxxxxxxxxxxxxxx

Hi,

Our production databases hang up yesterday somehow, we even couldn't stop
SQL-Server service (no response). we had to re-boot the server.
Please help.
--------------------------------------------------
SQL Server 2005 SP2 under Windows 2003 R2 SP1 (x86, 4GB memory).
-------------------------------------------------
The SQL Log:
2009-08-20 00:55:02.68 spid101 Using 'dbghelp.dll' version '4.0.5'
2009-08-20 00:55:02.69 spid101 ***Stack Dump being sent to
D:\data\MSSQL\LOG\SQLDump0397.txt
2009-08-20 00:55:02.69 spid101 SqlDumpExceptionHandler: Process 101
generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
2009-08-20 00:55:02.69 spid101 *
*******************************************************************************
2009-08-20 00:55:02.69 spid101 *
2009-08-20 00:55:02.69 spid101 * BEGIN STACK DUMP:
2009-08-20 00:55:02.69 spid101 * 08/20/09 00:55:02 spid 101
2009-08-20 00:55:02.69 spid101 *
2009-08-20 00:55:02.69 spid101 *
2009-08-20 00:55:02.69 spid101 * Exception Address = 78145148
Module(MSVCR80+00015148)
2009-08-20 00:55:02.69 spid101 * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
2009-08-20 00:55:02.69 spid101 * Access Violation occurred reading
address 00000000
2009-08-20 00:55:02.69 spid101 * Input Buffer 181 bytes -
2009-08-20 00:55:02.69 spid101 * ! m a s t e r . . 21 00 6d 00 61 00
73 00 74 00 65 00 72 00 2e 00 2e 00
2009-08-20 00:55:02.69 spid101 * s p _ M S c h e c 73 00 70 00 5f 00
4d 00 53 00 63 00 68 00 65 00 63 00
2009-08-20 00:55:02.69 spid101 * k _ a g e n t _ i 6b 00 5f 00 61 00
67 00 65 00 6e 00 74 00 5f 00 69 00
2009-08-20 00:55:02.69 spid101 * n s t a n c e 6e 00 73 00 74 00
61 00 6e 00 63 00 65 00 00 00 00 00
2009-08-20 00:55:02.69 spid101 * çZ Z U S A 2 e7 5a 00 00 00 00
00 00 5a 00 55 00 53 00 41 00 32 00
2009-08-20 00:55:02.69 spid101 * 0 2 4 - k m a r t 30 00 32 00 34 00
2d 00 6b 00 6d 00 61 00 72 00 74 00
2009-08-20 00:55:02.69 spid101 * - k m a r t _ M e 2d 00 6b 00 6d 00
61 00 72 00 74 00 5f 00 4d 00 65 00
2009-08-20 00:55:02.69 spid101 * r g e _ O t h e r 72 00 67 00 65 00
5f 00 4f 00 74 00 68 00 65 00 72 00
2009-08-20 00:55:02.69 spid101 * B - U S A 2 0 3 0 42 00 2d 00 55 00
53 00 41 00 32 00 30 00 33 00 30 00
2009-08-20 00:55:02.69 spid101 * B - 2 8 2 & 42 00 2d 00 32 00
38 00 32 00 00 00 26 04 04 04 00 00
2009-08-20 00:55:02.69 spid101 * 00
2009-08-20 00:55:02.69 spid101 *
2009-08-20 00:55:02.69 spid101 *
2009-08-20 00:55:02.69 spid101 * MODULE BASE
END SIZE
2009-08-20 00:55:02.69 spid101 * sqlservr 01000000
02C09FFF 01c0a000
2009-08-20 00:55:02.69 spid101 * ntdll 7C800000
7C8BFFFF 000c0000
2009-08-20 00:55:02.69 spid101 * kernel32 77E40000
77F41FFF 00102000
2009-08-20 00:55:02.69 spid101 * MSVCR80 78130000
781CAFFF 0009b000
2009-08-20 00:55:02.69 spid101 * msvcrt 77BA0000
77BF9FFF 0005a000
2009-08-20 00:55:02.69 spid101 * MSVCP80 7C420000
7C4A6FFF 00087000
2009-08-20 00:55:02.69 spid101 * ADVAPI32 77F50000
77FEBFFF 0009c000
2009-08-20 00:55:02.69 spid101 * RPCRT4 77C50000
77CEEFFF 0009f000
2009-08-20 00:55:02.69 spid101 * USER32 77380000
77411FFF 00092000
2009-08-20 00:55:02.69 spid101 * GDI32 77C00000
77C47FFF 00048000
2009-08-20 00:55:02.69 spid101 * CRYPT32 761B0000
76242FFF 00093000
2009-08-20 00:55:02.69 spid101 * MSASN1 76190000
761A1FFF 00012000
2009-08-20 00:55:02.69 spid101 * Secur32 76F50000
76F62FFF 00013000
2009-08-20 00:55:02.69 spid101 * MSWSOCK 71B20000
71B60FFF 00041000
2009-08-20 00:55:02.69 spid101 * WS2_32 71C00000
71C16FFF 00017000
2009-08-20 00:55:02.69 spid101 * WS2HELP 71BF0000
71BF7FFF 00008000
2009-08-20 00:55:02.69 spid101 * USERENV 76920000
769E3FFF 000c4000
2009-08-20 00:55:02.69 spid101 * opends60 333E0000
333E6FFF 00007000
2009-08-20 00:55:02.69 spid101 * NETAPI32 71C40000
71C97FFF 00058000
2009-08-20 00:55:02.69 spid101 * SHELL32 7C8D0000
7D0D3FFF 00804000
2009-08-20 00:55:02.69 spid101 * SHLWAPI 77DA0000
77DF1FFF 00052000
2009-08-20 00:55:02.69 spid101 * comctl32 77420000
77522FFF 00103000
2009-08-20 00:55:02.69 spid101 * psapi 76B70000
76B7AFFF 0000b000
2009-08-20 00:55:02.69 spid101 * instapi 48060000
48069FFF 0000a000
2009-08-20 00:55:02.69 spid101 * sqlevn70 4F610000
4F7B8FFF 001a9000
2009-08-20 00:55:02.69 spid101 * SQLOS 344D0000
344D4FFF 00005000
2009-08-20 00:55:02.69 spid101 * rsaenh 68000000
6802EFFF 0002f000
2009-08-20 00:55:02.69 spid101 * AUTHZ 76C40000
76C53FFF 00014000
2009-08-20 00:55:02.69 spid101 * MSCOREE 79000000
79044FFF 00045000
2009-08-20 00:55:02.69 spid101 * ole32 77670000
777A3FFF 00134000
2009-08-20 00:55:02.69 spid101 * msv1_0 76C90000
76CB6FFF 00027000
2009-08-20 00:55:02.69 spid101 * iphlpapi 76CF0000
76D09FFF 0001a000
2009-08-20 00:55:02.69 spid101 * kerberos 71CA0000
71CF7FFF 00058000
2009-08-20 00:55:02.69 spid101 * cryptdll 766E0000
766EBFFF 0000c000
2009-08-20 00:55:02.69 spid101 * schannel 76750000
76776FFF 00027000
2009-08-20 00:55:02.69 spid101 * COMRES 77010000
770D5FFF 000c6000
2009-08-20 00:55:02.69 spid101 * XOLEHLP 5D050000
5D055FFF 00006000
2009-08-20 00:55:02.69 spid101 * MSDTCPRX 61150000
611C7FFF 00078000
2009-08-20 00:55:02.69 spid101 * msvcp60 780C0000
78120FFF 00061000
2009-08-20 00:55:02.69 spid101 * MTXCLU 74F40000
74F58FFF 00019000
2009-08-20 00:55:02.69 spid101 * VERSION 77B90000
77B97FFF 00008000
2009-08-20 00:55:02.69 spid101 * WSOCK32 71BB0000
71BB8FFF 00009000
2009-08-20 00:55:02.69 spid101 * OLEAUT32 77D00000
77D8BFFF 0008c000
2009-08-20 00:55:02.69 spid101 * CLUSAPI 74DE0000
74DF1FFF 00012000
2009-08-20 00:55:02.69 spid101 * RESUTILS 74EF0000
74F02FFF 00013000
2009-08-20 00:55:02.69 spid101 * DNSAPI 76ED0000
76EFEFFF 0002f000
2009-08-20 00:55:02.69 spid101 * winrnr 76F70000
76F76FFF 00007000
2009-08-20 00:55:02.69 spid101 * WLDAP32 76F10000
76F3DFFF 0002e000
2009-08-20 00:55:02.69 spid101 * rasadhlp 76F80000
76F87FFF 00008000
2009-08-20 00:55:02.69 spid101 * security 71F60000
71F63FFF 00004000
2009-08-20 00:55:02.69 spid101 * msfte 5DCB0000
5DF08FFF 00259000
2009-08-20 00:55:02.69 spid101 * dbghelp 5DF10000
5E024FFF 00115000
2009-08-20 00:55:02.69 spid101 * WINTRUST 76BB0000
76BDAFFF 0002b000
2009-08-20 00:55:02.69 spid101 * imagehlp 76C10000
76C38FFF 00029000
2009-08-20 00:55:02.69 spid101 * dssenh 68100000
68123FFF 00024000
2009-08-20 00:55:02.69 spid101 * hnetcfg 5F270000
5F2C8FFF 00059000
2009-08-20 00:55:02.69 spid101 * wshtcpip 71AE0000
71AE7FFF 00008000
2009-08-20 00:55:02.69 spid101 * NTMARTA 77E00000
77E21FFF 00022000
2009-08-20 00:55:02.69 spid101 * SAMLIB 5E2C0000
5E2CEFFF 0000f000
2009-08-20 00:55:02.69 spid101 * ntdsapi 766F0000
76704FFF 00015000
2009-08-20 00:55:02.69 spid101 * xpsp2res 5E3E0000
5E6A4FFF 002c5000
2009-08-20 00:55:02.69 spid101 * CLBCatQ 777B0000
77832FFF 00083000
2009-08-20 00:55:02.69 spid101 * sqlncli 5E6B0000
5E8D3FFF 00224000
2009-08-20 00:55:02.69 spid101 * COMCTL32 77530000
775C6FFF 00097000
2009-08-20 00:55:02.69 spid101 * comdlg32 762B0000
762F9FFF 0004a000
2009-08-20 00:55:02.69 spid101 * SQLNCLIR 007A0000
007D2FFF 00033000
2009-08-20 00:55:02.69 spid101 * xpstar90 61570000
615B8FFF 00049000
2009-08-20 00:55:02.69 spid101 * SQLSCM90 615D0000
615D8FFF 00009000
2009-08-20 00:55:02.69 spid101 * ODBC32 615F0000
6162CFFF 0003d000
2009-08-20 00:55:02.69 spid101 * BatchParser90 61630000
6164EFFF 0001f000
2009-08-20 00:55:02.69 spid101 * ATL80 7C630000
7C64AFFF 0001b000
2009-08-20 00:55:02.69 spid101 * odbcint 61820000
61836FFF 00017000
2009-08-20 00:55:02.69 spid101 * xpstar90 61840000
61865FFF 00026000
2009-08-20 00:55:02.69 spid101 * xpsqlbot 61A30000
61A35FFF 00006000
2009-08-20 00:55:02.69 spid101 * xplog70 61A50000
61A5BFFF 0000c000
2009-08-20 00:55:02.69 spid101 * xplog70 61A70000
61A72FFF 00003000
2009-08-20 00:55:02.69 spid101 * msxmlsql 78800000
788D4FFF 000d5000
2009-08-20 00:55:02.69 spid101 * msxml2 609C0000
60A6EFFF 000af000
2009-08-20 00:55:02.69 spid101 * msxml3 72E50000
72F61FFF 00112000
2009-08-20 00:55:02.69 spid101 * sqlvdi 62E80000
62EA1FFF 00022000
2009-08-20 00:55:02.69 spid101 * xprepl 5DA60000
5DA71FFF 00012000
2009-08-20 00:55:02.69 spid101 * dbghelp 60740000
60854FFF 00115000
2009-08-20 00:55:02.69 spid101 *
2009-08-20 00:55:02.69 spid101 * Edi: 37FB4BA8: 00000501
05000000 00000015 1FB01B71 0C5D3144 1F6432A7
2009-08-20 00:55:02.69 spid101 * Esi: 00000000:
2009-08-20 00:55:02.69 spid101 * Eax: 0000001C:
2009-08-20 00:55:02.69 spid101 * Ebx: 3844C47C: 000014F8
00000000 00000000 027A0000 00000000 3844DAD8
2009-08-20 00:55:02.69 spid101 * Ecx: 00000007:
2009-08-20 00:55:02.69 spid101 * Edx: 00000000:
2009-08-20 00:55:02.69 spid101 * Eip: 78145148: E48E448B
E48F4489 E88E448B E88F4489 EC8E448B EC8F4489
2009-08-20 00:55:02.69 spid101 * Ebp: 6039F488: 6039F4B0
01C1401F 37FB4BA8 00000000 0000001C 3844C278
2009-08-20 00:55:02.69 spid101 * SegCs: 0000001B:
2009-08-20 00:55:02.69 spid101 * EFlags: 00010297: 57005C00
4E004900 4F004400 53005700 53005C00 73007900
2009-08-20 00:55:02.69 spid101 * Esp: 6039F480: 3844C47C
0000001C 6039F4B0 01C1401F 37FB4BA8 00000000
2009-08-20 00:55:02.69 spid101 * SegSs: 00000023:
2009-08-20 00:55:02.69 spid101 *
*******************************************************************************
2009-08-20 00:55:02.69 spid101 *
-------------------------------------------------------------------------------
2009-08-20 00:55:02.69 spid101 * Short Stack Dump
2009-08-20 00:55:02.71 spid101 78145148 Module(MSVCR80+00015148)
2009-08-20 00:55:02.71 spid101 01C1401F Module(sqlservr+00C1401F)
2009-08-20 00:55:02.71 spid101 01B8A4D2 Module(sqlservr+00B8A4D2)
2009-08-20 00:55:02.71 spid101 012550CB Module(sqlservr+002550CB)
2009-08-20 00:55:02.71 spid101 01214BCE Module(sqlservr+00214BCE)
2009-08-20 00:55:02.71 spid101 01214BF1 Module(sqlservr+00214BF1)
2009-08-20 00:55:02.71 spid101 01058762 Module(sqlservr+00058762)
2009-08-20 00:55:02.71 spid101 0102A160 Module(sqlservr+0002A160)
2009-08-20 00:55:02.71 spid101 01024D2A Module(sqlservr+00024D2A)
2009-08-20 00:55:02.71 spid101 0104AEE6 Module(sqlservr+0004AEE6)
2009-08-20 00:55:02.71 spid101 01025B64 Module(sqlservr+00025B64)
2009-08-20 00:55:02.71 spid101 01025A21 Module(sqlservr+00025A21)
2009-08-20 00:55:02.71 spid101 01025960 Module(sqlservr+00025960)
2009-08-20 00:55:02.71 spid101 010257A6 Module(sqlservr+000257A6)
2009-08-20 00:55:02.71 spid101 010227F3 Module(sqlservr+000227F3)
2009-08-20 00:55:02.71 spid101 010293B5 Module(sqlservr+000293B5)
2009-08-20 00:55:02.71 spid101 010286DC Module(sqlservr+000286DC)
2009-08-20 00:55:02.71 spid101 01032A36 Module(sqlservr+00032A36)
2009-08-20 00:55:02.71 spid101 0102F1F4 Module(sqlservr+0002F1F4)
2009-08-20 00:55:02.71 spid101 010077A6 Module(sqlservr+000077A6)
2009-08-20 00:55:02.71 spid101 010078CC Module(sqlservr+000078CC)
2009-08-20 00:55:02.71 spid101 010075DC Module(sqlservr+000075DC)
2009-08-20 00:55:02.71 spid101 010B94A5 Module(sqlservr+000B94A5)
2009-08-20 00:55:02.71 spid101 010B939C Module(sqlservr+000B939C)
2009-08-20 00:55:02.71 spid101 010B9064 Module(sqlservr+000B9064)
2009-08-20 00:55:02.71 spid101 010B9201 Module(sqlservr+000B9201)
2009-08-20 00:55:02.71 spid101 781329BB Module(MSVCR80+000029BB)
2009-08-20 00:55:02.71 spid101 78132A47 Module(MSVCR80+00002A47)
2009-08-20 00:55:02.71 spid101 Stack Signature for the dump is 0x33DFDC73
2009-08-20 00:55:03.74 spid101 External dump process return code
0x20000001.
External dump process returned no errors.

2009-08-20 00:55:03.76 Server Error: 17310, Severity: 20, State: 1.
2009-08-20 00:55:03.76 Server A user request from the session with SPID
101 generated a fatal exception. SQL Server is terminating this session.
Contact Product Support Services with the dump produced in the log directory.
2009-08-20 00:55:03.83 spid143 Error: 14151, Severity: 18, State: 1.
2009-08-20 00:55:03.83 spid143 Replication-agentclassname: agent
USA2024-kmart-kmart_Merge_OtherB-USA2030B-282 failed. The merge process could
not initialize the Publisher 'USA2024:kmart'.

2009-08-20 00:56:05.64 Server Using 'dbghelp.dll' version '4.0.5'
2009-08-20 00:56:05.64 Server **Dump thread - spid = 0, PSS =
0x00000000, EC = 0x00000000
2009-08-20 00:56:05.64 Server ***Stack Dump being sent to
D:\data\MSSQL\LOG\SQLDump0398.txt
2009-08-20 00:56:05.64 Server *
*******************************************************************************
2009-08-20 00:56:05.64 Server *
2009-08-20 00:56:05.64 Server * BEGIN STACK DUMP:
2009-08-20 00:56:05.64 Server * 08/20/09 00:56:05 spid 0
2009-08-20 00:56:05.64 Server *
2009-08-20 00:56:05.64 Server * Deadlocked Schedulers
2009-08-20 00:56:05.64 Server *
2009-08-20 00:56:05.64 Server *
*******************************************************************************
2009-08-20 00:56:05.64 Server *
-------------------------------------------------------------------------------
2009-08-20 00:56:05.64 Server * Short Stack Dump
2009-08-20 00:56:05.66 Server Stack Signature for the dump is 0x000001BC
2009-08-20 00:56:06.18 Server External dump process return code
0x20000001.
External dump process returned no errors.

2009-08-20 00:56:06.18 Server New queries assigned to process on Node 0
have not been picked up by a worker thread in the last 60 seconds. Blocking
or long-running queries can contribute to this condition, and may degrade
client response time. Use the "max worker threads" configuration option to
increase number of allowable threads, or optimize current running queries.
SQL Process Utilization: 0%. System Idle: 99%.

2009-08-20 00:56:26.19 Server Using 'dbghelp.dll' version '4.0.5'
2009-08-20 00:56:26.19 Server ***Unable to get thread context - no pss
2009-08-20 00:56:26.19 Server *
*******************************************************************************
2009-08-20 00:56:26.19 Server *
2009-08-20 00:56:26.19 Server * BEGIN STACK DUMP:
2009-08-20 00:56:26.19 Server * 08/20/09 00:56:26 spid 0
2009-08-20 00:56:26.19 Server *
2009-08-20 00:56:26.19 Server * Non-yielding Scheduler
2009-08-20 00:56:26.19 Server *
2009-08-20 00:56:26.19 Server *
*******************************************************************************
2009-08-20 00:56:26.19 Server Stack Signature for the dump is 0x000001BC
2009-08-20 00:56:27.14 Server External dump process return code
0x20000001.
External dump process returned no errors.

2009-08-20 00:56:27.14 Server Process 226:0:0 (0x1400) Worker
0x171DE0E8 appears to be non-yielding on Scheduler 0. Thread creation time:
12895217703431. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process
Utilization 0%. System Idle 99%. Interval: 75545 ms.
2009-08-20 00:56:27.14 Server Process 227:0:0 (0x1320) Worker
0x5BD460E8 appears to be non-yielding on Scheduler 1. Thread creation time:
12895210802345. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process
Utilization 0%. System Idle 99%. Interval: 76498 ms.
2009-08-20 00:56:27.14 Server Process 248:0:0 (0x1714) Worker
0x390EC0E8 appears to be non-yielding on Scheduler 2. Thread creation time:
12895217702806. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process
Utilization 0%. System Idle 99%. Interval: 76498 ms.
2009-08-20 00:56:27.14 Server Process 215:0:0 (0xae8) Worker 0x110940E8
appears to be non-yielding on Scheduler 3. Thread creation time:
12895080812500. Approx Thread CPU Used: kernel 0 ms, user 0 ms. Process
Utilization 0%. System Idle 99%. Interval: 76498 ms.
2009-08-20 00:57:07.14 Server New queries assigned to process on Node 0
have not been picked up by a worker thread in the last 120 seconds. Blocking
or long-running queries can contribute to this condition, and may degrade
client response time. Use the "max worker threads" configuration option to
increase number of allowable threads, or optimize current running queries.
SQL Process Utilization: 0%. System Idle: 99%.
---------------------------------------------------------
There are 3 dump files in LOG Folder
---------------------------------------------------------
After That, the last 4 messages were written into log every minute, and SQL
Server didn't response any request from client, we couldn't stop SQL Server
Service either, CPU idle time up to 99%.

What's wrong with SQL Server?

PLEASE HELP

THANKS

Yong

References:
- SQL Server 2005 hang up
  - From: yong

Prev by Date: Restore to different version of SQL
Next by Date: Re: Restore to different version of SQL
Previous by thread: SQL Server 2005 hang up
Next by thread: Re: SQL Server 2005 hang up
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Server 2005 hang up
... You have stumbled across a bug in SQL Server 2005. ... External dump process returned no errors. ... System Idle 99%. ...
(microsoft.public.sqlserver.server)
Re: Moving a PostgreSQL database from one server to another
... it seems those are commands ... > to be typed in at the BASH shell, not inside psql... ... A running server hooks into the db and blocks the dump. ...
(Fedora)
rdump problem
... I am trying to rdump from server 2 to server1 and am getting ... rcmd: socket: Permission denied ... dump: Date of last level dump: the start of the epoch ...
(Tru64-UNIX-Managers)
Re: MMC.exe stops responding for up to 5 minutes during AD GPO browse / edit
... > -The oldest file in the same folder on the test VPC server is 9/25/1999 ... >>> kernel dump it should show up. ... >>>> it may be our self and that it may be a filter driver in the kernel. ...
(microsoft.public.windows.server.active_directory)
Re: Need Help Creating Memory.DMP File....
... If you make some registry adjustments, you can manaully trigger a memory ... dump using the keyboard when your system is hung/locked up. ... > DEFAULT Windows Server screensaver was locked in one position. ... If I have 'Automatically Restart' CHECKED, ...
(microsoft.public.windows.server.general)