Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tanu
Yak Posting Veteran
57 Posts |
Posted - 2008-03-28 : 11:35:55
|
Hi,I am getting these messages in error log. What do I needd to do?2008-03-27 09:34:54.76 spid74 Using 'dbghelp.dll' version '4.0.5'2008-03-27 09:34:54.76 spid74 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0014.txt2008-03-27 09:34:54.76 spid74 SqlDumpExceptionHandler: Process 74 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.2008-03-27 09:34:54.76 spid74 * *******************************************************************************2008-03-27 09:34:54.76 spid74 *2008-03-27 09:34:54.76 spid74 * BEGIN STACK DUMP:2008-03-27 09:34:54.76 spid74 * 03/27/08 09:34:54 spid 742008-03-27 09:34:54.76 spid74 *2008-03-27 09:34:54.76 spid74 *2008-03-27 09:34:54.76 spid74 * Exception Address = 7C80EEF0 Module(ntdll+0000EEF0)2008-03-27 09:34:54.76 spid74 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION2008-03-27 09:34:54.76 spid74 * Access Violation occurred reading address 000000012008-03-27 09:34:54.76 spid74 * Input Buffer 87 bytes -2008-03-27 09:34:54.76 spid74 * C a m s _ V a l 15 00 43 00 61 00 6d 00 73 00 5f 00 56 00 61 00 6c 002008-03-27 09:34:54.76 spid74 * i d a t e P a s s 69 00 64 00 61 00 74 00 65 00 50 00 61 00 73 00 73 002008-03-27 09:34:54.76 spid74 * w o r d § 77 00 6f 00 72 00 64 00 00 00 00 00 a7 0f 00 09 04 002008-03-27 09:34:54.76 spid74 * 2 JFINCH § 01 32 06 00 4a 46 49 4e 43 48 00 00 a7 20 00 09 04 002008-03-27 09:34:54.76 spid74 * 2 JFINCH & 01 32 06 00 4a 46 49 4e 43 48 00 01 26 04 002008-03-27 09:34:54.76 spid74 * 2008-03-27 09:34:54.76 spid74 *2008-03-27 09:34:54.76 spid74 * MODULE BASE END SIZE2008-03-27 09:34:54.76 spid74 * sqlservr 01000000 02C09FFF 01c0a0002008-03-27 09:34:54.76 spid74 * ntdll 7C800000 7C8BFFFF 000c00002008-03-27 09:34:54.76 spid74 * kernel32 77E40000 77F41FFF 001020002008-03-27 09:34:54.76 spid74 * MSVCR80 78130000 781CAFFF 0009b0002008-03-27 09:34:54.76 spid74 * msvcrt 77BA0000 77BF9FFF 0005a0002008-03-27 09:34:54.76 spid74 * MSVCP80 7C420000 7C4A6FFF 000870002008-03-27 09:34:54.76 spid74 * ADVAPI32 77F50000 77FEAFFF 0009b0002008-03-27 09:34:54.76 spid74 * RPCRT4 77C50000 77CEEFFF 0009f0002008-03-27 09:34:54.76 spid74 * Secur32 76F50000 76F62FFF 000130002008-03-27 09:34:54.76 spid74 * USER32 77380000 77410FFF 000910002008-03-27 09:34:54.76 spid74 * GDI32 77C00000 77C47FFF 000480002008-03-27 09:34:54.76 spid74 * CRYPT32 761B0000 76242FFF 000930002008-03-27 09:34:54.76 spid74 * MSASN1 76190000 761A1FFF 000120002008-03-27 09:34:54.76 spid74 * MSWSOCK 71B20000 71B60FFF 000410002008-03-27 09:34:54.76 spid74 * WS2_32 71C00000 71C16FFF 000170002008-03-27 09:34:54.76 spid74 * WS2HELP 71BF0000 71BF7FFF 000080002008-03-27 09:34:54.76 spid74 * USERENV 76920000 769E1FFF 000c20002008-03-27 09:34:54.76 spid74 * opends60 333E0000 333E6FFF 000070002008-03-27 09:34:54.76 spid74 * NETAPI32 71C40000 71C96FFF 000570002008-03-27 09:34:54.76 spid74 * SHELL32 7C8D0000 7D0CEFFF 007ff0002008-03-27 09:34:54.76 spid74 * SHLWAPI 77DA0000 77DF1FFF 000520002008-03-27 09:34:54.76 spid74 * comctl32 77420000 77522FFF 001030002008-03-27 09:34:54.76 spid74 * psapi 76B70000 76B7AFFF 0000b0002008-03-27 09:34:54.76 spid74 * instapi 48060000 48069FFF 0000a0002008-03-27 09:34:54.76 spid74 * sqlevn70 4F610000 4F7B8FFF 001a90002008-03-27 09:34:54.76 spid74 * SQLOS 344D0000 344D4FFF 000050002008-03-27 09:34:54.76 spid74 * rsaenh 68000000 68034FFF 000350002008-03-27 09:34:54.76 spid74 * AUTHZ 76C40000 76C53FFF 000140002008-03-27 09:34:54.76 spid74 * MSCOREE 79000000 79045FFF 000460002008-03-27 09:34:54.76 spid74 * ole32 77670000 777A8FFF 001390002008-03-27 09:34:54.76 spid74 * msv1_0 76C90000 76CB6FFF 000270002008-03-27 09:34:54.76 spid74 * iphlpapi 76CF0000 76D09FFF 0001a0002008-03-27 09:34:54.76 spid74 * kerberos 629A0000 629F7FFF 000580002008-03-27 09:34:54.76 spid74 * cryptdll 766E0000 766EBFFF 0000c0002008-03-27 09:34:54.76 spid74 * schannel 76750000 76776FFF 000270002008-03-27 09:34:54.76 spid74 * COMRES 77010000 770D5FFF 000c60002008-03-27 09:34:54.76 spid74 * XOLEHLP 62A60000 62A65FFF 000060002008-03-27 09:34:54.76 spid74 * MSDTCPRX 62A70000 62AE8FFF 000790002008-03-27 09:34:54.76 spid74 * OLEAUT32 77D00000 77D8AFFF 0008b0002008-03-27 09:34:54.76 spid74 * msvcp60 62AF0000 62B54FFF 000650002008-03-27 09:34:54.76 spid74 * MTXCLU 62B60000 62B78FFF 000190002008-03-27 09:34:54.76 spid74 * VERSION 77B90000 77B97FFF 000080002008-03-27 09:34:54.76 spid74 * WSOCK32 71BB0000 71BB8FFF 000090002008-03-27 09:34:54.76 spid74 * CLUSAPI 62B80000 62B91FFF 000120002008-03-27 09:34:54.76 spid74 * RESUTILS 62BA0000 62BB2FFF 000130002008-03-27 09:34:54.76 spid74 * DNSAPI 76ED0000 76EF9FFF 0002a0002008-03-27 09:34:54.76 spid74 * winrnr 76F70000 76F76FFF 000070002008-03-27 09:34:54.76 spid74 * WLDAP32 76F10000 76F3DFFF 0002e0002008-03-27 09:34:54.76 spid74 * rasadhlp 76F80000 76F84FFF 000050002008-03-27 09:34:54.76 spid74 * security 62FF0000 62FF3FFF 000040002008-03-27 09:34:54.76 spid74 * msfte 637D0000 63A28FFF 002590002008-03-27 09:34:54.76 spid74 * dbghelp 63A40000 63B54FFF 001150002008-03-27 09:34:54.76 spid74 * WINTRUST 76BB0000 76BDAFFF 0002b0002008-03-27 09:34:54.76 spid74 * imagehlp 76C10000 76C37FFF 000280002008-03-27 09:34:54.76 spid74 * dssenh 68100000 68126FFF 000270002008-03-27 09:34:54.76 spid74 * hnetcfg 63DA0000 63DF9FFF 0005a0002008-03-27 09:34:54.76 spid74 * wshtcpip 71AE0000 71AE7FFF 000080002008-03-27 09:34:54.76 spid74 * NTMARTA 77E00000 77E20FFF 000210002008-03-27 09:34:54.76 spid74 * SAMLIB 7E020000 7E02EFFF 0000f0002008-03-27 09:34:54.76 spid74 * ntdsapi 766F0000 76703FFF 000140002008-03-27 09:34:54.76 spid74 * xpsp2res 63F40000 64204FFF 002c50002008-03-27 09:34:54.76 spid74 * CLBCatQ 777B0000 77832FFF 000830002008-03-27 09:34:54.76 spid74 * sqlncli 64210000 64433FFF 002240002008-03-27 09:34:54.76 spid74 * COMCTL32 77530000 775C6FFF 000970002008-03-27 09:34:54.76 spid74 * comdlg32 762B0000 762F8FFF 000490002008-03-27 09:34:54.76 spid74 * SQLNCLIR 007C0000 007F2FFF 000330002008-03-27 09:34:54.76 spid74 * msftepxy 64670000 64684FFF 000150002008-03-27 09:34:54.76 spid74 * xp_ctnhashproc 62910000 6292EFFF 0001f0002008-03-27 09:34:54.76 spid74 * xplog70 63360000 6336BFFF 0000c0002008-03-27 09:34:54.76 spid74 * xplog70 63380000 63382FFF 000030002008-03-27 09:34:54.76 spid74 * sqlvdi 645D0000 645F1FFF 000220002008-03-27 09:34:54.76 spid74 * xpstar90 630B0000 630F8FFF 000490002008-03-27 09:34:54.76 spid74 * SQLSCM90 633C0000 633C8FFF 000090002008-03-27 09:34:54.76 spid74 * ODBC32 64450000 6448CFFF 0003d0002008-03-27 09:34:54.76 spid74 * BatchParser90 64490000 644AEFFF 0001f0002008-03-27 09:34:54.76 spid74 * ATL80 7C630000 7C64AFFF 0001b0002008-03-27 09:34:54.76 spid74 * odbcint 64DC0000 64DD6FFF 000170002008-03-27 09:34:54.76 spid74 * xpstar90 65330000 65355FFF 000260002008-03-27 09:34:54.76 spid74 * xpsqlbot 64DE0000 64DE5FFF 000060002008-03-27 09:34:54.76 spid74 * msxmlsql 78800000 788D4FFF 000d50002008-03-27 09:34:54.76 spid74 * msxml2 66030000 660DEFFF 000af0002008-03-27 09:34:54.76 spid74 * msxml3 67040000 67156FFF 001170002008-03-27 09:34:54.76 spid74 * dbghelp 68930000 68A44FFF 001150002008-03-27 09:34:54.76 spid74 *2008-03-27 09:34:54.76 spid74 * Edi: 62930000: 000000C8 00000187 EEFFEEFF 00001002 00000000 0000FE00 2008-03-27 09:34:54.76 spid74 * Esi: 1C3C2EE8: 010A50E8 00000001 1C3C2490 0000D333 1C3C2F10 1C3C2F08 2008-03-27 09:34:54.76 spid74 * Eax: 010A50E8: 010B7A71 01659AC6 01659ACE 018484D0 018484D8 01659ADE 2008-03-27 09:34:54.76 spid74 * Ebx: 00000000: 2008-03-27 09:34:54.76 spid74 * Ecx: 00000001: 2008-03-27 09:34:54.76 spid74 * Edx: 62930608: 00127668 FFFFFFFE 00000001 00000430 00000000 00000FA0 2008-03-27 09:34:54.76 spid74 * Eip: 7C80EEF0: 503B118B 56850F04 3B00031E 4E850FD6 8900031E 04488901 2008-03-27 09:34:54.76 spid74 * Ebp: 656DCD84: 00000020 6291ED76 62930000 00000000 1C3C2F08 3910C3B0 2008-03-27 09:34:54.76 spid74 * SegCs: 0000001B: 2008-03-27 09:34:54.76 spid74 * EFlags: 00010207: 47004900 5F005700 4F004C00 3D004300 3A004300 50005C00 2008-03-27 09:34:54.76 spid74 * Esp: 656DCCB4: 1C3C2F08 1C3C2F08 654E05E0 0100469B 656DCD74 78132C78 2008-03-27 09:34:54.76 spid74 * SegSs: 00000023: 2008-03-27 09:34:54.76 spid74 * *******************************************************************************2008-03-27 09:34:54.76 spid74 * -------------------------------------------------------------------------------2008-03-27 09:34:54.76 spid74 * Short Stack Dump2008-03-27 09:34:54.77 spid74 7C80EEF0 Module(ntdll+0000EEF0)2008-03-27 09:34:54.77 spid74 6291ED76 Module(xp_ctnhashproc+0000ED76)2008-03-27 09:34:54.77 spid74 62911184 Module(xp_ctnhashproc+00001184)2008-03-27 09:34:54.77 spid74 01660FEC Module(sqlservr+00660FEC)2008-03-27 09:34:54.77 spid74 01662FCD Module(sqlservr+00662FCD)2008-03-27 09:34:54.77 spid74 01662984 Module(sqlservr+00662984)2008-03-27 09:34:54.77 spid74 01661920 Module(sqlservr+00661920)2008-03-27 09:34:54.77 spid74 01661E2E Module(sqlservr+00661E2E)2008-03-27 09:34:54.77 spid74 01C1BF0C Module(sqlservr+00C1BF0C)2008-03-27 09:34:54.77 spid74 014B3FE1 Module(sqlservr+004B3FE1)2008-03-27 09:34:54.77 spid74 012389B6 Module(sqlservr+002389B6)2008-03-27 09:34:54.77 spid74 0123882D Module(sqlservr+0023882D)2008-03-27 09:34:54.77 spid74 012386C2 Module(sqlservr+002386C2)2008-03-27 09:34:54.77 spid74 010227F3 Module(sqlservr+000227F3)2008-03-27 09:34:54.77 spid74 010293B5 Module(sqlservr+000293B5)2008-03-27 09:34:54.77 spid74 010286DC Module(sqlservr+000286DC)2008-03-27 09:34:54.77 spid74 01032A36 Module(sqlservr+00032A36)2008-03-27 09:34:54.77 spid74 0102F1F4 Module(sqlservr+0002F1F4)2008-03-27 09:34:54.77 spid74 010077A6 Module(sqlservr+000077A6)2008-03-27 09:34:54.77 spid74 010078CC Module(sqlservr+000078CC)2008-03-27 09:34:54.77 spid74 010075DC Module(sqlservr+000075DC)2008-03-27 09:34:54.77 spid74 010B94A5 Module(sqlservr+000B94A5)2008-03-27 09:34:54.77 spid74 010B939C Module(sqlservr+000B939C)2008-03-27 09:34:54.77 spid74 010B9064 Module(sqlservr+000B9064)2008-03-27 09:34:54.79 spid74 010B9201 Module(sqlservr+000B9201)2008-03-27 09:34:54.79 spid74 781329BB Module(MSVCR80+000029BB)2008-03-27 09:34:54.79 spid74 78132A47 Module(MSVCR80+00002A47)2008-03-27 09:34:54.79 spid74 Stack Signature for the dump is 0xD56526482008-03-27 09:34:56.31 spid74 External dump process return code 0x20002001.The error information has been submitted to Watson error reporting.2008-03-27 09:34:56.31 spid74 Error: 18002, Severity: 20, State: 1.2008-03-27 09:34:56.31 spid74 Exception happened when running extended stored procedure 'xp_ctnhash' in the library 'xp_ctnhashproc.dll'. SQL Server is terminating process 74. Exception type: Win32 exception; Exception code: 0xc0000005. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-28 : 11:58:47
|
SQL Server crashed. What does SELECT @@VERSION show? If it shows 3200, then you'll need to call MS to see if there is a fix for this. Otherwise, you need to get to the latest service pack and build.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
tanu
Yak Posting Veteran
57 Posts |
Posted - 2008-03-28 : 12:09:20
|
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) |
|
|
tanu
Yak Posting Veteran
57 Posts |
Posted - 2008-03-28 : 12:47:17
|
Tara, our sql server is running fine andwe are not getting errors any more.What should be my next step?Rita |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-28 : 15:19:19
|
You should open a case with Microsoft to determine if there is a bug fix for this. There is nothing that we can help with except to say to get on the latest build.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 00:03:39
|
What's xp_ctnhash? Doesn't sound from sql server. Check with vendor or developer of library 'xp_ctnhashproc.dll'. |
|
|
|
|
|