Error when selecting from a view

Question

Post reply

Error when selecting from a view

Animal Magic

SSChampion

Points: 13964
More actions
August 21, 2007 at 3:23 am

#117879

Hi All,
I am running a simple select query from a view which has worked for ages and now i get the following message..
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I have done a checkdb and no errors reported. I will post the logfile that is generated below in the hope that someone could point me towards a resolution. Thanks in advance.
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.3042.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is COMPAQ - 10
NR138 BIOS Rev: 1.08
Current time is 10:10:00 08/21/07.
1 Intel x86 level 15, 3 Mhz processor (s).
Windows NT 5.1 Build 2600 CSD Service Pack 2.
Memory
MemoryLoad = 79%
Total Physical = 1527 MB
Available Physical = 310 MB
Total Page File = 3427 MB
Available Page File = 2297 MB
Total Virtual = 2047 MB
Available Virtual = 394 MB
***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0035.txt
SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/21/07 10:10:00 spid 54
*
*
* Exception Address = 0122BAFD Module(sqlservr+0022BAFD)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 122 bytes -
* select * from vw_PB_PostExpiryLessThanValueReprint
*
*
* MODULE BASE END SIZE
* sqlservr 01000000 02C09FFF 01c0a000
* ntdll 7C900000 7C9AFFFF 000b0000
* kernel32 7C800000 7C8F3FFF 000f4000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77C10000 77C67FFF 00058000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77DD0000 77E6AFFF 0009b000
* RPCRT4 77E70000 77F00FFF 00091000
* USER32 77D40000 77DCFFFF 00090000
* GDI32 77F10000 77F55FFF 00046000
* CRYPT32 77A80000 77B13FFF 00094000
* MSASN1 77B20000 77B31FFF 00012000
* Secur32 77FE0000 77FF0FFF 00011000
* MSWSOCK 71A50000 71A8EFFF 0003f000
* WS2_32 71AB0000 71AC6FFF 00017000
* WS2HELP 71AA0000 71AA7FFF 00008000
* USERENV 769C0000 76A72FFF 000b3000
* opends60 333E0000 333E6FFF 00007000
* NETAPI32 5B860000 5B8B3FFF 00054000
* SHELL32 7C9C0000 7D1D3FFF 00814000
* SHLWAPI 77F60000 77FD5FFF 00076000
* comctl32 773D0000 774D1FFF 00102000
* comctl32 5D090000 5D126FFF 00097000
* psapi 76BF0000 76BFAFFF 0000b000
* instapi 48060000 48069FFF 0000a000
* sqlevn70 4F610000 4F7B8FFF 001a9000
* SQLOS 344D0000 344D4FFF 00005000
* rsaenh 33A50000 33A77FFF 00028000
* AUTHZ 776C0000 776D0FFF 00011000
* MSCOREE 79000000 79044FFF 00045000
* ole32 774E0000 7761BFFF 0013c000
* msv1_0 77C70000 77C92FFF 00023000
* iphlpapi 76D60000 76D78FFF 00019000
* kerberos 34330000 3437AFFF 0004b000
* cryptdll 34380000 3438BFFF 0000c000
* schannel 343A0000 343C6FFF 00027000
* COMRES 77050000 77114FFF 000c5000
* XOLEHLP 34420000 34425FFF 00006000
* MSDTCPRX 6E560000 6E5CBFFF 0006c000
* MSVCP60 34430000 34494FFF 00065000
* MTXCLU 344A0000 344B2FFF 00013000
* VERSION 77C00000 77C07FFF 00008000
* WSOCK32 344C0000 344C8FFF 00009000
* CLUSAPI 76D10000 76D20FFF 00011000
* OLEAUT32 77120000 771ABFFF 0008c000
* RESUTILS 5B8C0000 5B8D1FFF 00012000
* FwcWsp 5B8F0000 5B920FFF 00031000
* DNSAPI 76F20000 76F46FFF 00027000
* winrnr 76FB0000 76FB7FFF 00008000
* WLDAP32 76F60000 76F8BFFF 0002c000
* hnetcfg 662B0000 66307FFF 00058000
* wshtcpip 71A90000 71A97FFF 00008000
* rasadhlp 76FC0000 76FC5FFF 00006000
* security 5BE10000 5BE13FFF 00004000
* msfte 5C440000 5C698FFF 00259000
* dbghelp 5C6A0000 5C7B4FFF 00115000
* WINTRUST 76C30000 76C5DFFF 0002e000
* IMAGEHLP 76C90000 76CB7FFF 00028000
* xpsp2res 5CA00000 5CCC4FFF 002c5000
* dssenh 68100000 68123FFF 00024000
* NTMARTA 77690000 776B0FFF 00021000
* SAMLIB 5CD60000 5CD72FFF 00013000
* ntdsapi 5CD80000 5CD92FFF 00013000
* CLBCATQ 76FD0000 7704EFFF 0007f000
* sqlncli 5CDA0000 5CFC3FFF 00224000
* comdlg32 00780000 007C8FFF 00049000
* SQLNCLIR 5CFD0000 5D002FFF 00033000
* msftepxy 60010000 60024FFF 00015000
* LEServer 60860000 608B5FFF 00056000
* ODBC32 608C0000 608FCFFF 0003d000
* odbcbcp 711A0000 711A5FFF 00006000
* odbcint 603C0000 603D6FFF 00017000
* dbghelp 60B10000 60BD0FFF 000c1000
* xpsqlbot 60E10000 60E15FFF 00006000
* xpstar90 60E30000 60E78FFF 00049000
* SQLSCM90 60E90000 60E98FFF 00009000
* BatchParser90 60EB0000 60ECEFFF 0001f000
* ATL80 7C630000 7C64AFFF 0001b000
* xpstar90 60EE0000 60F05FFF 00026000
* xplog70 60F10000 60F1BFFF 0000c000
* xplog70 60F30000 60F32FFF 00003000
* dbghelp 610D0000 611E4FFF 00115000
*
* Edi: 00000003:
* Esi: 00000001:
* Eax: 070928E0: 00000003 00000003 070928F8 0A850028 00000000 00000001
* Ebx: 0A850FA8: 01432808 00000001 0A850028 0A850028 00000162 00000000
* Ecx: 00000000:
* Edx: 070928F8: 06827410 00000000 06B89EC8 00000000 00000110 00000167
* Eip: 0122BAFD: 908B018B 00000134 FF006A53 01C683D2 B17DF73B 9090DAEB
* Ebp: 602BED8C: 602BEDA0 0122CB27 07092870 0A850FA8 0A5F4620 602BEDDC
* SegCs: 0000001B:
* EFlags: 00010293: 20004C00 2E003400 5C003000 69006200 5C006E00 4E000000
* Esp: 602BED80: 07092870 07DA8A50 0A850FA8 602BEDA0 0122CB27 07092870
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
0122BAFD Module(sqlservr+0022BAFD)
0122CB27 Module(sqlservr+0022CB27)
0136963B Module(sqlservr+0036963B)
013A9E8B Module(sqlservr+003A9E8B)
013A9DC5 Module(sqlservr+003A9DC5)
013A9A04 Module(sqlservr+003A9A04)
013AFE9C Module(sqlservr+003AFE9C)
013A9DC5 Module(sqlservr+003A9DC5)
013A9A04 Module(sqlservr+003A9A04)
013AF927 Module(sqlservr+003AF927)
013A9A04 Module(sqlservr+003A9A04)
013AFC6E Module(sqlservr+003AFC6E)
013A9A04 Module(sqlservr+003A9A04)
013A9BDC Module(sqlservr+003A9BDC)
01368BB2 Module(sqlservr+00368BB2)
013A929A Module(sqlservr+003A929A)
01346B6B Module(sqlservr+00346B6B)
01430633 Module(sqlservr+00430633)
0134752A Module(sqlservr+0034752A)
01028600 Module(sqlservr+00028600)
01032A36 Module(sqlservr+00032A36)
0102F1F4 Module(sqlservr+0002F1F4)
010077A6 Module(sqlservr+000077A6)
010078CC Module(sqlservr+000078CC)
010075DC Module(sqlservr+000075DC)
010B94A5 Module(sqlservr+000B94A5)
010B939C Module(sqlservr+000B939C)
010B9064 Module(sqlservr+000B9064)
010B9201 Module(sqlservr+000B9201)
781329AA Module(MSVCR80+000029AA)
78132A36 Module(MSVCR80+00002A36)
PSS @0x0E5C1308
---------------
CSession @0x0E5C0278
--------------------
m_spid = 54 m_cRef = 12 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 9 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x0E5C0040
m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x03e0 m_fBackground = 0
m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 183 m_eclClient = 5 m_protType = 6
m_hHttpToken = FFFFFFFF
m_pV7LoginRec
---------------------
00000000: 24010000 02000972 00100000 00000006 10070000 †$......r............
00000014: 00000000 e0030000 00000000 00000000 5e000a00 †................^...
00000028: 72000200 76000000 76002e00 d2000700 e0000000 †r...v...v...........
0000003C: e0001c00 18010000 18010600 0002e335 9bbc2401 †...............5..$.
00000050: 00002401 00002401 00000000 0000†††††††††††††††..$...$.......
CPhysicalConnection @0x0E5C0188
-------------------------------
m_pPhyConn->m_pmo = 0x0E5C0040 m_pPhyConn->m_pNetConn = 0x0E5C07B0 m_pPhyConn->m_pConnList = 0x0E5C0260
m_pPhyConn->m_pSess = 0x0E5C0278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 4096
m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0
CBatch @0x0E5C0AB8
------------------
m_pSess = 0x0E5C0278 m_pConn = 0x0E5C0A18 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0086B4C8
EXCEPT (null) @0x602BD1E8
-------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x02414F80
Task @0x0086B4C8
----------------
CPU Ticks used (ms) = 0 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x0
ThreadId = 0x99c m_state = 0 m_eAbortSev = 0
EC @0x0E5C1310
--------------
spid = 54 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 __fSubProc = 1
ec_dbccContext = 0x00000000 __pSETLS = 0x0E5C0A58 __pSEParams = 0x0E5C0CF8
__pDbLocks = 0x0E5C1600
SEInternalTLS @0x0E5C0A58
-------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x0086B4C8
m_activeHeapDatasetList = 0x0E5C0A58 m_activeIndexDatasetList = 0x0E5C0A60
SEParams @0x0E5C0CF8
--------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x04933A20 m_pSessionLocks = 0x0E5C1810
m_pDbLocks = 0x0E5C1600 m_execStats = 0x03A6BED8 m_pAllocFileLimit = 0x00000000

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

michaela SSCertifiable Points: 5649 More actions · Answer 1

Do you try to impersonate a login? Is your db upgraded from sql2k?

michaela SSCertifiable Points: 5649 More actions · Answer 2

Just ignore the above for now; If your view is not defined "with schema_binding" option and any table behind that view has been altered then you can run out of memory which happened in your case (error c000005 means that sql is trying to use resources that are not owned by sql)

good luck

Animal Magic SSChampion Points: 13964 More actions · Answer 3

Thanks for the reply.

i tried dropping the view, recreating with schemabinding, reassigned my permissions and still get the same error

For the first reply - i am not impersonating logins, no linked server or anything involved, purely my own db, logged in locally as SA (windows auth gives same error). It is an upgraded database yes, the compatability level has been altered to 90.

Regards

John

noeld SSC Guru Points: 96590 More actions · Answer 4

When you get an ACCESS_VIOLATION you must contact PSS.

* Noel

Ian Goethert Say Hey Kid Points: 691 More actions · Answer 5

Ian Goethert

Say Hey Kid

Points: 691

August 22, 2007 at 6:13 am

#728503

Do all your base tables have clustered indexes?

aureolin Hall of Fame Points: 3520 More actions · Answer 6

I'll go ahead and ask the dumb question: What changed between when the view was working and when it stopped?