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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2008-11-13 : 14:27:46
|
| Hello all,For some reason I am getting an EXCEPTION_ACCESS_VIOLATION. This just started occuring the last few weeks. Can anyone help me figure out why suddenly this is happening.I have jobs that executes a stored procedure that sends mail and this is the error (it does not happen all the time)This is the version of SQL Server: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) This is in the dump file:SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..* ********************************************************************************* BEGIN STACK DUMP:* 11/13/08 02:00:03 spid 58** Exception Address = 7C81A379 (RtlEnterCriticalSection + 00000019 Line 0+00000000)* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION* Access Violation occurred writing address 07BDFF84* Input Buffer 64 bytes -* EXEC spSendingMailToList* ** MODULE BASE END SIZE* sqlservr 00400000 00CBAFFF 008bb000* ntdll 7C800000 7C8BFFFF 000c0000* kernel32 77E40000 77F41FFF 00102000* ADVAPI32 77F50000 77FEAFFF 0009b000* RPCRT4 77C50000 77CEEFFF 0009f000* Secur32 76F50000 76F62FFF 00013000* MSVCP71 7C3A0000 7C41AFFF 0007b000* MSVCR71 7C340000 7C395FFF 00056000* opends60 41060000 41065FFF 00006000* SHELL32 7C8D0000 7D0CEFFF 007ff000* msvcrt 77BA0000 77BF9FFF 0005a000* GDI32 77C00000 77C47FFF 00048000* USER32 77380000 77410FFF 00091000* SHLWAPI 77DA0000 77DF1FFF 00052000* sqlsort 42AE0000 42B6FFFF 00090000* ums 41070000 4107DFFF 0000e000* IMM32 76290000 762ACFFF 0001d000* comctl32 77420000 77522FFF 00103000* sqlevn70 41080000 4108AFFF 0000b000* NETAPI32 02CA0000 02CF6FFF 00057000* AUTHZ 02D00000 02D13FFF 00014000* COMRES 03130000 031F5FFF 000c6000* ole32 03200000 03338FFF 00139000* XOLEHLP 03340000 03345FFF 00006000* MSDTCPRX 03350000 033C8FFF 00079000* OLEAUT32 033D0000 0345AFFF 0008b000* msvcp60 03460000 034C4FFF 00065000* MTXCLU 034D0000 034E8FFF 00019000* VERSION 034F0000 034F7FFF 00008000* WSOCK32 03500000 03508FFF 00009000* WS2_32 03510000 03526FFF 00017000* WS2HELP 03530000 03537FFF 00008000* CLUSAPI 03580000 03591FFF 00012000* RESUTILS 035A0000 035B2FFF 00013000* USERENV 035C0000 03681FFF 000c2000* mswsock 036A0000 036E0FFF 00041000* DNSAPI 036F0000 03719FFF 0002a000* winrnr 03760000 03766FFF 00007000* WLDAP32 03770000 0379DFFF 0002e000* rasadhlp 037C0000 037C4FFF 00005000* NTMARTA 00E50000 00E70FFF 00021000* SAMLIB 04A50000 04A5EFFF 0000f000* SSNETLIB 04A60000 04A75FFF 00016000* security 04AB0000 04AB3FFF 00004000* hnetcfg 04AC0000 04B19FFF 0005a000* wshtcpip 04B70000 04B77FFF 00008000* SSmsLPCn 04C20000 04C27FFF 00008000* SSnmPN70 04C50000 04C56FFF 00007000* ntdsapi 04D00000 04D13FFF 00014000* kerberos 04D50000 04DA7FFF 00058000* cryptdll 04DC0000 04DCBFFF 0000c000* MSASN1 04DD0000 04DE1FFF 00012000* rsaenh 051A0000 051D4FFF 00035000* PSAPI 04D40000 04D4AFFF 0000b000* SQLFTQRY 044D0000 044F5FFF 00026000* xpsp2res 05530000 057F4FFF 002c5000* CLBCatQ 045D0000 04652FFF 00083000* sqloledb 04660000 046E0FFF 00081000* MSDART 04520000 04539FFF 0001a000* MSDATL3 046F0000 04704FFF 00015000* oledb32 05900000 05978FFF 00079000* OLEDB32R 04A30000 04A40FFF 00011000* msv1_0 05980000 059A6FFF 00027000* iphlpapi 059B0000 059C9FFF 0001a000* xpsqlbot 059E0000 059E5FFF 00006000* xpstar 05A10000 05A5CFFF 0004d000* SQLRESLD 05A60000 05A6BFFF 0000c000* SQLSVC 05A70000 05A8AFFF 0001b000* ODBC32 05A90000 05ACCFFF 0003d000* COMCTL32 05AD0000 05B66FFF 00097000* comdlg32 05B70000 05BB8FFF 00049000* odbcbcp 05BC0000 05BC5FFF 00006000* W95SCM 05BD0000 05BDCFFF 0000d000* SQLUNIRL 05BE0000 05C0CFFF 0002d000* WINSPOOL 05CA0000 05CC6FFF 00027000* SHFOLDER 05CD0000 05CD8FFF 00009000* odbcint 05EB0000 05EC6FFF 00017000* NDDEAPI 05FE0000 05FE7FFF 00008000* SQLSVC 05FF0000 05FF5FFF 00006000* xpstar 06000000 06008FFF 00009000* sqlmap70 06140000 0616CFFF 0002d000* MAPI32 06170000 0618EFFF 0001f000* MSMAPI32 06190000 06253FFF 000c4000* MPR 06260000 06270FFF 00011000* GAPI32 06280000 06297FFF 00018000* odbccp32 067F0000 06809FFF 0001a000* sqlvdi 069F0000 06A11FFF 00022000* EMSABP32 06F00000 06F24FFF 00025000* contab32 06F70000 06F8EFFF 0001f000* EMSMDB32 07100000 0718FFFF 00090000* dbghelp 082B0000 083AFFFF 00100000** Edi: 07BDFF64: * Esi: 07BDFF84: * Eax: 00000000: * Ebx: 00000000: * Ecx: 07BDFF84: * Edx: 07BDFF80: * Eip: 7C81A379: 01B30FF0 84C0920F 0E840FC0 6400010D 00180D8B 418B0000 * Ebp: 063973E0: 06397428 06197E24 07BDFF80 06397474 07BDFF64 06197927 * SegCs: 0000001B: * EFlags: 00010246: 004E003D 0000004F 004F0048 0045004D 00520044 00560049 * Esp: 063973D4: 07BDFF64 07BDFF80 07BDFF84 06397428 06197E24 07BDFF80 * SegSs: 00000023: * ******************************************************************************** -------------------------------------------------------------------------------* Short Stack Dump* 7C81A379 Module(ntdll+0001A379) (RtlEnterCriticalSection+00000019)* 06197E24 Module(MSMAPI32+00007E24) (ScInitMapiUtil+00001493)* 7739B874 Module(USER32+0001B874) (LoadCursorW+00004E86)* 7739BA92 Module(USER32+0001BA92) (TranslateMessageEx+0000010D)* 773A16E5 Module(USER32+000216E5) (DispatchMessageA+0000000F)* 061ABBB6 Module(MSMAPI32+0001BBB6) (FBadRowSet+000015E4)* 758B56EC Module(UNKNOWN+00000000)* -------------------------------------------------------------------------------Thanks for all your great help!R/P |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-11-19 : 21:43:30
|
| This is an unhandled exception in SQL Server code. This could be due to lots of different reason, including bug, corruption, HW issues etc..To understand the root cause, one has to look at the dump files, only MS support would be able to help with that. |
 |
|
|
|
|
|
EXCEPTION_ACCESS_VIOLATION