new records aren't being added to ft catalog (sql 2005 ee)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sql411@nospam.com - 28 Dec 2007 00:53 GMT

Hi all,
I have multiple full-text catalogs on about 8 tables (sql server 2005 ee -
all varchar(max)).

A few days ago, they all went to an idle status and won't start picking up
any new changes - all catalogs are auto update.

when i say 'idle' - mean :
objectpropertyex ( [table object_id] , 'TableFulltextPopulateStatus' ) = 0
objectpropertyex ( [catalog_id] , PopulateStatus) = 0

and
objectpropertyex ( table object_id , 'TableFulltextItemCount' ) shows that
there are many rows missing from the table so there is much work to be done.

i have seen this once before and ended up doing a rebuild but I hope to
avoid that this time around as it takes several days to rebuild all catalogs.

Has anyone seen anything similar to this or have any suggestions for the
full-text catalog to start 'picking back up' the auto changes?

Many thanks,
Robert Towne

Reply to this Message

Hilary Cotter - 28 Dec 2007 12:29 GMT

check the full text logs, they can be found in C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\LOG and will look like SQLFT0005600015.log

Signature

http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi all,
> I have multiple full-text catalogs on about 8 tables (sql server 2005 ee -
[quoted text clipped - 21 lines]
> Many thanks,
> Robert Towne

Reply to this Message

sql411@nospam.com - 28 Dec 2007 17:06 GMT

Thanks, Hilary. I checked the logs initially and only saw a pause (from
backup) and resume (backup finished). it was weird because it happened
across all full-text catalogs - i could still do a contains search but they
just were idle as far as adding new records.

I did a reboot and that cleared it up. (I was hoping to avoid the reboot as
we are always doing business and it is difficult to get a maintenance period).

Thanks again,
robert

Reply to this Message