Stack Dump - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Stack Dump

Author

Topic

sachinbutala
Starting Member

4 Posts

Posted - 2004-04-02 : 09:38:35

i am reciving lots dump error messages in logs.. plz help me to find out what will be the problem

I am using sql 2000 with sp3

LazyWriter: Process 1 generated an access violation. SQL Server is terminating this process

Stack Signature for the dump is 0x22B59A47

The exception information has been submitted to Watson error reporting.

SqlDumpExceptionHandler: Process 1 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 04/02/04 17:02:32 spid 1
*
* Exception Address = 00401D11 (PmoGetOwner + 0000001E Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 11D92000
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF 00733000
* ntdll 77F80000 77FFAFFF 0007b000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77D9DFFF 0006e000
* USER32 77E10000 77E6EFFF 0005f000
* GDI32 77F40000 77F78FFF 00039000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107BFFF 0000c000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 10000000 10006FFF 00007000
* NETAPI32 10C50000 10C9EFFF 0004f000
* SECUR32 10CA0000 10CAEFFF 0000f000
* NETRAP 10CB0000 10CB5FFF 00006000
* SAMLIB 10CC0000 10CCEFFF 0000f000
* WS2_32 10CD0000 10CE3FFF 00014000
* WS2HELP 10CF0000 10CF7FFF 00008000
* WLDAP32 10D00000 10D29FFF 0002a000
* DNSAPI 10D30000 10D53FFF 00024000
* WSOCK32 10D60000 10D67FFF 00008000
* ole32 11050000 1113BFFF 000ec000
* XOLEHLP 11140000 11147FFF 00008000
* MSDTCPRX 11150000 11203FFF 000b4000
* MTXCLU 11210000 1121FFFF 00010000
* VERSION 11220000 11226FFF 00007000
* LZ32 11230000 11235FFF 00006000
* CLUSAPI 11240000 1124FFFF 00010000
* RESUTILS 11250000 1125CFFF 0000d000
* USERENV 11260000 112C0FFF 00061000
* rnr20 112D0000 112DBFFF 0000c000
* iphlpapi 11320000 11332FFF 00013000
* ICMP 11340000 11344FFF 00005000
* MPRAPI 11350000 11366FFF 00017000
* OLEAUT32 11370000 1140AFFF 0009b000
* ACTIVEDS 11410000 1143EFFF 0002f000
* ADSLDPC 11440000 11462FFF 00023000
* RTUTILS 11470000 1147DFFF 0000e000
* SETUPAPI 11480000 1150DFFF 0008e000
* RASAPI32 11510000 11542FFF 00033000
* RASMAN 11550000 11560FFF 00011000
* TAPI32 11570000 11591FFF 00022000
* COMCTL32 115A0000 11628FFF 00089000
* SHLWAPI 11630000 11677FFF 00048000
* DHCPCSVC 11680000 11698FFF 00019000
* winrnr 11B40000 11B47FFF 00008000
* rasadhlp 11B50000 11B54FFF 00005000
* SSNETLIB 12290000 122A4FFF 00015000
* security 125F0000 125F3FFF 00004000
* msafd 12DB0000 12DCDFFF 0001e000
* wshtcpip 12E10000 12E16FFF 00007000
* SSmsLPCn 12F20000 12F27FFF 00008000
* ntdsapi 12FB0000 12FC0FFF 00011000
* SQLFTQRY 14D60000 14D91FFF 00032000
* CLBCATQ 14DA0000 14E25FFF 00086000
* sqloledb 14E40000 14EB2FFF 00073000
* MSDART 14EC0000 14EDEFFF 0001f000
* comdlg32 14F00000 14F3DFFF 0003e000
* SHELL32 14F40000 15187FFF 00248000
* MSDATL3 15190000 151A4FFF 00015000
* msv1_0 15430000 1544EFFF 0001f000
* CRYPT32 154D0000 15547FFF 00078000
* MSASN1 15550000 1555FFFF 00010000
* oledb32 15660000 156C5FFF 00066000
* OLEDB32R 1F910000 1F91FFFF 00010000
* xpsqlbot 156E0000 156E5FFF 00006000
* rsabase 15780000 157A2FFF 00023000
* xpstar 15A20000 15A66FFF 00047000
* SQLRESLD 15A70000 15A76FFF 00007000
* SQLSVC 15A80000 15A96FFF 00017000
* ODBC32 15AA0000 15AD1FFF 00032000
* odbcbcp 15AE0000 15AE5FFF 00006000
* W95SCM 15AF0000 15AFBFFF 0000c000
* SQLUNIRL 15B00000 15B2CFFF 0002d000
* WINSPOOL 15B30000 15B4DFFF 0001e000
* MPR 15B50000 15B60FFF 00011000
* SHFOLDER 15B70000 15B77FFF 00008000
* odbcint 1F850000 1F865FFF 00016000
* NDDEAPI 15CC0000 15CC6FFF 00007000
* SQLSVC 15CD0000 15CD5FFF 00006000
* xpstar 15CE0000 15CE8FFF 00009000
* dbghelp 1E730000 1E7E4FFF 000b5000
*
* Edi: 00000000:
* Esi: 51D924D0: 009959D8 00000000 00530020 00000000 0000001B 00000000
* Eax: 11D92000:
* Ebx: 00000000:
* Ecx: 51D924D0: 009959D8 00000000 00530020 00000000 0000001B 00000000
* Edx: 51D93FF0: 00000001 00000058 51D92028 00000000 500E0030 00000001
* Eip: 00401D11: C35D008B 56EC8B55 8308758B 0F00187E 1770AA85 016A5700
* Ebp: 11F8F938: 11F8F944 00401DD0 11D92410 11F8F964 0046DBF7 11D92410
* SegCs: 0000001B:
* EFlags: 00010206: 004E004E 005C0054 00790073 00740073 006D0065 00320033
* Esp: 11F8F938: 11F8F944 00401DD0 11D92410 11F8F964 0046DBF7 11D92410
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 00401D11 Module(sqlservr+00001D11) (PmoGetOwner+0000001E)
* 00401DD0 Module(sqlservr+00001DD0) (commondelete+00000011)
* 0046DBF7 Module(sqlservr+0006DBF7) (CValRefRow::~CValRefRow+00000023)
* 0046DC17 Module(sqlservr+0006DC17) (CValRefRow::`vector deleting destructor'+0000000B)
* 00427D52 Module(sqlservr+00027D52) (CValSSRowRef::Deref+0000000B)
* 0046E441 Module(sqlservr+0006E441) (CEsCompValSeg::~CEsCompValSeg+0000001A)
* 0046E3EF Module(sqlservr+0006E3EF) (CEsComp::~CEsComp+0000009A)
* 0046E35E Module(sqlservr+0006E35E) (CEs::DestroyPesc+00000019)
* 004BA9B4 Module(sqlservr+000BA9B4) (CXteSort::~CXteSort+0000005A)
* 004BA946 Module(sqlservr+000BA946) (CXteSort::`vector deleting destructor'+0000000B)
* 00426A6E Module(sqlservr+00026A6E) (CQte::~CQte+00000022)
* 0046E4C1 Module(sqlservr+0006E4C1) (CXte::~CXte+0000004D)
* 004BAD74 Module(sqlservr+000BAD74) (CXteMergeJoin::~CXteMergeJoin+00000105)
* 004BAC64 Module(sqlservr+000BAC64) (CXteMergeJoin::`vector deleting destructor'+0000000B)
* 004BAA94 Module(sqlservr+000BAA94) (CXteHashMatch::~CXteHashMatch+00000087)
* 004BA9FA Module(sqlservr+000BA9FA) (CXteHashMatch::`vector deleting destructor'+0000000B)
* 00426A90 Module(sqlservr+00026A90) (CQte::~CQte+00000050)
* 0046E4C1 Module(sqlservr+0006E4C1) (CXte::~CXte+0000004D)
* 0046E460 Module(sqlservr+0006E460) (CXteConstScan::`scalar deleting destructor'+0000000B)
* 0046E21B Module(sqlservr+0006E21B) (CQuery::~CQuery+00000035)
* 0046E128 Module(sqlservr+0006E128) (CQuery::`scalar deleting destructor'+0000000B)
* 0093AF4B Module(sqlservr+0053AF4B) (CFetchPopulate::~CFetchPopulate+00000032)
* 0059B05F Module(sqlservr+0019B05F) (CFetchSnapshot::~CFetchSnapshot+00000044)
* 0059A72D Module(sqlservr+0019A72D) (CFetchSnapshot::`scalar deleting destructor'+0000000B)
* 005838CE Module(sqlservr+001838CE) (CCompiledDeclareObjects::~CCompiledDeclareObjects+00000017)
* 005838A3 Module(sqlservr+001838A3) (CCompiledDeclareObjects::`scalar deleting destructor'+0000000B)
* 00583961 Module(sqlservr+00183961) (CCompiledDeclareObjects::Release+00000021)
* 005804EA Module(sqlservr+001804EA) (CCursorDeclareStmt::~CCursorDeclareStmt+00000056)
* 00580480 Module(sqlservr+00180480) (CCursorDeclareStmt::`vector deleting destructor'+0000000B)
* 0044EA22 Module(sqlservr+0004EA22) (CCompPlan::~CCompPlan+00000034)
* 0044E9DA Module(sqlservr+0004E9DA) (CCompPlan::`vector deleting destructor'+0000000B)
* 00445D4A Module(sqlservr+00045D4A) (CCacheObject::Release+000000D8)
* 005E2085 Module(sqlservr+001E2085) (CCache::FRemoveOne+00000316)
* 0082DD86 Module(sqlservr+0042DD86) (BPool::ReplenishFreeList+0000014A)
* 004FC859 Module(sqlservr+000FC859) (BPool::LazyWriter+00000237)
* 004FC7A7 Module(sqlservr+000FC7A7) (lazywriter+000000E5)
* 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B382 Module(KERNEL32+0000B382) (lstrcmpiW+000000B7)
* -------------------------------------------------------------------------------

Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:\SQL70\MSSQL\log\SQLDump1493.txt

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-04-02 : 12:21:02

I would suggest searching MS' knowledge base for your particular problem. Access violations can occur for various reasons. You need to search on your error at the knowledge base and see which article fits your environment.

http://support.microsoft.com

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources