September 11, 2017 at 1:08 pm
Hi,
on a prod system (SQL 2016 SP1, two VMs, AlwaysOn Availibilty Groups) fulltext stops the crawl process after a failover. I don't see any error in logs, sys.fulltext_indexes shows for has_crawl_completed = 0. Fulltext search still working for old records but not for new/updated records.
My first thought was that this is an issue with AlwaysOn. I tried to reproduce it on a similar test environment and restored the prod database. Before I added the database to AlwaysOn I changed a record and try to find it with my contains(*,'"something"') query. But I see now the same issue without AlwaysOn. Fulltext crawl process started but do nothing. Nothing helped (drop fulltext, recreate, restart fulltext service), only the restart of SQL Server worked for me. Crawl process was successful and I was able to search for my record.
Anyone had a similar issue?
thanks for hints
Alex
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply