Home Forums SQL Server 2005 Administering Exception happened when running extended stored procedure 'xp_enumerrorlogs' in the library 'xpstar90.dll'. SQL Server is terminating process 77. Exception type: Win32 exception; Exception code: 0xc0000005 RE: Exception happened when running extended stored procedure 'xp_enumerrorlogs' in the library 'xpstar90.dll'. SQL Server is terminating process 77. Exception type: Win32 exception; Exception code: 0xc0000005

  • May 25, 2011 at 9:28 am

    #1329762

    I am basically getting same issue on two SQL boxes running SQL 2005 Standard edition SP3 64-bit (9.0.4035). This exception seems random and I was not able to repro it. SQL Instance restart fixes this problem, but now it occured at least two time withing 5 month.

    I found only one MS article KB2463332 where MS claims that SQL 2005 Issue ID: 555409: An access violation error may occur during the execution of Extended Stored Procedures under high stress conditions was fixed. Unfortunately, I could not find more distinct definition of this issue neither repro it.

    Has anyone has applied SQL 2005 SP4 and confirmed that it resolves this problem? Or anyone has a way to reproduce it?

    Thanks

    Alex

    2011-05-13 03:50:07.75 spid88 Exception happened when running extended stored procedure 'xp_delete_file' in the library 'xpstar90.dll'. SQL Server is terminating process 88. Exception type: Win32 exception; Exception code: 0xc0000005.

    2011-05-13 03:50:07.75 spid79 Using 'dbghelp.dll' version '4.0.5'

    2011-05-13 03:50:07.75 spid79 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump0004.txt

    2011-05-13 03:50:07.75 spid79 SqlDumpExceptionHandler: Process 79 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    2011-05-13 03:50:07.75 spid79 * *******************************************************************************

    2011-05-13 03:50:07.75 spid79 *

    2011-05-13 03:50:07.75 spid79 * BEGIN STACK DUMP:

    2011-05-13 03:50:07.75 spid79 * 05/13/11 03:50:07 spid 79

    2011-05-13 03:50:07.75 spid79 *

    2011-05-13 03:50:07.75 spid79 *

    2011-05-13 03:50:07.75 spid79 * Exception Address = 000007FF7FC51D71 Module(msvcrt+0000000000051D71)

    2011-05-13 03:50:07.75 spid79 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

    2011-05-13 03:50:07.75 spid79 * Access Violation occurred reading address 0000000000000000

    2011-05-13 03:50:07.75 spid79 * Input Buffer 510 bytes -

    2011-05-13 03:50:07.75 spid79 BEGIN TRY EXECUTE master.dbo.xp_delete_fil

    2011-05-13 03:50:07.75 spid79 * e 0, @backupFolder, N'TRN',@deleteFromDate,0 END TRY 2011-05-13 03:50:07.75 spid79 *

    2011-05-13 03:50:07.75 spid79 *

    2011-05-13 03:50:07.75 spid79 * MODULE BASE END SIZE

    2011-05-13 03:50:07.75 spid79 * sqlservr 0000000001000000 0000000003651FFF 02652000

    2011-05-13 03:50:07.76 spid79 * ntdll 0000000077EC0000 0000000077FFAFFF 0013b000

    2011-05-13 03:50:07.76 spid79 * kernel32 0000000077D40000 0000000077EB2FFF 00173000

    2011-05-13 03:50:07.76 spid79 * MSVCR80 0000000078130000 00000000781F8FFF 000c9000

    2011-05-13 03:50:07.76 spid79 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000

    2011-05-13 03:50:07.76 spid79 * MSVCP80 000000007C420000 000000007C528FFF 00109000

    2011-05-13 03:50:07.76 spid79 * ADVAPI32 000007FF7FEE0000 000007FF7FFE5FFF 00106000

    2011-05-13 03:50:07.76 spid79 * RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000

    2011-05-13 03:50:07.76 spid79 * Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000

    2011-05-13 03:50:07.76 spid79 * sqlos 00000000344D0000 00000000344D6FFF 00007000

    2011-05-13 03:50:07.76 spid79 * USERENV 000007FF7C680000 000007FF7C789FFF 0010a000

    2011-05-13 03:50:07.76 spid79 * USER32 0000000077C20000 0000000077D2BFFF 0010c000

    2011-05-13 03:50:07.76 spid79 * GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000

    2011-05-13 03:50:07.76 spid79 * WINMM 000007FF7E240000 000007FF7E28FFFF 00050000

    2011-05-13 03:50:07.76 spid79 * opends60 00000000333E0000 00000000333E7FFF 00008000

    2011-05-13 03:50:07.76 spid79 * NETAPI32 000007FF77370000 000007FF77408FFF 00099000

    2011-05-13 03:50:07.76 spid79 * psapi 000007FF7E380000 000007FF7E38FFFF 00010000

    2011-05-13 03:50:07.76 spid79 * instapi 0000000048060000 000000004806CFFF 0000d000

    2011-05-13 03:50:07.76 spid79 * sqlevn70 000000004F610000 000000004F7B8FFF 001a9000

    2011-05-13 03:50:07.76 spid79 * rsaenh 0000000068000000 000000006804BFFF 0004c000

    2011-05-13 03:50:07.76 spid79 * AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000

    2011-05-13 03:50:07.76 spid79 * MSCOREE 000006427EE50000 000006427EEB5FFF 00066000

    2011-05-13 03:50:07.76 spid79 * ole32 000007FF57140000 000007FF573C4FFF 00285000

    2011-05-13 03:50:07.76 spid79 * msv1_0 000007FF7E500000 000007FF7E544FFF 00045000

    2011-05-13 03:50:07.76 spid79 * cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000

    2011-05-13 03:50:07.76 spid79 * WS2_32 000007FF77310000 000007FF7733FFFF 00030000

    2011-05-13 03:50:07.76 spid79 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000

    2011-05-13 03:50:07.76 spid79 * iphlpapi 000007FF57040000 000007FF57070FFF 00031000

    2011-05-13 03:50:07.76 spid79 * kerberos 000007FF77410000 000007FF774C4FFF 000b5000

    2011-05-13 03:50:07.76 spid79 * MSASN1 000007FF7D340000 000007FF7D36BFFF 0002c000

    2011-05-13 03:50:07.76 spid79 * schannel 000007FF7DD50000 000007FF7DD91FFF 00042000

    2011-05-13 03:50:07.76 spid79 * CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000

    2011-05-13 03:50:07.76 spid79 * COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000

    2011-05-13 03:50:07.76 spid79 * XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000

    2011-05-13 03:50:07.76 spid79 * MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000

    2011-05-13 03:50:07.76 spid79 * OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000

    2011-05-13 03:50:07.76 spid79 * msvcp60 0000000016860000 0000000016949FFF 000ea000

    2011-05-13 03:50:07.76 spid79 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000

    2011-05-13 03:50:07.76 spid79 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000

    2011-05-13 03:50:07.76 spid79 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000

    2011-05-13 03:50:07.76 spid79 * CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000

    2011-05-13 03:50:07.76 spid79 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000

    2011-05-13 03:50:07.76 spid79 * mswsock 000007FF771B0000 000007FF7722CFFF 0007d000

    2011-05-13 03:50:07.76 spid79 * DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000

    2011-05-13 03:50:07.76 spid79 * winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000

    2011-05-13 03:50:07.76 spid79 * WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000

    2011-05-13 03:50:07.76 spid79 * rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000

    2011-05-13 03:50:07.76 spid79 * security 000007FF77530000 000007FF77534FFF 00005000

    2011-05-13 03:50:07.76 spid79 * dssenh 0000000068100000 000000006813EFFF 0003f000

    2011-05-13 03:50:07.76 spid79 * hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000

    2011-05-13 03:50:07.76 spid79 * wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000

    2011-05-13 03:50:07.76 spid79 * NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000

    2011-05-13 03:50:07.76 spid79 * SAMLIB 000007FF77150000 000007FF77165FFF 00016000

    2011-05-13 03:50:07.76 spid79 * ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000

    2011-05-13 03:50:07.76 spid79 * xpsp2res 000000001CEE0000 000000001D1A6FFF 002c7000

    2011-05-13 03:50:07.76 spid79 * CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000

    2011-05-13 03:50:07.76 spid79 * sqlncli 00000000337A0000 0000000033A63FFF 002c4000

    2011-05-13 03:50:07.76 spid79 * COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000

    2011-05-13 03:50:07.76 spid79 * comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000

    2011-05-13 03:50:07.76 spid79 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000

    2011-05-13 03:50:07.76 spid79 * SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000

    2011-05-13 03:50:07.76 spid79 * comctl32 000007FF7F000000 000007FF7F186FFF 00187000

    2011-05-13 03:50:07.76 spid79 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000

    2011-05-13 03:50:07.76 spid79 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000

    2011-05-13 03:50:07.76 spid79 * xpstar90 0000000053C30000 0000000053CB7FFF 00088000

    2011-05-13 03:50:07.76 spid79 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000

    2011-05-13 03:50:07.76 spid79 * ODBC32 000007FF63F00000 000007FF63F66FFF 00067000

    2011-05-13 03:50:07.76 spid79 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000

    2011-05-13 03:50:07.76 spid79 * ATL80 000000007C630000 000000007C64EFFF 0001f000

    2011-05-13 03:50:07.76 spid79 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000

    2011-05-13 03:50:07.76 spid79 * xpstar90 000000001E160000 000000001E185FFF 00026000

    2011-05-13 03:50:07.76 spid79 * xplog70 0000000034730000 000000003473FFFF 00010000

    2011-05-13 03:50:07.76 spid79 * xplog70 000000001E1A0000 000000001E1A2FFF 00003000

    2011-05-13 03:50:07.76 spid79 * msxmlsql 0000000078800000 0000000078967FFF 00168000

    2011-05-13 03:50:07.76 spid79 * msxml3 000007FF4A9A0000 000007FF4ABC4FFF 00225000

    2011-05-13 03:50:07.76 spid79 * mscorwks 000006427F330000 000006427FCE0FFF 009b1000

    2011-05-13 03:50:07.76 spid79 * mscorlib.ni 0000064278000000 0000064278ED8FFF 00ed9000

    2011-05-13 03:50:07.76 spid79 * mscorsec 00000642FFAF0000 00000642FFB08FFF 00019000

    2011-05-13 03:50:07.76 spid79 * WINTRUST 000007FF7E3E0000 000007FF7E42FFFF 00050000

    2011-05-13 03:50:07.76 spid79 * imagehlp 000007FF7E470000 000007FF7E482FFF 00013000

    2011-05-13 03:50:07.76 spid79 * cryptnet 000007FF79690000 000007FF796AEFFF 0001f000

    2011-05-13 03:50:07.76 spid79 * SensApi 000007FF77C90000 000007FF77C96FFF 00007000

    2011-05-13 03:50:07.76 spid79 * WINHTTP 000007FF763B0000 000007FF76434FFF 00085000

    2011-05-13 03:50:07.76 spid79 * RASAPI32 000007FF7E880000 000007FF7E8EAFFF 0006b000

    2011-05-13 03:50:07.76 spid79 * rasman 000007FF7E800000 000007FF7E81BFFF 0001c000

    2011-05-13 03:50:07.76 spid79 * TAPI32 000007FF7E820000 000007FF7E876FFF 00057000

    2011-05-13 03:50:07.76 spid79 * rtutils 000007FF7E610000 000007FF7E624FFF 00015000

    2011-05-13 03:50:07.76 spid79 * DHCPCSVC 000007FF7E5D0000 000007FF7E60AFFF 0003b000

    2011-05-13 03:50:07.76 spid79 * SqlAccess 0000000028510000 0000000028567FFF 00058000

    2011-05-13 03:50:07.76 spid79 * mscorjit 000006427EED0000 000006427F053FFF 00184000

    2011-05-13 03:50:07.76 spid79 * System.Data 0000000031140000 0000000031429FFF 002ea000

    2011-05-13 03:50:07.76 spid79 * System.ni 0000064274880000 0000064275283FFF 00a04000

    2011-05-13 03:50:07.76 spid79 * System.Transactions 000000002A2D0000 000000002A318FFF 00049000

    2011-05-13 03:50:07.76 spid79 * System.Security.ni 000006424F240000 000006424F324FFF 000e5000

    2011-05-13 03:50:07.76 spid79 * System 000000007A440000 000000007A743FFF 00304000

    2011-05-13 03:50:07.76 spid79 * System.Security 0000000067920000 0000000067961FFF 00042000

    2011-05-13 03:50:07.76 spid79 * System.Xml 00000000637A0000 0000000063997FFF 001f8000

    2011-05-13 03:50:07.76 spid79 * peverify 00000642FFC10000 00000642FFC44FFF 00035000

    2011-05-13 03:50:07.76 spid79 * xprepl 000000004D5A0000 000000004D5B6FFF 00017000

    2011-05-13 03:50:07.76 spid79 * dbghelp 0000000031B40000 0000000031C9CFFF 0015d000

    2011-05-13 03:50:07.76 spid79 *

    2011-05-13 03:50:07.76 spid79 * P1Home: FFFFFA8001B66530:

    2011-05-13 03:50:07.76 spid79 * P2Home: 0000000025CE7AD0: FFFFFA8001B66530 0000000025CE7AD0 000000001D7EEFE0 000007FF7FC78990 FFFFFA8000000000 FFFFFA8000000000

    2011-05-13 03:50:07.76 spid79 * P3Home: 000000001D7EEFE0: 0000000000000003 000000001D7E8B90 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2011-05-13 03:50:07.76 spid79 * P4Home: 000007FF7FC78990: 000000000000005B 0000000000000000 0000000000000000 0000000000000000 0000000100000000 0000000000000001

    2011-05-13 03:50:07.76 spid79 * P5Home: FFFFFA8000000000:

    2011-05-13 03:50:07.76 spid79 * P6Home: FFFFFA8000000000:

    2011-05-13 03:50:07.76 spid79 * ContextFlags: 000000000010001F:

    2011-05-13 03:50:07.76 spid79 * MxCsr: 0000000000001FA0:

    2011-05-13 03:50:07.76 spid79 * SegCs: 0000000000000033:

    2011-05-13 03:50:07.76 spid79 * SegDs: 000000000000002B:

    2011-05-13 03:50:07.76 spid79 * SegEs: 000000000000002B:

    2011-05-13 03:50:07.76 spid79 * SegFs: 0000000000000053:

    2011-05-13 03:50:07.76 spid79 * SegGs: 000000000000002B:

    2011-05-13 03:50:07.76 spid79 * SegSs: 000000000000002B:

    2011-05-13 03:50:07.76 spid79 * EFlags: 0000000000010246: 0065004400720065 00720061006C0063 006F006900740061 00650052003B006E 007300610065006C 006E006100480065

    2011-05-13 03:50:07.76 spid79 * Rax: 00000000172F9D70: 000000000000106C FFFFFFFFFFFFFFFF 0000000000000000 0000000100000000 0000000000000000 0000000000000000

    2011-05-13 03:50:07.76 spid79 * Rcx: 0000000000000000:

    2011-05-13 03:50:07.76 spid79 * Rdx: 000000004B06A9D0: 000000004B076870 000000002BCDD2F0 0000000000000000 00000000172F9D70 000000001A26A1A0 00000000160E50F0

    2011-05-13 03:50:07.76 spid79 * Rbx: 000000001D7EEFE0: 0000000000000003 000000001D7E8B90 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2011-05-13 03:50:07.76 spid79 * Rsp: 0000000025CE8070: 0000EF5B572157BF 0000000077EF3CC7 000000001D7EEFE0 0000000000000000 0000000000000000 000007FF63F266BE

    2011-05-13 03:50:07.76 spid79 * Rbp: 000007FF7FC78990: 000000000000005B 0000000000000000 0000000000000000 0000000000000000 0000000100000000 0000000000000001

    2011-05-13 03:50:07.76 spid79 * Rsi: 0000000025CE9640: 0020004C00510053 006900740061004E 0043002000650076 006E00650069006C 0000000700000074 0000000025CE9740

    2011-05-13 03:50:07.76 spid79 * Rdi: 0000000000000000:

    2011-05-13 03:50:07.76 spid79 * R8: 000007FFFFF1C000: 0000000000000000 0000000025CF0000 0000000025CD5000 0000000000000000 0000000000001E00 0000000000000000

    2011-05-13 03:50:07.76 spid79 * R9: 0000000025CE8C20: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000

    2011-05-13 03:50:07.76 spid79 * R10: 0000000000000000:

    2011-05-13 03:50:07.76 spid79 * R11: 0000000025CE8BC8: 000007FF63F27335 00001FA00010000F 0053002B002B0033 0000000000000012 000000001B5F8080 0000000000000105

    2011-05-13 03:50:07.76 spid79 * R12: 0000000000000001:

    2011-05-13 03:50:07.76 spid79 * R13: 0000000000000001:

    2011-05-13 03:50:07.76 spid79 * R14: 0000000000000000:

    2011-05-13 03:50:07.76 spid79 * R15: 0000000025CE9640: 0020004C00510053 006900740061004E 0043002000650076 006E00650069006C 0000000700000074 0000000025CE9740

    2011-05-13 03:50:07.76 spid79 * Rip: 000007FF7FC51D71: 7241FB83661FB70F 6604775AFB83660A 3D6606B70F20C383 005A3D660A720041 8348002005660477 856602C6834802C7

    2011-05-13 03:50:07.76 spid79 * *******************************************************************************

    2011-05-13 03:50:07.76 spid79 * -------------------------------------------------------------------------------

    2011-05-13 03:50:07.76 spid79 * Short Stack Dump

    2011-05-13 03:50:07.76 spid79 000007FF7FC51D71 Module(msvcrt+0000000000051D71)

    2011-05-13 03:50:07.76 spid79 000007FF63F266BE Module(ODBC32+00000000000266BE)

    2011-05-13 03:50:07.76 spid79 000007FF63F27335 Module(ODBC32+0000000000027335)

    2011-05-13 03:50:07.76 spid79 000007FF63F1A451 Module(ODBC32+000000000001A451)

    2011-05-13 03:50:07.76 spid79 0000000053C50494 Module(xpstar90+0000000000020494)

    2011-05-13 03:50:07.76 spid79 0000000053C62B72 Module(xpstar90+0000000000032B72)

    2011-05-13 03:50:07.76 spid79 0000000053C63668 Module(xpstar90+0000000000033668)

    2011-05-13 03:50:07.76 spid79 0000000053C64271 Module(xpstar90+0000000000034271)

    2011-05-13 03:50:07.76 spid79 0000000001CC9C41 Module(sqlservr+0000000000CC9C41)

    2011-05-13 03:50:07.76 spid79 0000000001E5D45C Module(sqlservr+0000000000E5D45C)

    2011-05-13 03:50:07.76 spid79 000000000243BA3A Module(sqlservr+000000000143BA3A)

    2011-05-13 03:50:07.76 spid79 000000000243CC95 Module(sqlservr+000000000143CC95)

    2011-05-13 03:50:07.76 spid79 00000000026115CB Module(sqlservr+00000000016115CB)

    2011-05-13 03:50:07.76 spid79 0000000001AE0D8F Module(sqlservr+0000000000AE0D8F)

    2011-05-13 03:50:07.76 spid79 0000000001839DF5 Module(sqlservr+0000000000839DF5)

    2011-05-13 03:50:07.76 spid79 0000000001839FE2 Module(sqlservr+0000000000839FE2)

    2011-05-13 03:50:07.76 spid79 00000000018583A0 Module(sqlservr+00000000008583A0)

    2011-05-13 03:50:07.76 spid79 00000000017073CE Module(sqlservr+00000000007073CE)

    2011-05-13 03:50:07.76 spid79 0000000001708F59 Module(sqlservr+0000000000708F59)

    2011-05-13 03:50:07.76 spid79 000000000170B9C5 Module(sqlservr+000000000070B9C5)

    2011-05-13 03:50:07.76 spid79 00000000017053E2 Module(sqlservr+00000000007053E2)

    2011-05-13 03:50:07.76 spid79 000000000170A59D Module(sqlservr+000000000070A59D)

    2011-05-13 03:50:07.76 spid79 00000000016BC32E Module(sqlservr+00000000006BC32E)

    2011-05-13 03:50:07.76 spid79 00000000016BC5C9 Module(sqlservr+00000000006BC5C9)

    2011-05-13 03:50:07.76 spid79 00000000016B5CC4 Module(sqlservr+00000000006B5CC4)

    2011-05-13 03:50:07.76 spid79 000000000155E837 Module(sqlservr+000000000055E837)

    2011-05-13 03:50:07.76 spid79 0000000001522F59 Module(sqlservr+0000000000522F59)

    2011-05-13 03:50:07.76 spid79 00000000015372B0 Module(sqlservr+00000000005372B0)

    2011-05-13 03:50:07.77 spid79 00000000014F72F8 Module(sqlservr+00000000004F72F8)

    2011-05-13 03:50:07.77 spid79 00000000781337D7 Module(MSVCR80+00000000000037D7)

    2011-05-13 03:50:07.77 spid79 0000000078133894 Module(MSVCR80+0000000000003894)

    2011-05-13 03:50:07.77 spid79 0000000077D6B71A Module(kernel32+000000000002B71A)

    2011-05-13 03:50:07.77 spid79 Stack Signature for the dump is 0x00000001C0C656C9

    2011-05-13 03:50:08.55 spid79 External dump process return code 0x20000001.