Hi,

On my current project we have really annoying issue with master merge process that occurs after Full Population of FTS Index.

Let me describe our process: we have continuous build that setup environment and run unit tests after each commit in our source control. For each run we create new DB (on the same SQL Server) then fill it with test data and run unit tests. Sometimes unit tests failed because FTS Index population cannot finish in time.

We have constantly seeing in [sysprocesses] table lots of sessions with wait type FT_MASTER_MERGE that block our tests

In FTS log we have following error:

The master merge started at the end of the full crawl of table or indexed view [TABLENAME] failed with HRESULT = '0x80000049'. Database ID is '45', table id is 706101556, catalog ID: 5.

Here is an example of how we create FTS catalog and add table to it (As you can see it's created with auto change tracking together with index update in background):

-- Create FTS catalog
EXEC sp_fulltext_catalog 'WilcoFTSCatalog', 'create'
EXEC sp_fulltext_table 'Users', 'create', 'WilcoFTSCatalog', 'PK_Users'
EXEC sp_fulltext_column 'Users', 'UserId', 'add'
EXEC sp_fulltext_column 'Users', 'Name', 'add'
EXEC sp_fulltext_table 'Users', 'activate'
EXEC sp_fulltext_table 'Users', 'start_change_tracking'
EXEC sp_fulltext_table 'Users', 'start_background_updateindex'

Does anybody know what is the root cause of this issue and what should be done to avoid it?

Thank you in advance,

Olena Smoliak

• Edited by Olena Smoliak Wednesday, April 29, 2015 4:21 PM
• Moved by Olaf HelperMVP Wednesday, April 29, 2015 5:49 PM Moved from "Database Engine" to a more specific forum for a better response.

This link may be a little help.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7e9e00b1-4bfa-4a50-83e6-984ebd322d5e/full-text-crawl-metrics?forum=sqlsearch

• Edited by HoroChan 5 hours 43 minutes ago