Error 3624 When Trying to Drop a Fulltext Catalog
Hi,
Maybe you are able to help me with the following issue.
Approximately one year ago we created a new database on a SQL 2005 server with a fulltext catalog. Everything worked just fine. Since around two weeks, however, the backup fails with an error message telling us that the fulltext catalog (FTC) is not online.
In consequence we first tried to re-create the FTC, but this action loops endlessly. Next we tried to drop the FTC but got the following messages (from the log):
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
Error: 3624, Severity: 20, Status: 1.
SQL Server Assertion: File: <fulltext.cpp>, line=2369 Failed Assertion = 'm_DropLSN == NullLSN'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Error: 17066, Severity: 16, Status: 1.
External dump process return code 0x20002001.
The error information has been submitted to Watson error reporting.
Stack Signature for the dump is 0x23F1D3D3
This is the stack dump:
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.4262.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 INTEL - 6040000
PhoenixBIOS 4.0 Release 6.0
Current time is 21:09:54 11/09/09.
2 Intel x86 level 6, 1995 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.
Memory
MemoryLoad = 91%
Total Physical = 2559 MB
Available Physical = 229 MB
Total Page File = 4967 MB
Available Page File = 2286 MB
Total Virtual = 2047 MB
Available Virtual = 138 MB
**Dump thread - spid = 53, PSS = 0x4BE37338, EC = 0x4BE37340
***Stack Dump being sent to C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0047.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 11/09/09 21:09:54 spid 53
*
* Location: fulltext.cpp:2369
* Expression: m_DropLSN == NullLSN
* SPID: 53
* Process ID: 1836
*
* Input Buffer 256 bytes -
* IF EXISTS (SELECT * FROM sysfulltextcatalogs ftc WHERE ftc.n
* ame = N'RZB_intern') DROP FULLTEXT CATALOG [RZB_intern]
*
*
* MODULE BASE END SIZE
* sqlservr 01000000 02C24FFF 01c25000
* ntdll 7C920000 7C9E7FFF 000c8000
* kernel32 7C800000 7C914FFF 00115000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77B70000 77BC9FFF 0005a000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77F30000 77FDBFFF 000ac000
* RPCRT4 77C20000 77CBEFFF 0009f000
* Secur32 76E40000 76E52FFF 00013000
* sqlos 344D0000 344D4FFF 00005000
* USERENV 76810000 768D3FFF 000c4000
* USER32 77E20000 77EB1FFF 00092000
* GDI32 77BD0000 77C18FFF 00049000
* WINMM 76990000 769BDFFF 0002e000
* opends60 333E0000 333E6FFF 00007000
* NETAPI32 71A50000 71AA6FFF 00057000
* IMM32 76180000 7619CFFF 0001d000
* psapi 76A60000 76A6AFFF 0000b000
* instapi 48060000 48069FFF 0000a000
* sqlevn70 4F610000 4F814FFF 00205000
* sqlevn70 007E0000 00988FFF 001a9000
* rsaenh 68000000 68034FFF 00035000
* AUTHZ 76B30000 76B43FFF 00014000
* MSCOREE 33E10000 33E55FFF 00046000
* ole32 774F0000 77628FFF 00139000
* msv1_0 76B80000 76BA6FFF 00027000
* cryptdll 765D0000 765DBFFF 0000c000
* WS2_32 71A10000 71A26FFF 00017000
* WS2HELP 71A00000 71A07FFF 00008000
* iphlpapi 76BE0000 76BF9FFF 0001a000
* kerberos 34240000 34298FFF 00059000
* MSASN1 342A0000 342B1FFF 00012000
* schannel 76640000 76667FFF 00028000
* CRYPT32 342D0000 34364FFF 00095000
* COMRES 76F00000 77092FFF 00193000
* XOLEHLP 343B0000 343B5FFF 00006000
* MSDTCPRX 343C0000 34438FFF 00079000
* OLEAUT32 77CD0000 77D5AFFF 0008b000
* msvcp60 34440000 344A4FFF 00065000
* MTXCLU 344B0000 344C8FFF 00019000
* VERSION 77B60000 77B67FFF 00008000
* WSOCK32 719C0000 719C9FFF 0000a000
* CLUSAPI 62250000 62261FFF 00012000
* RESUTILS 62270000 62282FFF 00013000
* FwcWsp 622A0000 622D4FFF 00035000
* mswsock 71930000 71971FFF 00042000
* DNSAPI 76DC0000 76DEAFFF 0002b000
* winrnr 76E60000 76E66FFF 00007000
* WLDAP32 76E00000 76E2EFFF 0002f000
* hnetcfg 62440000 6249AFFF 0005b000
* wshtcpip 718F0000 718F7FFF 00008000
* rasadhlp 76E70000 76E74FFF 00005000
* security 62920000 62923FFF 00004000
* SHELL32 7C9F0000 7D1F8FFF 00809000
* SHLWAPI 77EC0000 77F11FFF 00052000
* comctl32 77340000 77442FFF 00103000
* msfte 62FF0000 63249FFF 0025a000
* dbghelp 63250000 63364FFF 00115000
* WINTRUST 76AA0000 76ACAFFF 0002b000
* imagehlp 76B00000 76B27FFF 00028000
* dssenh 68100000 68126FFF 00027000
* NTMARTA 77790000 777B0FFF 00021000
* SAMLIB 7E020000 7E02EFFF 0000f000
* ntdsapi 765E0000 765F3FFF 00014000
* xpsp2res 63770000 63A48FFF 002d9000
* CLBCatQ 77630000 776B2FFF 00083000
* sqlncli 63A50000 63C77FFF 00228000
* COMCTL32 77D70000 77E06FFF 00097000
* comdlg32 761A0000 761E9FFF 0004a000
* SQLNCLIR 00780000 007B2FFF 00033000
* msftepxy 636B0000 636C4FFF 00015000
* xpsqlbot 64360000 64365FFF 00006000
* xpstar90 64380000 643CBFFF 0004c000
* SQLSCM90 643E0000 643E8FFF 00009000
* ODBC32 64400000 6443CFFF 0003d000
* BatchParser90 64440000 6445EFFF 0001f000
* ATL80 7C630000 7C64AFFF 0001b000
* odbcint 645B0000 645C8FFF 00019000
* xpstar90 645D0000 645F6FFF 00027000
* xplog70 64600000 6460BFFF 0000c000
* xplog70 64620000 64623FFF 00004000
* msxmlsql 64940000 64A14FFF 000d5000
* msxml2 64A20000 64ACEFFF 000af000
* msxml3 64AD0000 64BE6FFF 00117000
* mscorwks 65CF0000 6627FFFF 00590000
* mscorlib.ni 66570000 67066FFF 00af7000
* mscorsec 67100000 67112FFF 00013000
* cryptnet 67130000 67141FFF 00012000
* SensApi 67150000 67154FFF 00005000
* SqlAccess 67460000 674B5FFF 00056000
* mscorjit 674C0000 6751AFFF 0005b000
* System.Data 67BE0000 67EB3FFF 002d4000
* System.ni 6B750000 6BED4FFF 00785000
* System.Transactions 67690000 676D2FFF 00043000
* System.Security.ni 67850000 678F8FFF 000a9000
* System 6BEE0000 6C1E3FFF 00304000
* System.Security 67F50000 67F91FFF 00042000
* System.Xml 6C1F0000 6C3E7FFF 001f8000
* System.Configuration 6C410000 6C47BFFF 0006c000
* peverify 6D7A0000 6D7C3FFF 00024000
* rasapi32 76D80000 76DBEFFF 0003f000
* rasman 76D30000 76D41FFF 00012000
* TAPI32 76D50000 76D7EFFF 0002f000
* rtutils 76D20000 76D2BFFF 0000c000
* dbghelp 6DC50000 6DD64FFF 00115000
*
* Edi: 640CD218: 6735FAC0 640CD22C 0158C134 640CD30C 00000001 640CE01C
* Esi: 00000000:
* Eax: 640CD0FC: 000042AC 00000000 00000000 7C80BEF7 00000000 7C947739
* Ebx: 0000003F:
* Ecx: 640CD76C: 00000000 00010007 00000000 00880086 6735FAC4 640CD12C
* Edx: 0000003D:
* Eip: 7C80BEF7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
* Ebp: 640CD14C: 640CD190 021B2C8C 000042AC 00000000 00000000 00000000
* SegCs: 7813001B: 00000000 00000000 00000000 00000000 00000000 00000000
* EFlags: 00000246:
* Esp: 640CD0F8: 4BE37338 000042AC 00000000 00000000 7C80BEF7 00000000
* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
7C80BEF7 Module(kernel32+0000BEF7)
021B2C8C Module(sqlservr+011B2C8C)
021B6BA0 Module(sqlservr+011B6BA0)
02053ABA Module(sqlservr+01053ABA)
0233F831 Module(sqlservr+0133F831)
01AA0806 Module(sqlservr+00AA0806)
012F4F46 Module(sqlservr+002F4F46)
013FB63C Module(sqlservr+003FB63C)
0140535A Module(sqlservr+0040535A)
010244B8 Module(sqlservr+000244B8)
0103E1E5 Module(sqlservr+0003E1E5)
0103AACB Module(sqlservr+0003AACB)
01008D8D Module(sqlservr+00008D8D)
01008EB3 Module(sqlservr+00008EB3)
01008BC3 Module(sqlservr+00008BC3)
0146BF50 Module(sqlservr+0046BF50)
0146BE70 Module(sqlservr+0046BE70)
0146B920 Module(sqlservr+0046B920)
0146BABD Module(sqlservr+0046BABD)
781329BB Module(MSVCR80+000029BB)
78132A47 Module(MSVCR80+00002A47)PSS @0x4BE37338
---------------CSession @0x4BE36278
--------------------
m_spid = 53 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 = 0x4BE36040
m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x83e0 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 = 1103557 m_eclClient = 5 m_protType = 6
m_hHttpToken = FFFFFFFFm_pV7LoginRec
---------------------
00000000: 55010000 03000a73 00100000 00000006 68070000 †U......s........h...00000014: 00000000 e0830000 00000000 00000000 5e000600 †................^...
00000028: 00000000 00000000 6a003000 ca000600 d6000000 †........j.0.........
0000003C: d6001c00 0e010000 0e010a00 000c2922 f1782201 †..............)".x".
00000050: 33005501 00005501 00000000 0000†††††††††††††††3.U...U.......
CPhysicalConnection @0x4BE36188
-------------------------------
m_pPhyConn->m_pmo = 0x4BE36040 m_pPhyConn->m_pNetConn = 0x4BE367B0 m_pPhyConn->m_pConnList = 0x4BE36260
m_pPhyConn->m_pSess = 0x4BE36278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 4096
m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0CBatch @0x4BE36AB8
------------------
m_pSess = 0x4BE36278 m_pConn = 0x4BE36A18 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 = 0x009FAE38
EXCEPT (null) @0x640CCA0C
-------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x02428280Task @0x009FAE38
----------------
CPU Ticks used (ms) = 11 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x0
ThreadId = 0xcd4 m_state = 0 m_eAbortSev = 0EC @0x4BE37340
--------------
spid = 53 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 __fSubProc = 1
ec_dbccContext = 0x00000000 __pSETLS = 0x4BE36A58 __pSEParams = 0x4BE36CF8
__pDbLocks = 0x4BE37828SEInternalTLS @0x4BE36A58
-------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x009FAE38
m_activeHeapDatasetList = 0x4BE36A58 m_activeIndexDatasetList = 0x4BE36A60
SEParams @0x4BE36CF8
--------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x03CD3430 m_pSessionLocks = 0x4BE37A38
m_pDbLocks = 0x4BE37828 m_execStats = 0x04071950 m_pAllocFileLimit = 0x00000000
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DBCC CHECKDB does not result in any errors.
I found a report where the same error occured after a database had been migrated from SQL Server 2000 to SQL Server 2005. This, however, is not the case here, this database was created on SQL Server 2005 and was never transfered to any other place.
This is the environment everything runs in:
Windows Server 2003 SE
SQL Server 2005 SE
Any hints, tips, and tricks are welcome.
Best regards, Dietmar.
All Replies
- Are you able to view or drop the full-text indexes associated with the full-text catalogue? If you look at the properties of the full-text catalogue you should see the associated indexes. It may not be the right road to go down, but I'm curious if it will give you any more insight.
