SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


FullText Catalog Rebuild never finishes


FullText Catalog Rebuild never finishes

Author
Message
Vishwas Apte
Vishwas Apte
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 9
G'day all,

I have a strange problem with SQL Server 2005 and Full text indexing. My database schema has couple of indexes included in the full text catalog. There aren't too many records in these index (total under 100,000)

After running the SQL Server instance for some time, say few days to a couple of weeks, all commands that insert or update data in the table with fulltext index starts timing out. On checking lock information, the transaction is waiting for a processid 22 to release a lock. The processid 22 points to a MSSEARCH process. This process seems to be running for really long time.

I tried running ALTER FULLTEXT CATALOG XXX REBUILD from SQL Management Studio. This command takes forever and never finishes. The index table is defined with background update of tracked changes.

After I restart SQL Server 2005 instance and then immediately run ALTER FULLTEXT CATALOG XXX REBUILD, it completes with in few seconds. But fails to complete again after few days.

Has anyone experienced this problem before? Any resolution. It is not possible to restart SQL Server in 24x7 production environment.

Thanks,
V
nathan-1022843
nathan-1022843
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 16
I'm having this problem too - did you find a solution? Currently, the only (temporary) solution I've found is to restart the full text windows service, but that only resolves the lock temporarily.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search