MSSQL 2008 Volltext-Query-Crash

05/05/2010 - 18:05 von Chris Seidel | Report spam
Hallo,

habe einen MSSQL 2005 DB inkl. Volltext nach 2008 migriert (via restore).

Leider fkt. jetzt Volltextqueries nicht mehr in jedem Falle.

Was kann das sein? Ne EXCEPTION_ACCESS_VIOLATION in MSVCR80 is schon
ziemlich hart...


Danke

== BugCheck Dump
==
This file is generated by Microsoft SQL Server
version 10.50.1600.1
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 AMD Athlon(tm) 64 X2 Dual Core Processor 3400+.
Bios Version is Nvidia - 42302e31
Phoenix - AwardBIOS v6.00PG
2 X64 level 8664, 25 Mhz processor (s).
Windows NT 6.0 Build 6002 CSD Service Pack 2.

Memory
MemoryLoad = 58%
Total Physical = 3053 MB
Available Physical = 1268 MB
Total Page File = 6360 MB
Available Page File = 3495 MB
Total Virtual = 8388607 MB
Available Virtual = 8385265 MB
***Stack Dump being sent to
E:\tms_prog\mssql2008\MSSQL10_50.TMS_INST_2008\MSSQL\LOG\SQLDump0021.txt
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
*
*******************************************************************************
*
* BEGIN STACK DUMP:
* 05/05/10 17:43:17 spid 51
*
*
* Exception Address = 000000007401E3F0 Module(MSVCR80+000000000001E3F0)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0000000000000018
* Input Buffer 255 bytes -
* ÿÿ & ç@ ff ff 0b 00 00 00 00 01 26 04 00 00 00 e7 40 1f 09 04
* Ð d @ P 0 i n t d0 00 00 64 00 40 00 50 00 30 00 20 00 69 00 6e 00 74
* , @ P 1 d a t e 00 2c 00 40 00 50 00 31 00 20 00 64 00 61 00 74 00 65
* t i m e , @ P 2 00 74 00 69 00 6d 00 65 00 2c 00 40 00 50 00 32 00 20
* b i g i n t , @ P 00 62 00 69 00 67 00 69 00 6e 00 74 00 2c 00 40 00 50
* 3 n v a r c h a 00 33 00 20 00 6e 00 76 00 61 00 72 00 63 00 68 00 61
* r ( 4 0 0 0 ) ç 00 72 00 28 00 34 00 30 00 30 00 30 00 29 00 00 00 e7
* @ Ð @ s e l e c 40 1f 09 04 d0 00 00 40 01 73 00 65 00 6c 00 65 00 63
* t d . * f r o 00 74 00 20 00 64 00 2e 00 2a 00 20 00 66 00 72 00 6f
* m D o c u m e n 00 6d 00 20 00 44 00 6f 00 63 00 75 00 6d 00 65 00 6e
* t d , B l o b 00 74 00 20 00 64 00 2c 00 20 00 42 00 6c 00 6f 00 62
* _ b w h e r e 00 5f 00 20 00 62 00 20 00 77 00 68 00 65 00 72 00 65
* ( ( d . s t a t 00 20 00 28 00 28 00 64 00 2e 00 73 00 74 00 61 00 74
* e = @ P 0 00 65 00 20 00 3d 00 20 00 20 00 40 00 50 00 30 00 20
* ) A N D ( d . 00 29 00 20 00 41 00 4e 00 44 00 20 00 28 00 64 00 2e
* c r e a t e d > 00 63 00 72 00 65 00 61 00 74 00 65 00 64 00 20 00 3e
* = @ P 1 ) ) 00 3d 00 20 00 20 00 40 00 50 00 31 00 20 00 29 00 29
* A N D ( d . c 00 20 00 41 00 4e 00 44 00 20 00 28 00 64 00 2e 00 63
* l i e n t _ i d 00 6c 00 69 00 65 00 6e 00 74 00 5f 00 69 00 64 00 20
* = @ P 2 ) 00 3d 00 20 00 20 00 40 00 50 00 32 00 20 00 29 00 20
* a n d d . a r c 00 61 00 6e 00 64 00 20 00 64 00 2e 00 61 00 72 00 63
* R e f = b . i 00 52 00 65 00 66 00 20 00 3d 00 20 00 62 00 2e 00 69
* d a n d c o n 00 64 00 20 00 61 00 6e 00 64 00 20 00 63 00 6f 00 6e
* t a i n s ( b . d 00 74 00 61 00 69 00 6e 00 73 00 28 00 62 00 2e 00 64
* a t a , @ P 3 00 61 00 74 00 61 00 2c 00 20 00 20 00 40 00 50 00 33
* ) & 00 20 00 29 00 00 00 26 04 04 01 00 00 00
*
*
* MODULE BASE END SIZE
* sqlservr 00000000008E0000 000000000448DFFF
03bae000
* ntdll 0000000076FA0000 0000000077125FFF
00186000
* kernel32 0000000076E70000 0000000076F9CFFF
0012d000
* ADVAPI32 000007FEFDC40000 000007FEFDD47FFF
00108000
* RPCRT4 000007FEFDF60000 000007FEFE0A2FFF
00143000
* MSVCR80 0000000074000000 00000000740C8FFF
000c9000
* msvcrt 000007FEFD6E0000 000007FEFD77BFFF
0009c000
* MSVCP80 0000000073EF0000 0000000073FF8FFF
00109000
* sqlos 0000000074520000 0000000074526FFF
00007000
* Secur32 000007FEFD340000 000007FEFD35BFFF
0001c000
* pdh 000007FEFA9B0000 000007FEFA9FFFFF
00050000
* SHLWAPI 000007FEFD870000 000007FEFD8E2FFF
00073000
* GDI32 000007FEFDA50000 000007FEFDAB3FFF
00064000
* USER32 0000000076DA0000 0000000076E6CFFF
000cd000
* USERENV 000007FEFD360000 000007FEFD385FFF
00026000
* WINMM 000007FEFB320000 000007FEFB358FFF
00039000
* ole32 000007FEFD500000 000007FEFD6D7FFF
001d8000
* OLEAUT32 000007FEFDD50000 000007FEFDE22FFF
000d3000
* OLEACC 00000000750A0000 00000000750F1FFF
00052000
* IPHLPAPI 000007FEFCB00000 000007FEFCB22FFF
00023000
* dhcpcsvc 000007FEFCAB0000 000007FEFCAF4FFF
00045000
* DNSAPI 000007FEFCE10000 000007FEFCE49FFF
0003a000
* WS2_32 000007FEFF270000 000007FEFF2B3FFF
00044000
* NSI 000007FEFD4F0000 000007FEFD4F6FFF
00007000
* WINNSI 000007FEFCBE0000 000007FEFCBE9FFF
0000a000
* dhcpcsvc6 000007FEFCA70000 000007FEFCA9AFFF
0002b000
* opends60 00000000748F0000 00000000748F7FFF
00008000
* NETAPI32 000007FEFCE50000 000007FEFCEF2FFF
000a3000
* PSAPI 0000000077140000 0000000077148FFF
00009000
* BatchParser 0000000073B80000 0000000073BACFFF
0002d000
* IMM32 000007FEFDA10000 000007FEFDA3CFFF
0002d000
* MSCTF 000007FEFDE30000 000007FEFDF31FFF
00102000
* LPK 000007FEFDA40000 000007FEFDA4CFFF
0000d000
* USP10 000007FEFE150000 000007FEFE1E9FFF
0009a000
* comctl32 000007FEFC080000 000007FEFC278FFF
001f9000
* instapi10 0000000074510000 000000007451CFFF
0000d000
* cscapi 000007FEFAB60000 000007FEFAB6CFFF
0000d000
* sqlevn70 0000000073900000 0000000073B00FFF
00201000
* rsaenh 000007FEFC5A0000 000007FEFC5E7FFF
00048000
* AUTHZ 000007FEFD2D0000 000007FEFD2F5FFF
00026000
* MSCOREE 000007FEFA940000 000007FEFA9A5FFF
00066000
* CRYPT32 000007FEFCBF0000 000007FEFCD26FFF
00137000
* MSASN1 000007FEFCDA0000 000007FEFCDB8FFF
00019000
* credssp 000007FEFCAA0000 000007FEFCAA8FFF
00009000
* schannel 000007FEFC5F0000 000007FEFC645FFF
00056000
* msv1_0 000007FEFC7F0000 000007FEFC834FFF
00045000
* cryptdll 000007FEFD1F0000 000007FEFD203FFF
00014000
* kerberos 000007FEFC8E0000 000007FEFC985FFF
000a6000
* security 00000000744F0000 00000000744F3FFF
00004000
* RsFxFt 0000000073EC0000 0000000073EC8FFF
00009000
* SHELL32 000007FEFE3D0000 000007FEFF022FFF
00c53000
* ftimport 0000000060000000 0000000060024FFF
00025000
* MSFTE 0000000049980000 0000000049D2DFFF
003ae000
* VERSION 000007FEFC4D0000 000007FEFC4DAFFF
0000b000
* dbghelp 000000006EE90000 000000006EFEDFFF
0015e000
* WINTRUST 000007FEFB440000 000007FEFB478FFF
00039000
* imagehlp 000007FEFDF40000 000007FEFDF56FFF
00017000
* ncrypt 000007FEFCA20000 000007FEFCA61FFF
00042000
* dssenh 000007FEFB240000 000007FEFB273FFF
00034000
* mswsock 000007FEFC840000 000007FEFC88EFFF
0004f000
* wship6 000007FEFC8D0000 000007FEFC8D6FFF
00007000
* wshtcpip 000007FEFC2F0000 000007FEFC2F6FFF
00007000
* NTMARTA 000007FEFC520000 000007FEFC54BFFF
0002c000
* WLDAP32 000007FEFD780000 000007FEFD7D4FFF
00055000
* SAMLIB 000007FEFCDC0000 000007FEFCDDBFFF
0001c000
* ntdsapi 000007FEFCD70000 000007FEFCD95FFF
00026000
* apphelp 000007FEFD280000 000007FEFD2B4FFF
00035000
* dbghelp 0000000066740000 000000006689DFFF
0015e000
*
* P1Home: 000000000D34A700: 00000000C0000005 0000000000000000
000000007401E3F0 FFFFF6FB00000002 00000000
00000000 0000000000000018
* P2Home: 000000000D34A888: 0000000000000003 0000000000000000
0000000000000000 0000000000000000 00000000
0D34A8C8 00000000824372B0
* P3Home: FFFFFA8000000000:
* P4Home: 00000000008E0000: 0000000300905A4D 0000FFFF00000004
00000000000000B8 0000000000000040 00000000
00000000 0000000000000000
* P5Home: 0000000000000000:
* P6Home: 0000000000000000:
* ContextFlags: 000000000010001F: 0007FEFCBF000000 0007FEFCBF11E000
0000000013700000 0000000040003E00 000000
000ED3E000 0000000018001600
* MxCsr: 0000000000001FA0:
* SegCs: 0000000000000033:
* SegDs: 000000000000002B:
* SegEs: 000000000000002B:
* SegFs: 0000000000000053:
* SegGs: 000000000000002B:
* SegSs: 000000000000002B:
* EFlags: 0000000000010283: 0000000000000000 0000000000000000
0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* Rax: 0000000081CE0560: 0000000000000000 0000000000000000
0000000000B5B1F0 0000000000000000 00000000
00040038 00000000822308F0
* Rcx: 000000000D34A8A8: 000000000D34A8C8 00000000824372B0
0000000001A5A297 0000000082437040 00000000
8242AD90 0000000081CDE060
* Rdx: FFFFFFFFF2CB5778:
* Rbx: 000000000D34A888: 0000000000000003 0000000000000000
0000000000000000 0000000000000000 00000000
0D34A8C8 00000000824372B0
* Rsp: 000000000D34A7C8: 0000000001D6D746 0000000081CDE060
00000000008E7836 0000000000000140 00000000
81CDE060 0000000000000000
* Rbp: 000000008242AD90: 0000000000BA7D60 0000000000000001
0000000081CE2060 0000000000000001 00000000
00000000 0000000081CE2060
* Rsi: 0000000000000001:
* Rdi: 0000000082437040: 0000000081CDE060 0000000200000001
0000000700000007 0000000003317E3D 00000000
00000001 00000000824371F0
* R8: 0000000000000020:
* R9: 0000000000000001:
* R10: 00000000008E6C60: 0000000002DF7674 00000000008EB338
00000000008EB2D8 0000000002DA4F88 00000000
02DA4160 0000000002DA4F7C
* R11: 000000000D34A888: 0000000000000003 0000000000000000
0000000000000000 0000000000000000 00000000
0D34A8C8 00000000824372B0
* R12: 0000000000000000:
* R13: 0000000000000001:
* R14: 0000000000000000:
* R15: 000000008241F520: 0000000001B96BC0 0000000000000001
0000000081CE2060 0000000000000000 00000000
00000000 0000000081CE33D0
* Rip: 000000007401E3F0: 548B4CF80A448B48 894820E98348F00A
8B481051894C1841 490A148B4C080A44 894C0841
8948C9FF E91FE08349D57511
*
*******************************************************************************
*
-
* Short Stack Dump
000000007401E3F0 Module(MSVCR80+000000000001E3F0)
0000000001D6D746 Module(sqlservr+000000000148D746)
0000000001DFAF5B Module(sqlservr+000000000151AF5B)
0000000001A5B867 Module(sqlservr+000000000117B867)
000000000220202A Module(sqlservr+000000000192202A)
0000000000B62025 Module(sqlservr+0000000000282025)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B62006 Module(sqlservr+0000000000282006)
0000000000B620A6 Module(sqlservr+00000000002820A6)
0000000000B5E853 Module(sqlservr+000000000027E853)
0000000000B5DA30 Module(sqlservr+000000000027DA30)
0000000000BF6AFC Module(sqlservr+0000000000316AFC)
0000000000ABE606 Module(sqlservr+00000000001DE606)
0000000000ABF85E Module(sqlservr+00000000001DF85E)
0000000000ABFE19 Module(sqlservr+00000000001DFE19)
0000000000ABFCBF Module(sqlservr+00000000001DFCBF)
000000000093B203 Module(sqlservr+000000000005B203)
0000000001DA00DD Module(sqlservr+00000000014C00DD)
0000000001DA56B3 Module(sqlservr+00000000014C56B3)
0000000001DA5BBB Module(sqlservr+00000000014C5BBB)
000000000093C1A6 Module(sqlservr+000000000005C1A6)
000000000092CD34 Module(sqlservr+000000000004CD34)
00000000008EBBD8 Module(sqlservr+000000000000BBD8)
00000000008EB8BA Module(sqlservr+000000000000B8BA)
00000000008EB6FF Module(sqlservr+000000000000B6FF)
0000000000E08FB6 Module(sqlservr+0000000000528FB6)
0000000000E09175 Module(sqlservr+0000000000529175)
0000000000E09839 Module(sqlservr+0000000000529839)
0000000000E09502 Module(sqlservr+0000000000529502)
00000000740037D7 Module(MSVCR80+00000000000037D7)
0000000074003894 Module(MSVCR80+0000000000003894)
0000000076E8BE3D Module(kernel32+000000000001BE3D)
0000000076FC6A51 Module(ntdll+0000000000026A51)

CSession @0x000000008075C3B0
-
m_spid = 51 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 = 0x000000008075C080
m_pstackBhfPool = 0x0000000081AF2EF0 m_dwLoginFlags = 0x03e0
m_fBackground = 0
m_eConnResetOption = 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 = 346 m_eclClient = 4
m_protType = 5
m_hHttpToken = FFFFFFFFFFFFFFFF

m_pV7LoginRec

0000000000000000: a4000000 01000071 00100000 07000000 7b000000
†¤..q{...

0000000000000014: 00000000 e0030000 00000000 00000000 5e000900
†à...^. .

0000000000000028: 70000300 76000000 7c000400 84000900 00000000
†p...v...|...„. .

000000000000003C: 96000400 9e000000 9e000300 00000000 0000a400
†–...ž...ž.¤.

0000000000000050: 0000a400 00000000 00000000
0000†††††††††††††††..¤...




CPhysicalConnection @0x000000008075C270

m_pPhyConn->m_pmo = 0x000000008075C080
m_pPhyConn->m_pNetConn = 0x000000008075CAD0
m_pPhyConn->m_pConnList = 0x000000008075C380
m_pPhyConn->m_pSess = 0x000000008075C3B0
m_pPhyConn->m_fTracked = -1
m_pPhyConn->m_cbPacketsize = 4096 m_pPhyConn->m_fMars = 0
m_pPhyConn->m_fKill = 0


CBatch @0x000000008075CFA0
m_pSess = 0x000000008075C3B0 m_pConn = 0x000000008075CEA0
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 = 0x000000008064C088


EXCEPT (null) @0x000000000D3475F8

exc_number = 0 exc_severity = 0
exc_func = 0x0000000002DCE37C



Task @0x000000008064C088

CPU Ticks used (ms) = 0 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x0000000000000000
WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x0000000000000000
SchedulerId = 0x0
ThreadId = 0xf94 m_state = 0
m_eAbortSev = 0



EC @0x0000000081AF23F0
-
spid = 0 ecid = 0
ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0
__fSubProc = 1
__pSETLS = 0x000000008075CF10 __pSEParams = 0x000000008075D350

SEInternalTLS @0x000000008075CF10

m_flags = 0 m_TLSstatus = 3
m_owningTask = 0x000000008064C088
m_activeHeapDatasetList = 0x000000008075CF10
m_activeIndexDatasetList = 0x000000008075CF20
m_pDbccContext = 0x0000000000000000


SEParams @0x000000008075D350
-
m_lockTimeout = -1 m_isoLevel = 4096
m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x0000000080894B50
m_pSessionLocks = 0x0000000081AF2D30
m_pDbLocks = 0x000000008075D860
m_execStats = 0x000000008041B3C0 m_pAllocFileLimit =
0x0000000000000000
 

Lesen sie die antworten

#1 Elmar Boye
05/05/2010 - 22:48 | Warnen spam
Hallo Chris,

"Chris Seidel" schrieb ...
habe einen MSSQL 2005 DB inkl. Volltext nach 2008 migriert (via restore).

Leider fkt. jetzt Volltextqueries nicht mehr in jedem Falle.

Was kann das sein? Ne EXCEPTION_ACCESS_VIOLATION in MSVCR80 is schon ziemlich hart...



auch nicht hàrter als anderes... ;-)

Da es sich um SQL Server 2008 R2 handelt solltest Du einen Support Case
bei Microsoft aufmachen.

Ansonsten: Wenn der Hauptverursacher die Volltextsuche ist,
wàre ein Neuaufbau des Volltextkataloges zu überlegen.

Gruß Elmar

Ähnliche fragen