December 30, 2008 at 5:01 pm
Hi,
I have noticed in my error log below error:
could you please what this info mean and why it is occured.Its a production box SQL Server 2005 EE x64. plz help me
2008-12-29 19:47:10.48 Server Using 'dbghelp.dll' version '4.0.5'
2008-12-29 19:47:10.52 Server **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000
2008-12-29 19:47:10.52 Server ***Stack Dump being sent to E:\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump0001.txt
2008-12-29 19:47:10.52 Server * *******************************************************************************
2008-12-29 19:47:10.52 Server *
2008-12-29 19:47:10.52 Server * BEGIN STACK DUMP:
2008-12-29 19:47:10.52 Server * 12/29/08 19:47:10 spid 0
2008-12-29 19:47:10.53 Server *
2008-12-29 19:47:10.53 Server * Location: srvproc.cpp:303
2008-12-29 19:47:10.53 Server * Expression: 0 <= cTotalRef
2008-12-29 19:47:10.53 Server * SPID: 0
2008-12-29 19:47:10.53 Server * Process ID: 6524
2008-12-29 19:47:10.53 Server *
2008-12-29 19:47:10.53 Server *
2008-12-29 19:47:10.53 Server * MODULE BASE END SIZE
2008-12-29 19:47:10.53 Server * sqlservr 0000000001000000 0000000003501FFF 02502000
2008-12-29 19:47:10.53 Server * ntdll 0000000077EC0000 0000000077FF8FFF 00139000
2008-12-29 19:47:10.53 Server * kernel32 0000000077D40000 0000000077EB2FFF 00173000
2008-12-29 19:47:10.53 Server * MSVCR80 0000000078130000 00000000781F8FFF 000c9000
2008-12-29 19:47:10.53 Server * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000
2008-12-29 19:47:10.53 Server * MSVCP80 000000007C420000 000000007C528FFF 00109000
2008-12-29 19:47:10.53 Server * ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000
2008-12-29 19:47:10.53 Server * RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000
2008-12-29 19:47:10.53 Server * Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000
2008-12-29 19:47:10.53 Server * USER32 0000000077C20000 0000000077D2BFFF 0010c000
2008-12-29 19:47:10.53 Server * GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000
2008-12-29 19:47:10.53 Server * CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000
2008-12-29 19:47:10.53 Server * MSASN1 000007FF7D340000 000007FF7D369FFF 0002a000
2008-12-29 19:47:10.53 Server * MSWSOCK 000007FF771B0000 000007FF7722CFFF 0007d000
2008-12-29 19:47:10.53 Server * WS2_32 000007FF77310000 000007FF7733FFFF 00030000
2008-12-29 19:47:10.53 Server * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000
2008-12-29 19:47:10.53 Server * USERENV 000007FF7C680000 000007FF7C789FFF 0010a000
2008-12-29 19:47:10.53 Server * opends60 00000000333E0000 00000000333E7FFF 00008000
2008-12-29 19:47:10.53 Server * NETAPI32 000007FF77370000 000007FF77407FFF 00098000
2008-12-29 19:47:10.53 Server * SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000
2008-12-29 19:47:10.53 Server * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000
2008-12-29 19:47:10.53 Server * IMM32 000007FF7D500000 000007FF7D538FFF 00039000
2008-12-29 19:47:10.53 Server * comctl32 000007FF7F000000 000007FF7F186FFF 00187000
2008-12-29 19:47:10.53 Server * psapi 000007FF7E380000 000007FF7E38FFFF 00010000
2008-12-29 19:47:10.53 Server * instapi 0000000048060000 000000004806CFFF 0000d000
2008-12-29 19:47:10.53 Server * CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000
2008-12-29 19:47:10.53 Server * ole32 000007FF57140000 000007FF573C4FFF 00285000
2008-12-29 19:47:10.53 Server * OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000
2008-12-29 19:47:10.53 Server * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000
2008-12-29 19:47:10.53 Server * sqlevn70 000000004F610000 000000004F7B8FFF 001a9000
2008-12-29 19:47:10.53 Server * SQLOS 00000000344D0000 00000000344D5FFF 00006000
2008-12-29 19:47:10.53 Server * rsaenh 0000000068000000 000000006804BFFF 0004c000
2008-12-29 19:47:10.53 Server * AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000
2008-12-29 19:47:10.53 Server * MSCOREE 000006427EE60000 000006427EED3FFF 00074000
2008-12-29 19:47:10.53 Server * msv1_0 000007FF7E500000 000007FF7E543FFF 00044000
2008-12-29 19:47:10.53 Server * iphlpapi 000007FF57040000 000007FF57070FFF 00031000
2008-12-29 19:47:10.53 Server * kerberos 000007FF77410000 000007FF774C3FFF 000b4000
2008-12-29 19:47:10.53 Server * cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000
2008-12-29 19:47:10.53 Server * schannel 000007FF7DD50000 000007FF7DD90FFF 00041000
2008-12-29 19:47:10.53 Server * COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000
2008-12-29 19:47:10.53 Server * XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000
2008-12-29 19:47:10.53 Server * MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000
2008-12-29 19:47:10.53 Server * msvcp60 000000000D860000 000000000D949FFF 000ea000
2008-12-29 19:47:10.53 Server * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000
2008-12-29 19:47:10.53 Server * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2008-12-29 19:47:10.53 Server * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000
2008-12-29 19:47:10.53 Server * DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000
2008-12-29 19:47:10.53 Server * winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000
2008-12-29 19:47:10.53 Server * WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000
2008-12-29 19:47:10.53 Server * rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000
2008-12-29 19:47:10.53 Server * hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000
2008-12-29 19:47:10.53 Server * wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000
2008-12-29 19:47:10.53 Server * security 000007FF77530000 000007FF77534FFF 00005000
2008-12-29 19:47:10.53 Server * msfte 0000000049980000 0000000049D2DFFF 003ae000
2008-12-29 19:47:10.53 Server * dbghelp 0000000010100000 000000001025CFFF 0015d000
2008-12-29 19:47:10.53 Server * WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000
2008-12-29 19:47:10.53 Server * imagehlp 000007FF7E470000 000007FF7E482FFF 00013000
2008-12-29 19:47:10.53 Server * dssenh 0000000068100000 000000006813EFFF 0003f000
2008-12-29 19:47:10.53 Server * NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000
2008-12-29 19:47:10.53 Server * SAMLIB 000007FF77150000 000007FF77165FFF 00016000
2008-12-29 19:47:10.53 Server * ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000
2008-12-29 19:47:10.53 Server * xpsp2res 0000000010670000 0000000010936FFF 002c7000
2008-12-29 19:47:10.53 Server * CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000
2008-12-29 19:47:10.53 Server * sqlncli 00000000337A0000 0000000033A5FFFF 002c0000
2008-12-29 19:47:10.53 Server * COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000
2008-12-29 19:47:10.53 Server * comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000
2008-12-29 19:47:10.53 Server * SQLNCLIR 0000000035000000 0000000035032FFF 00033000
2008-12-29 19:47:10.53 Server * msftepxy 0000000003850000 0000000003870FFF 00021000
2008-12-29 19:47:10.53 Server * xpstar90 0000000053C30000 0000000053CB5FFF 00086000
2008-12-29 19:47:10.53 Server * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
2008-12-29 19:47:10.53 Server * ODBC32 000007FF63F00000 000007FF63F66FFF 00067000
2008-12-29 19:47:10.53 Server * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
2008-12-29 19:47:10.53 Server * ATL80 000000007C630000 000000007C64DFFF 0001e000
2008-12-29 19:47:10.53 Server * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000
2008-12-29 19:47:10.53 Server * xpstar90 0000000012B60000 0000000012B85FFF 00026000
2008-12-29 19:47:10.53 Server * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
2008-12-29 19:47:10.53 Server * xplog70 0000000034730000 000000003473FFFF 00010000
2008-12-29 19:47:10.53 Server * xplog70 0000000012E50000 0000000012E52FFF 00003000
2008-12-29 19:47:10.53 Server *
2008-12-29 19:47:10.53 Server * P1Home: 0000000000000001:
2008-12-29 19:47:10.53 Server * P2Home: 00000000061CD7A0: 000A003000300030 0000000000000000 0000000000000000 0000000000000000 0000000000000030 0000000000000000
2008-12-29 19:47:10.53 Server * P3Home: 0000000000000000:
2008-12-29 19:47:10.53 Server * P4Home: 0000000077EF40C2: 00000320249C8B48 0000031824B48B48 0000031024BC8B48 0000030824A48B4C 0000030024AC8B4C 000002F824B48B4C
2008-12-29 19:47:10.53 Server * P5Home: 0000000000000000:
2008-12-29 19:47:10.53 Server * P6Home: 0000000000000000:
2008-12-29 19:47:10.53 Server * ContextFlags: 000000000010000F:
2008-12-29 19:47:10.53 Server * MxCsr: 0000000000001F80:
2008-12-29 19:47:10.53 Server * SegCs: 0000000000000033:
2008-12-29 19:47:10.53 Server * SegDs: 000000000000002B:
2008-12-29 19:47:10.53 Server * SegEs: 000000000000002B:
2008-12-29 19:47:10.53 Server * SegFs: 0000000000000053:
2008-12-29 19:47:10.53 Server * SegGs: 000000000000002B:
2008-12-29 19:47:10.53 Server * SegSs: 000000000000002B:
2008-12-29 19:47:10.53 Server * EFlags: 0000000000000206:
2008-12-29 19:47:10.53 Server * Rax: 00000000061CD828: 0000000077D67D8D 00000000586C7C30 0000000000000000 00000000061CDAE0 0000000000000000 00000000000042AC
2008-12-29 19:47:10.53 Server * Rcx: 00000000061CD350: 0000000000000001 00000000061CD7A0 0000000000000000 0000000077EF40C2 0000000000000000 0000000000000000
2008-12-29 19:47:10.53 Server * Rdx: 0000000000000000:
2008-12-29 19:47:10.53 Server * Rbx: 0000000000000000:
2008-12-29 19:47:10.53 Server * Rsp: 00000000061CD830: 00000000586C7C30 0000000000000000 00000000061CDAE0 0000000000000000 00000000000042AC 0000000000000000
2008-12-29 19:47:10.53 Server * Rbp: 00000000061CEF80: 000000000000012F 000000002E9B0000 000000E900000001 0000000000000001 00000000061CF029 000000007FFFFFE5
2008-12-29 19:47:10.53 Server * Rsi: 00000000061CDAE0: 00000000586C7C30 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2008-12-29 19:47:10.53 Server * Rdi: 0000000000000000:
2008-12-29 19:47:10.53 Server * R8: 0000000000000000:
2008-12-29 19:47:10.53 Server * R9: 0000000000000000:
2008-12-29 19:47:10.53 Server * R10: 0000000000000000:
2008-12-29 19:47:10.53 Server * R11: 00000000061CE020: 0000000000000001 00000000061CD7A0 0000000000000000 0000000077EF40C2 0000000000000000 0000000000000000
2008-12-29 19:47:10.53 Server * R12: 000000000000003F:
2008-12-29 19:47:10.53 Server * R13: 0000000000000000:
2008-12-29 19:47:10.53 Server * R14: 00000000061CEED0: 00610063006F004C 006E006F00690074 007300200009003A 0072007000760072 0063002E0063006F 0033003A00700070
2008-12-29 19:47:10.53 Server * R15: 0000000000000001:
2008-12-29 19:47:10.53 Server * Rip: 0000000077D67D8D: C3000000C8C48148 15FF984B8D49D233 8699E990FFFD96DF 9090909090900000 834853C08B909090 0C0CEA158B4830EC
2008-12-29 19:47:10.53 Server * *******************************************************************************
2008-12-29 19:47:10.53 Server * -------------------------------------------------------------------------------
2008-12-29 19:47:10.53 Server * Short Stack Dump
2008-12-29 19:47:10.59 Server 0000000077D67D8D Module(kernel32+0000000000027D8D)
2008-12-29 19:47:10.59 Server 0000000001D345DE Module(sqlservr+0000000000D345DE)
2008-12-29 19:47:10.59 Server 0000000001D3F3A9 Module(sqlservr+0000000000D3F3A9)
2008-12-29 19:47:10.59 Server 000000000247E28C Module(sqlservr+000000000147E28C)
2008-12-29 19:47:10.59 Server 00000000014CBA27 Module(sqlservr+00000000004CBA27)
2008-12-29 19:47:10.59 Server 0000000001034497 Module(sqlservr+0000000000034497)
2008-12-29 19:47:10.59 Server 0000000001033BAB Module(sqlservr+0000000000033BAB)
2008-12-29 19:47:10.59 Server 0000000001033650 Module(sqlservr+0000000000033650)
2008-12-29 19:47:10.59 Server 000000000100685E Module(sqlservr+000000000000685E)
2008-12-29 19:47:10.59 Server 0000000001006F11 Module(sqlservr+0000000000006F11)
2008-12-29 19:47:10.59 Server 0000000001006A01 Module(sqlservr+0000000000006A01)
2008-12-29 19:47:10.59 Server 00000000010EF7A7 Module(sqlservr+00000000000EF7A7)
2008-12-29 19:47:10.59 Server 00000000010F051A Module(sqlservr+00000000000F051A)
2008-12-29 19:47:10.59 Server 00000000010F03F1 Module(sqlservr+00000000000F03F1)
2008-12-29 19:47:10.61 Server 00000000010F0289 Module(sqlservr+00000000000F0289)
2008-12-29 19:47:10.61 Server 00000000781337D7 Module(MSVCR80+00000000000037D7)
2008-12-29 19:47:10.61 Server 0000000078133894 Module(MSVCR80+0000000000003894)
2008-12-29 19:47:10.61 Server 0000000077D6B6DA Module(kernel32+000000000002B6DA)
2008-12-29 19:47:10.61 Server Stack Signature for the dump is 0x000000003FC93780
2008-12-29 19:47:12.77 Server External dump process return code 0x20000001.
External dump process returned no errors.
2008-12-29 19:47:12.77 Server Error: 17066, Severity: 16, State: 1.
2008-12-29 19:47:12.77 Server SQL Server Assertion: File: , line=303 Failed Assertion = '0 <= cTotalRef'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
2008-12-29 19:47:12.78 Server ERROR: IO completion routine raised unhandled exception. Major: 36, Minor 24, Severity 20, State 1, IO CompRequest 0x000000008611F330, IO CompKey 0x0000000000000000, Address: 0x000000000247E5BA
Thank You
December 30, 2008 at 7:17 pm
You need to contact Microsoft Product Support. That kind of problem is something that really needs to be handled at their level.
December 30, 2008 at 7:38 pm
The first thing you need to do is run an integrity check on that database - just as the message is telling you (sorry, but I have to wonder if anyone ever reads these things anymore - or do you just expect everybody else to do your job for you????).
2008-12-29 19:47:12.77 Server External dump process return code 0x20000001.
External dump process returned no errors.
2008-12-29 19:47:12.77 Server Error: 17066, Severity: 16, State: 1.
2008-12-29 19:47:12.77 Server SQL Server Assertion: File: , line=303 Failed Assertion = '0 <= cTotalRef'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
2008-12-29 19:47:12.78 Server ERROR: IO completion routine raised unhandled exception. Major: 36, Minor 24, Severity 20, State 1, IO CompRequest 0x000000008611F330, IO CompKey 0x0000000000000000, Address: 0x000000000247E5BA
Now, according to this section of the stack dump - it is telling you to run an integrity check on the database. It is also telling you that you if this happens again after rerunning the statement - that you might want to restart SQL Server to, and I quote: or restart the server to ensure in-memory data structures are not corrupted. :end quote.
So, you want to run the following:
DBCC CHECKDB(yourdbhere) WITH ALL_ERRORMSGS, NO_INFOMSGS;
If this completes successfully, and you have restarted SQL Server, and rerunning the statement that caused this again - generates the same error message, you can then call Microsoft because you definitely have an issue.
In the meantime - try to identify the process that is generating this error. You are going to need to find out what statement is being run.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 1:07 am
Hi Jefferey,
I just wanna share my problems that I have encountered...sothat everybody will know the problem I faced and the solution I got from the forum experts
and Iam not just expecting everybody else to do my job.This error message I got for the very first time and something like strange for me and Iam asking for suggestions from the forum members.
I ran the DBCC CHECKDB for all the databases and I did not get any errors. More over, we have Biztalk application running,which stored its databases in Sql server. Initially i realized that this error dump is hapened while the appilcation is running.So,If any body experienced this plz explain me...
Thanks for Sqlservercentral.com
Mani
December 31, 2008 at 1:23 am
Hi Cain,
Thanks for suggestion....But last couple of weeks ago we got similar kind of error which is directly telling that you need to contact microsoft as below..
2008-12-09 17:54:07.97 spid204 ex_raise2: Exception raised, major=52, minor=43, state=1, severity=22, attempting to create symptom dump
2008-12-09 17:54:07.97 spid204 Using 'dbghelp.dll' version '4.0.5'
2008-12-09 17:54:08.04 spid204 **Dump thread - spid = 204, PSS = 0x0000000166579BB0, EC = 0x0000000166579BC0
2008-12-09 17:54:08.04 spid204 *
2008-12-09 17:54:08.04 spid204 * User initiated stack dump. This is not a server exception dump.
2008-12-09 17:54:08.04 spid204 *
2008-12-09 17:54:08.05 spid204 ***Stack Dump being sent to D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
2008-12-09 17:54:08.05 spid204 * *******************************************************************************
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * BEGIN STACK DUMP:
2008-12-09 17:54:08.05 spid204 * 12/09/08 17:54:08 spid 204
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * ex_raise2: Exception raised, major=52, minor=43, state=1, severity=22
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * Input Buffer 26 bytes -
2008-12-09 17:54:08.05 spid204 * & D o c I 81 01 00 00 00 08 00 26 04 05 44 00 6f 00 63 00 49 00
2008-12-09 17:54:08.05 spid204 * d Ñ J 64 00 d1 04 01 4a 00 00
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * MODULE BASE END SIZE
2008-12-09 17:54:08.07 spid204 * sqlservr 0000000001000000 0000000003501FFF 02502000
2008-12-09 17:54:08.07 spid204 * ntdll 0000000077EC0000 0000000077FF8FFF 00139000
2008-12-09 17:54:08.07 spid204 * kernel32 0000000077D40000 0000000077EB2FFF 00173000
2008-12-09 17:54:08.07 spid204 * MSVCR80 0000000078130000 00000000781F8FFF 000c9000
2008-12-09 17:54:08.07 spid204 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000
2008-12-09 17:54:08.07 spid204 * MSVCP80 000000007C420000 000000007C528FFF 00109000
2008-12-09 17:54:08.07 spid204 * ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000
2008-12-09 17:54:08.07 spid204 * RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000
2008-12-09 17:54:08.07 spid204 * Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000
2008-12-09 17:54:08.07 spid204 * USER32 0000000077C20000 0000000077D2BFFF 0010c000
2008-12-09 17:54:08.07 spid204 * GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000
2008-12-09 17:54:08.07 spid204 * CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000
2008-12-09 17:54:08.07 spid204 * MSASN1 000007FF7D340000 000007FF7D369FFF 0002a000
2008-12-09 17:54:08.07 spid204 * MSWSOCK 000007FF771B0000 000007FF7722CFFF 0007d000
2008-12-09 17:54:08.07 spid204 * WS2_32 000007FF77310000 000007FF7733FFFF 00030000
2008-12-09 17:54:08.07 spid204 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000
2008-12-09 17:54:08.07 spid204 * USERENV 000007FF7C680000 000007FF7C789FFF 0010a000
2008-12-09 17:54:08.07 spid204 * opends60 00000000333E0000 00000000333E7FFF 00008000
2008-12-09 17:54:08.07 spid204 * NETAPI32 000007FF77370000 000007FF77407FFF 00098000
2008-12-09 17:54:08.07 spid204 * SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000
2008-12-09 17:54:08.07 spid204 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000
2008-12-09 17:54:08.07 spid204 * IMM32 000007FF7D500000 000007FF7D538FFF 00039000
2008-12-09 17:54:08.07 spid204 * comctl32 000007FF7F000000 000007FF7F186FFF 00187000
2008-12-09 17:54:08.07 spid204 * psapi 000007FF7E380000 000007FF7E38FFFF 00010000
2008-12-09 17:54:08.07 spid204 * instapi 0000000048060000 000000004806CFFF 0000d000
2008-12-09 17:54:08.07 spid204 * CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000
2008-12-09 17:54:08.07 spid204 * ole32 000007FF57140000 000007FF573C4FFF 00285000
2008-12-09 17:54:08.07 spid204 * OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000
2008-12-09 17:54:08.07 spid204 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000
2008-12-09 17:54:08.07 spid204 * sqlevn70 000000004F610000 000000004F7B8FFF 001a9000
2008-12-09 17:54:08.07 spid204 * SQLOS 00000000344D0000 00000000344D5FFF 00006000
2008-12-09 17:54:08.07 spid204 * rsaenh 0000000068000000 000000006804BFFF 0004c000
2008-12-09 17:54:08.07 spid204 * AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000
2008-12-09 17:54:08.07 spid204 * MSCOREE 000006427EE60000 000006427EED3FFF 00074000
2008-12-09 17:54:08.07 spid204 * msv1_0 000007FF7E500000 000007FF7E543FFF 00044000
2008-12-09 17:54:08.07 spid204 * iphlpapi 000007FF57040000 000007FF57070FFF 00031000
2008-12-09 17:54:08.07 spid204 * kerberos 000007FF77410000 000007FF774C3FFF 000b4000
2008-12-09 17:54:08.07 spid204 * cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000
2008-12-09 17:54:08.07 spid204 * schannel 000007FF7DD50000 000007FF7DD90FFF 00041000
2008-12-09 17:54:08.07 spid204 * COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000
2008-12-09 17:54:08.07 spid204 * XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000
2008-12-09 17:54:08.07 spid204 * MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000
2008-12-09 17:54:08.07 spid204 * msvcp60 000000000D860000 000000000D949FFF 000ea000
2008-12-09 17:54:08.07 spid204 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000
2008-12-09 17:54:08.07 spid204 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2008-12-09 17:54:08.07 spid204 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000
2008-12-09 17:54:08.07 spid204 * DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000
2008-12-09 17:54:08.07 spid204 * winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000
2008-12-09 17:54:08.07 spid204 * WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000
2008-12-09 17:54:08.07 spid204 * rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000
2008-12-09 17:54:08.07 spid204 * hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000
2008-12-09 17:54:08.07 spid204 * wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000
2008-12-09 17:54:08.07 spid204 * security 000007FF77530000 000007FF77534FFF 00005000
2008-12-09 17:54:08.07 spid204 * msfte 0000000049980000 0000000049D2DFFF 003ae000
2008-12-09 17:54:08.07 spid204 * dbghelp 0000000010100000 000000001025CFFF 0015d000
2008-12-09 17:54:08.07 spid204 * WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000
2008-12-09 17:54:08.07 spid204 * imagehlp 000007FF7E470000 000007FF7E482FFF 00013000
2008-12-09 17:54:08.07 spid204 * dssenh 0000000068100000 000000006813EFFF 0003f000
2008-12-09 17:54:08.07 spid204 * NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000
2008-12-09 17:54:08.07 spid204 * SAMLIB 000007FF77150000 000007FF77165FFF 00016000
2008-12-09 17:54:08.07 spid204 * ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000
2008-12-09 17:54:08.07 spid204 * xpsp2res 0000000010880000 0000000010B46FFF 002c7000
2008-12-09 17:54:08.07 spid204 * CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000
2008-12-09 17:54:08.07 spid204 * sqlncli 00000000337A0000 0000000033A5FFFF 002c0000
2008-12-09 17:54:08.07 spid204 * COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000
2008-12-09 17:54:08.07 spid204 * comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000
2008-12-09 17:54:08.07 spid204 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000
2008-12-09 17:54:08.07 spid204 * msftepxy 0000000003850000 0000000003870FFF 00021000
2008-12-09 17:54:08.07 spid204 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
2008-12-09 17:54:08.07 spid204 * xpstar90 0000000053C30000 0000000053CB5FFF 00086000
2008-12-09 17:54:08.07 spid204 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
2008-12-09 17:54:08.07 spid204 * ODBC32 000007FF63F00000 000007FF63F66FFF 00067000
2008-12-09 17:54:08.07 spid204 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
2008-12-09 17:54:08.07 spid204 * ATL80 000000007C630000 000000007C64DFFF 0001e000
2008-12-09 17:54:08.07 spid204 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000
2008-12-09 17:54:08.07 spid204 * xpstar90 0000000014C10000 0000000014C35FFF 00026000
2008-12-09 17:54:08.07 spid204 * xplog70 0000000034730000 000000003473FFFF 00010000
2008-12-09 17:54:08.07 spid204 * xplog70 0000000014C60000 0000000014C62FFF 00003000
2008-12-09 17:54:08.07 spid204 * msxmlsql 0000000078800000 0000000078967FFF 00168000
2008-12-09 17:54:08.07 spid204 * msxml3 000007FF56D40000 000007FF56F53FFF 00214000
2008-12-09 17:54:08.07 spid204 *
2008-12-09 17:54:08.07 spid204 * P1Home: 0000000000000001:
2008-12-09 17:54:08.07 spid204 * P2Home: 00000000136DA370: 0043004200390037 00000000000A0030 0000000000000000 0000000000000000 0000000000000030 0000000000000000
2008-12-09 17:54:08.07 spid204 * P3Home: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * P4Home: 0000000077EF40C2: 00000320249C8B48 0000031824B48B48 0000031024BC8B48 0000030824A48B4C 0000030024AC8B4C 000002F824B48B4C
2008-12-09 17:54:08.07 spid204 * P5Home: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * P6Home: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * ContextFlags: 000000000010000F:
2008-12-09 17:54:08.07 spid204 * MxCsr: 0000000000001FA0:
2008-12-09 17:54:08.07 spid204 * SegCs: 0000000000000033:
2008-12-09 17:54:08.07 spid204 * SegDs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * SegEs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * SegFs: 0000000000000053:
2008-12-09 17:54:08.07 spid204 * SegGs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * SegSs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * EFlags: 0000000000000206:
2008-12-09 17:54:08.07 spid204 * Rax: 00000000136DA3F8: 0000000077D67D8D 0000000012725E80 0000000000000000 00000000136DA6B0 0000000166579BB0 00000000000042AC
2008-12-09 17:54:08.07 spid204 * Rcx: 00000000136D9F20: 0000000000000001 00000000136DA370 0000000000000000 0000000077EF40C2 0000000000000000 0000000000000000
2008-12-09 17:54:08.07 spid204 * Rdx: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * Rbx: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * Rsp: 00000000136DA400: 0000000012725E80 0000000000000000 00000000136DA6B0 0000000166579BB0 00000000000042AC 0000000000000000
2008-12-09 17:54:08.07 spid204 * Rbp: 00000000FFFFFFFF: 0082000000030100 0000000000000001 0100000000000000 D600280000006900 000001000335E51F 00182C000014A900
2008-12-09 17:54:08.07 spid204 * Rsi: 00000000136DA6B0: 0000000012725E80 00000000010A9080 00000000FFFFFFFE 000000000124E6BB 000000023E2FB160 00000000136DA870
2008-12-09 17:54:08.07 spid204 * Rdi: 0000000166579BB0: 0000000166578B00 0000000000000000 0000000166579BB0 0000000000000000 0000000000000004 0000000166579BD8
2008-12-09 17:54:08.07 spid204 * R8: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * R9: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * R10: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * R11: 00000000136DABF0: 0000000000000001 00000000136DA370 0000000000000000 0000000077EF40C2 0000000000000000 0000000000000000
2008-12-09 17:54:08.07 spid204 * R12: 00000000FFFFFFFF: 0082000000030100 0000000000000001 0100000000000000 D600280000006900 000001000335E51F 00182C000014A900
2008-12-09 17:54:08.07 spid204 * R13: 0000000166579BC0: 0000000166579BB0 0000000000000000 0000000000000004 0000000166579BD8 0000000166579BD8 0000000166579BE8
2008-12-09 17:54:08.07 spid204 * R14: 00000000136DBBC0: 0072005F00780065 0065007300690061 00450020003A0032 0070006500630078 006E006F00690074 0069006100720020
2008-12-09 17:54:08.07 spid204 * R15: 0000000000000001:
2008-12-09 17:54:08.07 spid204 * Rip: 0000000077D67D8D: C3000000C8C48148 15FF984B8D49D233 8699E990FFFD96DF 9090909090900000 834853C08B909090 0C0CEA158B4830EC
2008-12-09 17:54:08.07 spid204 * *******************************************************************************
2008-12-09 17:54:08.07 spid204 * -------------------------------------------------------------------------------
2008-12-09 17:54:08.07 spid204 * Short Stack Dump
2008-12-09 17:54:08.13 spid204 0000000077D67D8D Module(kernel32+0000000000027D8D)
2008-12-09 17:54:08.13 spid204 0000000001D345DE Module(sqlservr+0000000000D345DE)
2008-12-09 17:54:08.13 spid204 0000000001D3F3A9 Module(sqlservr+0000000000D3F3A9)
2008-12-09 17:54:08.13 spid204 0000000001D3FB1B Module(sqlservr+0000000000D3FB1B)
2008-12-09 17:54:08.13 spid204 000000000186689B Module(sqlservr+000000000086689B)
2008-12-09 17:54:08.13 spid204 00000000010E07E2 Module(sqlservr+00000000000E07E2)
2008-12-09 17:54:08.13 spid204 000000000206380C Module(sqlservr+000000000106380C)
2008-12-09 17:54:08.15 spid204 000000000177E28C Module(sqlservr+000000000077E28C)
2008-12-09 17:54:08.15 spid204 0000000001473E66 Module(sqlservr+0000000000473E66)
2008-12-09 17:54:08.16 spid204 00000000020E6C99 Module(sqlservr+00000000010E6C99)
2008-12-09 17:54:08.16 spid204 0000000002665A45 Module(sqlservr+0000000001665A45)
2008-12-09 17:54:08.16 spid204 0000000002666290 Module(sqlservr+0000000001666290)
2008-12-09 17:54:08.16 spid204 00000000027816EF Module(sqlservr+00000000017816EF)
2008-12-09 17:54:08.16 spid204 00000000010A5BEA Module(sqlservr+00000000000A5BEA)
2008-12-09 17:54:08.16 spid204 0000000001070FBE Module(sqlservr+0000000000070FBE)
2008-12-09 17:54:08.16 spid204 0000000001028709 Module(sqlservr+0000000000028709)
2008-12-09 17:54:08.16 spid204 0000000001023EA1 Module(sqlservr+0000000000023EA1)
2008-12-09 17:54:08.16 spid204 0000000001079636 Module(sqlservr+0000000000079636)
2008-12-09 17:54:08.16 spid204 000000000245961F Module(sqlservr+000000000145961F)
2008-12-09 17:54:08.16 spid204 0000000001020C4E Module(sqlservr+0000000000020C4E)
2008-12-09 17:54:08.16 spid204 000000000102F94A Module(sqlservr+000000000002F94A)
2008-12-09 17:54:08.16 spid204 000000000102F375 Module(sqlservr+000000000002F375)
2008-12-09 17:54:08.16 spid204 0000000001030872 Module(sqlservr+0000000000030872)
2008-12-09 17:54:08.16 spid204 0000000001270CE7 Module(sqlservr+0000000000270CE7)
2008-12-09 17:54:08.16 spid204 000000000100685E Module(sqlservr+000000000000685E)
2008-12-09 17:54:08.18 spid204 0000000001006F11 Module(sqlservr+0000000000006F11)
2008-12-09 17:54:08.18 spid204 0000000001006A01 Module(sqlservr+0000000000006A01)
2008-12-09 17:54:08.18 spid204 00000000010EF7A7 Module(sqlservr+00000000000EF7A7)
2008-12-09 17:54:08.18 spid204 00000000010F051A Module(sqlservr+00000000000F051A)
2008-12-09 17:54:08.18 spid204 00000000010F03F1 Module(sqlservr+00000000000F03F1)
2008-12-09 17:54:08.18 spid204 00000000010F0289 Module(sqlservr+00000000000F0289)
2008-12-09 17:54:08.18 spid204 00000000781337D7 Module(MSVCR80+00000000000037D7)
2008-12-09 17:54:08.18 spid204 0000000078133894 Module(MSVCR80+0000000000003894)
2008-12-09 17:54:08.18 spid204 0000000077D6B6DA Module(kernel32+000000000002B6DA)
2008-12-09 17:54:08.22 spid204 * -------------------------------------------------------------------------------
2008-12-09 17:54:08.22 spid204 Stack Signature for the dump is 0x00000001A1B0D2B5
2008-12-09 17:54:14.71 spid204 External dump process return code 0x20000001.
External dump process returned no errors.
2008-12-09 17:54:14.72 spid204 Error: 5243, Severity: 22, State: 1.
2008-12-09 17:54:14.72 spid204 An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8.
and we contacted Microsoft support and they are told us to regenerate the issue..but we are unable to generate the same issue again...later 5 days they closed the ticket....
after immediately 3 weeks got one more problem that i posted today..and we are decided to take experts opinion before directly contacting to Microsoft support as it is not mentioned as critical error.
Thanks for your support and help
Mani
December 31, 2008 at 1:25 am
is this any issue related to not applying any cumulative udates.Because We have only SP2 installed
December 31, 2008 at 5:27 am
1) Check your event logs (system and application) from errors
2) Check your hardware (reseat the memory and look for any hardware issues)
3) Run another checkdb on every database
4) Call Microsoft if you still get the error after doing all those things. It probably means that you have corruption issues.
December 31, 2008 at 7:59 am
Mani (12/31/2008)
after immediately 3 weeks got one more problem that i posted today..and we are decided to take experts opinion before directly contacting to Microsoft support as it is not mentioned as critical error.
We can't help you with stack dumps and internal errors. We don't have access to the source code (which CSS does) and we don't have access to the tools that they have for reading and interpreting stack dumps.
Call CSS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2009 at 4:21 pm
I've actually came accross a situation where I can create this error at will. 32 bit SQL 2005 (tested on build numbers 3042 and 3239) running on Windows 2003, the problem does not occur on SQL 2008 64 bit, SP1.
It generates Msg 3624 and 17066.
Run code at your own risk, it has not crashed the servers I have tested it on, but does give a stack dump. See inline comments for what makes it work vs. fail.
-- create table first
--create table AndersTest (g int)
--drop table AndersTest
declare @a table (a int, b int, c int)
declare @b-2 table (d int, e int, f int)
declare @C table (g int)
insert into @a values(1,2,3)
insert into @b-2 values(4,2,8)
update @b-2
set e = a.a
output inserted.e
--into @C -- crashes with 17066 and 3624
into AndersTest -- uncomment out above line, and comment this line, works
from @a a
inner join @b-2 b
on a.b= b.e
select * from @b-2 -- updated table for using a table variable
select * from AndersTest -- updated table for using a real table
July 8, 2009 at 9:32 am
If the table variable is changed to using a temp table, the error does not occur.
September 3, 2009 at 2:10 pm
I had similar errors just yesterday. This article has information that I use for troubleshooting: http://support.microsoft.com/kb/918483
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply