SQLServer 2000 EXCEPTION_ACCESS_VIOLATION SqlDumpExceptionHandler

microsoft.public.sqlserver.programming

29 Jul 2005 5:49 PM

Kalvin

I am using SQL Server 2000 Sp 3a. The following error was generated
and no more connections to the DB were possible. I could still use the
machine as long as I didn't try to use SQLServer on the machine. I
tried to stop the MSSQL service from service manager but it said the
service would not respond. I rebooted the server and ran DBCC CheckDB
on the databases with no corruption found. I would like to know what
caused it and how to prevent it from happening again. From looking at
this information it looks like it may have caused by the SQL Profiler
but I don't understand why it would cause such a system wide problem
like this.

I appreciate any help I can get on links or explanations of what this
information means.

Kalvin

/*   begin error   */

SqlDumpExceptionHandler: Process 91 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
*
*******************************************************************************
*
* BEGIN STACK DUMP:
*   07/29/05 11:44:41 spid 91
*
*   Exception Address = 00644583 (CRowsetTraceData::FGetNextRow +
0000015B Line 0+00000000)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred reading address 07870000
* Input Buffer 52 bytes -
* exec sp_trace_getdata 2, 0
*
*
* MODULE                          BASE      END       SIZE
* sqlservr                       00400000 00B2CFFF 0072d000
* ntdll                          77F80000 77FFCFFF 0007d000
* KERNEL32                       7C570000 7C622FFF 000b3000
* ADVAPI32                       7C2D0000 7C331FFF 00062000
* RPCRT4                         77D30000 77DA0FFF 00071000
* USER32                         77E10000 77E6EFFF 0005f000
* GDI32                          77F40000 77F7AFFF 0003b000
* OPENDS60                       41060000 41065FFF 00006000
* MSVCRT                         78000000 78044FFF 00045000
* UMS                            41070000 4107CFFF 0000d000
* SQLSORT                        42AE0000 42B6FFFF 00090000
* MSVCIRT                        780A0000 780B1FFF 00012000
* sqlevn70                       41080000 41086FFF 00007000
* NETAPI32                       02BD0000 02C1EFFF 0004f000
* Secur32                        02C20000 02C2EFFF 0000f000
* NTDSAPI                        02C30000 02C40FFF 00011000
* DNSAPI                         02C50000 02C73FFF 00024000
* WSOCK32                        02C80000 02C87FFF 00008000
* WS2_32                         02C90000 02CA3FFF 00014000
* WS2HELP                        02CB0000 02CB7FFF 00008000
* WLDAP32                        02CC0000 02CE9FFF 0002a000
* NETRAP                         02CF0000 02CF5FFF 00006000
* SAMLIB                         02D00000 02D0EFFF 0000f000
* ole32                          03170000 0325EFFF 000ef000
* XOLEHLP                        03260000 03267FFF 00008000
* MSDTCPRX                       03270000 03326FFF 000b7000
* MTXCLU                         03330000 0333FFFF 00010000
* VERSION                        03340000 03346FFF 00007000
* LZ32                           03350000 03355FFF 00006000
* CLUSAPI                        03360000 0336FFFF 00010000
* RESUTILS                       03370000 0337CFFF 0000d000
* USERENV                        03380000 033E0FFF 00061000
* rnr20                          033F0000 033FBFFF 0000c000
* iphlpapi                       03440000 03452FFF 00013000
* ICMP                           03460000 03464FFF 00005000
* MPRAPI                         03470000 03486FFF 00017000
* OLEAUT32                       03490000 0352AFFF 0009b000
* ACTIVEDS                       03530000 0355EFFF 0002f000
* ADSLDPC                        03560000 03582FFF 00023000
* RTUTILS                        03590000 0359DFFF 0000e000
* SETUPAPI                       035A0000 0362DFFF 0008e000
* RASAPI32                       03630000 03662FFF 00033000
* RASMAN                         03670000 03680FFF 00011000
* TAPI32                         03690000 036B1FFF 00022000
* COMCTL32                       036C0000 03743FFF 00084000
* SHLWAPI                        03750000 037B5FFF 00066000
* DHCPCSVC                       037C0000 037D8FFF 00019000
* winrnr                         03C80000 03C87FFF 00008000
* rasadhlp                       03C90000 03C94FFF 00005000
* SSNETLIB                       04460000 04474FFF 00015000
* SSNMPN70                       04480000 04485FFF 00006000
* security                       047C0000 047C3FFF 00004000
* msafd                          04FE0000 04FFDFFF 0001e000
* wshtcpip                       05040000 05046FFF 00007000
* SSmsLPCn                       050D0000 050D6FFF 00007000
* mswsock                        05190000 051A1FFF 00012000
* kerberos                       05200000 05235FFF 00036000
* CRYPTDLL                       05240000 0524DFFF 0000e000
* MSASN1                         05250000 0525FFFF 00010000
* SQLFTQRY                       05D40000 05D71FFF 00032000
* CLBCATQ                        05E00000 05E8FFFF 00090000
* sqloledb                       05EA0000 05F1AFFF 0007b000
* MSDART                         05FB0000 05FD2FFF 00023000
* comdlg32                       05FE0000 0601DFFF 0003e000
* SHELL32                        06020000 06264FFF 00245000
* MSDATL3                        06270000 06284FFF 00015000
* oledb32                        06710000 0677BFFF 0006c000
* OLEDB32R                       06780000 06790FFF 00011000
* msv1_0                         067B0000 067D0FFF 00021000
* CRYPT32                        067E0000 06866FFF 00087000
* xpsqlbot                       06880000 06885FFF 00006000
* xpstar                         06890000 068D6FFF 00047000
* SQLRESLD                       068E0000 068E6FFF 00007000
* SQLSVC                         068F0000 06906FFF 00017000
* ODBC32                         06910000 06945FFF 00036000
* odbcbcp                        06950000 06955FFF 00006000
* W95SCM                         06960000 0696BFFF 0000c000
* SQLUNIRL                       06970000 0699CFFF 0002d000
* WINSPOOL                       069A0000 069BDFFF 0001e000
* MPR                            069C0000 069CFFFF 00010000
* SHFOLDER                       069D0000 069D7FFF 00008000
* odbcint                        06BA0000 06BB6FFF 00017000
* NDDEAPI                        06BC0000 06BC6FFF 00007000
* SQLSVC                         06BD0000 06BD5FFF 00006000
* xpstar                         06BE0000 06BE8FFF 00009000
* rsabase                        06E30000 06E52FFF 00023000
* xplog70                        07A80000 07A91FFF 00012000
* xplog70                        07AA0000 07AA3FFF 00004000
* sqlmap70                       07F10000 07F39FFF 0002a000
* MAPI32                         07F40000 07FF7FFF 000b8000
* EMSABP32                       08250000 08278FFF 00029000
* EMSMDB32                       082C0000 083A9FFF 000ea000
* odbccp32                       08530000 08549FFF 0001a000
* msxml2                         172E0000 1738DFFF 000ae000
* dbghelp                        0AF80000 0B034FFF 000b5000
*
*        Edi: 0A9FE184: 00000000 00000000 00000000 00000000
00000000 00000000
*        Esi: 0786FFFF:
*        Eax: 00650068: CE840F03 6AFFFFFD FFD4EB02 4D8DD175
CAC0E8D0 2DE9FFDF
*        Ebx: 7BC02D00: 009AFB40 00000002 00000000 00000000
3A1D7338 00000000
*        Ecx: 0015C7C5: 41005F00 43005200 49004800 45005400
54004300 52005500
*        Edx: 00000000:
*        Eip: 00644583: C88BA5F3 F303E183 FC458BA4 04D0448B
42204301 7CF8553B
*        Ebp: 06D1E9C8: 06D1E9D8 0092B837 7BC02648 7BC02518
06D1EA34 00484E1C
*      SegCs: 0000001B:
*     EFlags: 00010202: 00490048 004F0043 0053004E 0043003D
005C003A 00720050
*        Esp: 06D1E9B4: 7BC02CB8 7BC02654 00000000 00000001
3A1D7358 06D1E9D8
*      SegSs: 00000023:
*
*******************************************************************************
*
-------------------------------------------------------------------------------
* Short Stack Dump
* 00644583 Module(sqlservr+00244583)
(CRowsetTraceData::FGetNextRow+0000015B)
* 0092B837 Module(sqlservr+0052B837) (CUtRowset::GetNextRows+00000050)
* 00484E1C Module(sqlservr+00084E1C) (CQScanRmtScan::GetRow+00000155)
* 0040DEE3 Module(sqlservr+0000DEE3) (CQueryScan::GetRow+00000014)
* 0041D68F Module(sqlservr+0001D68F)
(CStmtQuery::ErsqExecuteQuery+00000399)
* 00429DFF Module(sqlservr+00029DFF)
(CStmtSelect::XretExecute+00000229)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88)
(CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A)
(CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88)
(CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
*
-------------------------------------------------------------------------------