Sql errror: EXCEPTION_ACCESS_VIOLATION

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)

Sql errror: EXCEPTION_ACCESS_VIOLATION

Author

Topic

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2002-10-13 : 21:41:08

Hi there,

I have had the following sql error on a new server and am trying to find out what it menas!! Here is the info from the log:

process_commands: Process 1952 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:08 spid 0
*
* Exception Address = 0040A832 (CVariableInfo::CVarBlock::PvbJoin + 0000003E Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000085
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 77F80000 77FFAFFF 0007b000
* KERNEL32 77E80000 77F35FFF 000b6000
* ADVAPI32 77DB0000 77E0CFFF 0005d000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78045FFF 00046000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 75170000 751BEFFF 0004f000
* SECUR32 77BE0000 77BEEFFF 0000f000
* NETRAP 751C0000 751C5FFF 00006000
* SAMLIB 75150000 7515FFFF 00010000
* WS2_32 75030000 75042FFF 00013000
* WS2HELP 75020000 75027FFF 00008000
* WLDAP32 77950000 77979FFF 0002a000
* DNSAPI 77980000 779A3FFF 00024000
* WSOCK32 75050000 75057FFF 00008000
* ole32 77A50000 77B44FFF 000f5000
* wmi 76110000 76113FFF 00004000
* XOLEHLP 65450000 65457FFF 00008000
* MSDTCPRX 6DF80000 6E032FFF 000b3000
* MTXCLU 6A7A0000 6A7AFFFF 00010000
* VERSION 77820000 77826FFF 00007000
* LZ32 759B0000 759B5FFF 00006000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 77C10000 77C6DFFF 0005e000
* rnr20 782C0000 782CBFFF 0000c000
* iphlpapi 77340000 77352FFF 00013000
* ICMP 77520000 77524FFF 00005000
* MPRAPI 77320000 77336FFF 00017000
* OLEAUT32 779B0000 77A4AFFF 0009b000
* ACTIVEDS 773B0000 773DDFFF 0002e000
* ADSLDPC 77380000 773A1FFF 00022000
* RTUTILS 77830000 7783DFFF 0000e000
* SETUPAPI 77880000 7790CFFF 0008d000
* RASAPI32 774E0000 77511FFF 00032000
* RASMAN 774C0000 774D0FFF 00011000
* TAPI32 77530000 77551FFF 00022000
* COMCTL32 71710000 71793FFF 00084000
* SHLWAPI 70BD0000 70C34FFF 00065000
* DHCPCSVC 77360000 77378FFF 00019000
* winrnr 777E0000 777E7FFF 00008000
* rasadhlp 777F0000 777F4FFF 00005000
* SSNETLIB 42CF0000 42D05FFF 00016000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 75500000 75503FFF 00004000
* msafd 74FD0000 74FECFFF 0001d000
* wshtcpip 75010000 75016FFF 00007000
* SSmsLPCn 42CD0000 42CD6FFF 00007000
* ntdsapi 77BF0000 77C00FFF 00011000
* rsabase 7CA00000 7CA21FFF 00022000
* CRYPT32 77440000 774B6FFF 00077000
* MSASN1 77430000 7743FFFF 00010000
* SQLFTQRY 41020000 41051FFF 00032000
* CLBCATQ 775A0000 77624FFF 00085000
* sqloledb 75370000 753E8FFF 00079000
* MSDART 2AC70000 2AC92FFF 00023000
* comdlg32 76B30000 76B6CFFF 0003d000
* SHELL32 782F0000 78535FFF 00246000
* MSDATL3 2ACA0000 2ACB5FFF 00016000
* msv1_0 782D0000 782EDFFF 0001e000
* oledb32 2AF40000 2AFAEFFF 0006f000
* OLEDB32R 2AFB0000 2AFC0FFF 00011000
* xpsqlbot 42F00000 42F05FFF 00006000
* xpstar 410F0000 41135FFF 00046000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 42C40000 42C56FFF 00017000
* ODBC32 2B090000 2B0C4FFF 00035000
* odbcbcp 41150000 41156FFF 00007000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 41090000 410BCFFF 0002d000
* WINSPOOL 77800000 7781DFFF 0001e000
* MPR 76620000 7662FFFF 00010000
* SHFOLDER 719B0000 719B7FFF 00008000
* odbcint 2B1D0000 2B1E5FFF 00016000
* NDDEAPI 769A0000 769A6FFF 00007000
* SQLSVC 43970000 43975FFF 00006000
* xpstar 439E0000 439E8FFF 00009000
* dbghelp 72A00000 72A2CFFF 0002d000
*
* Edi: 00000079:
* Esi: 00000001:
* Eax: 1B2B88B2: 000013B0 00000028 36000104 00014A00 00000079 000DAC00
* Ebx: 000DAC00: 00000000 00000002 00000079 00000000 0006000D 000E0100
* Ecx: 1B2B88BA: 36000104 00014A00 00000079 000DAC00 00380100 04260000
* Edx: 1B2B8882: 00000001 00000005 03080007 2B002300 53003400 6C6C6568
* Eip: 0040A832: 660C5F89 6606498B F79C0D03 01660097 8B660648 B70F0648
* Ebp: 2B62FA14: 2B62FA24 0040A72C 1B2B88BA 1B4D6090 2B62FA30 00401B52
* SegCs: 0000001B:
* EFlags: 00010206: 00320033 0043003B 005C003A 00490057 004E004E 003B0054
* Esp: 2B62F9F8: 1B2B88B2 00000000 1B2B8000 0040A782 1B2B9100 1B4D604C
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 0040A832 Module(sqlservr+0000A832) (CVariableInfo::CVarBlock::PvbJoin+0000003E)
* 0040A782 Module(sqlservr+0000A782) (CVariableInfo::PviRelease+00000056)
* 0040A72C Module(sqlservr+0000A72C) (CVarPageMgr::Release+00000014)
* 00401B52 Module(sqlservr+00001B52) (CMemObj::Free+0000001E)
* 00401B26 Module(sqlservr+00001B26) (commondelete+0000001B)
* 0040D893 Module(sqlservr+0000D893) (srv_proc::Release+000000B2)
* 00532CBD Module(sqlservr+00132CBD) (release_srvproc+0000007A)
* 00411114 Module(sqlservr+00011114) (process_commands+00000280)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
*Dump thread - spid = 1, PSS = 0x19166090, EC = 0x191663a0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:10 spid 1
*
* StackDump (all)
*
*
*
* Edi: 000001F4:
* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454
* Eax: 00004F70:
* Ebx: 00000000:
* Ecx: 00000000:
* Edx: 00000000:
* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4
* Ebp: 29B8FB7C: 29B8FB98 410714C4 000001F4 FFFFFFFF 00000001 00BC6440
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 29B8FB58: 77E8780F 000001F4 00000001 00000000 19166568 4107177E
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)
* 410714C4 Module(UMS+000014C4) (UmsThreadScheduler::Switch+00000058)
* 4107176A Module(UMS+0000176A) (UmsScheduler::IdleLoop+00000122)
* 410718E9 Module(UMS+000018E9) (UmsScheduler::Suspend+0000007E)
* 41071813 Module(UMS+00001813) (UmsEvent::Wait+00000095)
* 004011DD Module(sqlservr+000011DD) (ExecutionContext::WaitForSignal+000001B5)
* 004D18B1 Module(sqlservr+000D18B1) (BPool::LazyWriter+000001A6)
* 004D183F Module(sqlservr+000D183F) (lazywriter+000000E5)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
*Dump thread - spid = 2, PSS = 0x19186090, EC = 0x191863a0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:10 spid 2
*
* StackDump (all)
*
*
*
* Edi: 000001FC:
* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454
* Eax: 00000000:
* Ebx: 00000000:
* Ecx: 1918654C: 00000000 00000002 00000001 00000000 00000000 00A0DF60
* Edx: 00000000:
* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4
* Ebp: 29C0FDC4: 29C0FDE0 410714C4 000001FC FFFFFFFF 00000001 00BC6440
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 29C0FDA0: 77E8780F 000001FC 00000001 00000000 00A0DF60 4107177E
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)
* 410714C4 Module(UMS+000014C4) (UmsThreadScheduler::Switch+00000058)
* 4107176A Module(UMS+0000176A) (UmsScheduler::IdleLoop+00000122)
* 410718E9 Module(UMS+000018E9) (UmsScheduler::Suspend+0000007E)
* 41071813 Module(UMS+00001813) (UmsEvent::Wait+00000095)
* 004011DD Module(sqlservr+000011DD) (ExecutionContext::WaitForSignal+000001B5)
* 004017D3 Module(sqlservr+000017D3) (ResQueueBase::Wait+0000002F)
* 0040164C Module(sqlservr+0000164C) (ResQueueBase::Dequeue+00000069)
* 004D0619 Module(sqlservr+000D0619) (LogMgr::LogWriter+00000080)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
*Dump thread - spid = 3, PSS = 0x19184090, EC = 0x191843a0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:10 spid 3
*
* StackDump (all)
*
*
*
* Edi: 00000204:
* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454
* Eax: 00000004:
* Ebx: 00000000:
* Ecx: 00000200:
* Edx: 00000000:
* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4
* Ebp: 29C8FE3C: 29C8FE58 410714C4 00000204 FFFFFFFF 00000001 00BC6440
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 29C8FE18: 77E8780F 00000204 00000001 00000000 191843A0 19184090
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)
* 410714C4 Module(UMS+000014C4) (UmsThreadScheduler::Switch+00000058)
* 4107176A Module(UMS+0000176A) (UmsScheduler::IdleLoop+00000122)
* 410718E9 Module(UMS+000018E9) (UmsScheduler::Suspend+0000007E)
* 41071813 Module(UMS+00001813) (UmsEvent::Wait+00000095)
* 004C343B Module(sqlservr+000C343B) (SignalProc+000000C4)
* 004D1B9D Module(sqlservr+000D1B9D) (StartUp::InitDBMS+0000011E)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
*Dump thread - spid = 4, PSS = 0x19180090, EC = 0x191803a0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:10 spid 4
*
* StackDump (all)
*
*
*
* Edi: 0000020C:
* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454
* Eax: 41079020: 00BC6488 00BC6488 00000000 00000000 00000001 00000000
* Ebx: 00000000:
* Ecx: 41079020: 00BC6488 00BC6488 00000000 00000000 00000001 00000000
* Edx: 00000000:
* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4
* Ebp: 29D0FD3C: 29D0FD58 410714C4 0000020C FFFFFFFF 00000001 00BC6440
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 29D0FD18: 77E8780F 0000020C 00000001 00000000 00A63A60 4107177E
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)
* 410714C4 Module(UMS+000014C4) (UmsThreadScheduler::Switch+00000058)
* 4107176A Module(UMS+0000176A) (UmsScheduler::IdleLoop+00000122)
* 410718E9 Module(UMS+000018E9) (UmsScheduler::Suspend+0000007E)
* 41071813 Module(UMS+00001813) (UmsEvent::Wait+00000095)
* 004011DD Module(sqlservr+000011DD) (ExecutionContext::WaitForSignal+000001B5)
* 004017D3 Module(sqlservr+000017D3) (ResQueueBase::Wait+0000002F)
* 0040164C Module(sqlservr+0000164C) (ResQueueBase::Dequeue+00000069)
* 004D0A5C Module(sqlservr+000D0A5C) (lockMonitor+0000009F)
* 004D07AC Module(sqlservr+000D07AC) (lockMonitorThread+000000A4)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
***Unable to get thread context for spid 5
*Dump thread - spid = 6, PSS = 0x1918c090, EC = 0x1918c3a0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:10 spid 6
*
* StackDump (all)
*
*
*
* Edi: 0000021C:
* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454
* Eax: 1918E018: 00000001 00000000 00000000 1918F030 00000001 10000008
* Ebx: 00000000:
* Ecx: 1918FFF0: 00000001 00000FB8 1918F030 00000000 1920C030 00000001
* Edx: 00000000:
* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4
* Ebp: 29E0FBC4: 29E0FBE0 410714C4 0000021C FFFFFFFF 00000001 00BC6440
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 29E0FBA0: 77E8780F 0000021C 00000001 00000000 00A0D2E8 4107177E
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)
* 410714C4 Module(UMS+000014C4) (UmsThreadScheduler::Switch+00000058)
* 4107176A Module(UMS+0000176A) (UmsScheduler::IdleLoop+00000122)
* 410718E9 Module(UMS+000018E9) (UmsScheduler::Suspend+0000007E)
* 41071813 Module(UMS+00001813) (UmsEvent::Wait+00000095)
* 004011DD Module(sqlservr+000011DD) (ExecutionContext::WaitForSignal+000001B5)
* 004017D3 Module(sqlservr+000017D3) (ResQueueBase::Wait+0000002F)
* 0040164C Module(sqlservr+0000164C) (ResQueueBase::Dequeue+00000069)
* 004D0D24 Module(sqlservr+000D0D24) (systemTaskThread+00000198)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
*Dump thread - spid = 7, PSS = 0x191e6090, EC = 0x191e63a0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/14/02 08:39:11 spid 7
*
* StackDump (all)
*
*
*
* Edi: 00000214:
* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454
* Eax: 297EA8EC: 297EC114 297EC514 0E0C9982 0DFEDDE2 000DBBA0 297EA8E0
* Ebx: 00000000:
* Ecx: 00BC64AC: 297EC414 297E638C 000000B0 000EA836 00098BEE 00000001
* Edx: 00000000:
* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4
* Ebp: 29D8FBB0: 29D8FBCC 410714C4 00000214 FFFFFFFF 00000001 00BC6440
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 29D8FB8C: 77E8780F 00000214 00000001 00000000 00A63F98 4107177E
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)
* 410714C4 Module(UMS+000014C4) (UmsThreadScheduler::Switch+00000058)
* 4107176A Module(UMS+0000176A) (UmsScheduler::IdleLoop+00000122)
* 410718E9 Module(UMS+000018E9) (UmsScheduler::Suspend+0000007E)
* 41071813 Module(UMS+00001813) (UmsEvent::Wait+00000095)
* 004011DD Module(sqlservr+000011DD) (ExecutionContext::WaitForSignal+000001B5)
* 004017D3 Module(sqlservr+000017D3) (ResQueueBase::Wait+0000002F)
* 0040164C Module(sqlservr+0000164C) (ResQueueBase::Dequeue+00000069)
* 004D21E1 Module(sqlservr+000D21E1) (ckptproc+000000E2)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E887DD Module(KERNEL32+000087DD) (GetModuleFileNameA+000001D1)
* -------------------------------------------------------------------------------
***Unable to get thread context for spid 8
***Unable to get thread context for spid 9
***Unable to get thread context for spid 10
***Unable to get thread context for spid 11
***Unable to get thread context for spid 12
***Unable to get thread context for spid 13
***Unable to get thread context for spid 51
***Unable to get thread context for spid 52
***Unable to get thread context for spid 53
***Unable to get thread context for spid 54
***Unable to get thread context for spid 55
***Unable to get thread context for spid 56
***Unable to get thread context for spid 57
***Unable to get thread context for spid 58
***Unable to get thread context for spid 59
***Unable to get thread context for spid 60
***Unable to get thread context for spid 61
***Unable to get thread context for spid 63
***Unable to get thread context for spid 64
***Unable to get thread context for spid 65
***Unable to get thread context for spid 66
***Unable to get thread context for spid 67
***Unable to get thread context for spid 68
***Unable to get thread context for spid 71
***Unable to get thread context for spid 72
***Unable to get thread context for spid 73
***Unable to get thread context for spid 75

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-10-14 : 09:56:15

C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00003.dmp will be more useful in determining the cause - it should contain the command than preceded the AV. Are you on SQL 7 ?

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources