FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCH (297209)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q297209 BUG #: 31550 (PKM/SQL 2000)
Bug #: 353731
(SHILOH_BUGS) SYMPTOMS SQL Server 2000 uses the MSSEARCH service to provide full
text query functionality.
A catalog can hold one or more indexes.
The MSSEARCH service can perform insert, update and delete operations
(population) at the same time that SQL Server is performing select operations
against the catalog. When a catalog encounters inserts, updates and rank based
select queries on similar key values, a deadlock may occur.
Queries
against the catalog stop responding (hang) indefinitely and may create a
condition where all SQL Server worker threads are blocking on MSSEARCH queries
and the SQL Server appears to stop responding.
CAUSE An undetected deadlock condition when a crawl is updating,
deleting or inserting records in the catalog while rank based queries are
executing. RESOLUTIONSQL Server 2000To resolve this problem, obtain the latest
service pack for SQL Server 2000. For additional information, click the
following article number to view the article in the Microsoft Knowledge Base: 290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack A supported fix is now available from Microsoft,
but it is only intended to correct the problem that is described in this
article. Apply it only to computers that are experiencing this specific
problem. This fix may receive additional testing. Therefore, if you are not
severely affected by this problem, Microsoft recommends that you wait for the
next SQL Server service pack that contains this hotfix. To resolve this
problem immediately, contact Microsoft Product Support Services to obtain the
fix. For a complete list of Microsoft Product Support Services phone numbers
and information about support costs, visit the following Microsoft Web site: NOTE: In special cases, charges that are ordinarily incurred for
support calls may be canceled if a Microsoft Support Professional determines
that a specific update will resolve your problem. The typical support costs
will apply to additional support questions and issues that do not qualify for
the specific update in question. The English version of
this fix should have the following file attributes or later:
File name Platform
----------------------
s80287i.exe INTEL
NOTE: Due to file dependencies, the most recent hotfix or feature that
contains the preceding files may also contain additional
files. WORKAROUND Avoid full text queries while catalog population is in
progress. STATUS
This problem was first corrected in SQL Server 2000 Service Pack 1.
MORE INFORMATION SQL Server 2000 contains features for Full Text Change Notification and the CONTAINSTABLE query syntax. When the catalog population
or query is running and the notifications result in deletes and inserts on
similar keys while the rank based select queries are traversing the Tquery.dll,
MSSEARCH may encounter the deadlock condition.
| Modification Type: | Minor | Last Reviewed: | 10/7/2005 |
|---|
| Keywords: | kbBug kbfix kbQFE KB297209 |
|---|
|