I have a database with a Full Text Catalog enabled, however the Catalog hasn't updated since about 4 weeks ago.
There are no errors in the event logs, the SQL Server logs or the last SQLFT log file, which is also timestamped at the last time the Catalog updated, and has no errors in the file. The FT daemon last restarted around 6 weeks ago, and is running
The table change tracking is set to "Automatic" and Full-Text Indexing is enabled.
In the catalog, the table/column has track changes set to automatic.
Queries against the Full Text Index are returning data up to the point that the catalog was last updated, but nothing newer.
select * from sys.dm_fts_index_keywords( DB_ID('db'), OBJECT_ID('dbo.table') )
returns 198k rows of data.
DECLARE @CatalogName VARCHAR(MAX) SET @CatalogName = 'dbFullTextCatalog' -- change here ! SELECT name as FTCatalogName, DATEADD(ss, FULLTEXTCATALOGPROPERTY(@CatalogName,'PopulateCompletionAge'), '1/1/1990') AS LastPopulated ,(SELECT CASE FULLTEXTCATALOGPROPERTY(@CatalogName,'PopulateStatus') WHEN 0 THEN 'Idle' WHEN 1 THEN 'Full Population In Progress' WHEN 2 THEN 'Paused' WHEN 3 THEN 'Throttled' WHEN 4 THEN 'Recovering' WHEN 5 THEN 'Shutdown' WHEN 6 THEN 'Incremental Population In Progress' WHEN 7 THEN 'Building Index' WHEN 8 THEN 'Disk Full. Paused' WHEN 9 THEN 'Change Tracking' END) AS PopulateStatus FROM sys.fulltext_catalogs
Returns the Last populated as 4 weeks ago and the current status as Idle (0).
Any ideas what may have caused the catalog to stop updating, and what the resolution may be? This is a production system so I cannot "just restart the server"
Thanks in advance for any ideas what may be causing this!