Version:
\nMicrosoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)<\/p>\n
Problem:<\/strong> 2012-07-17 18:34:26.04 spid25s Error ‘0x80043630: The filter daemon process MSFTEFD timed out for an unknown reason. This may indicate a bug in a filter, wordbreaker, or protocol handler.’ occurred during full-text index population for table or indexed view ‘[TS_MageDB].[dbo].[IndexTable]’ (table or indexed view ID ‘667201477’, database ID ‘7’), full-text key value ‘1986286701’. Attempt will be made to reindex it.<\/em><\/p>\n This was happening during the 9 days (and haven’t been large load on the CPU and \/ or queuing to disk.), and full-text index has not been populated.<\/p>\n There is nothing helpful for me here<\/a> (because of 2008 R2, not 2008) and here<\/a> (just “We have therefore resolve this issue as by design”)<\/p>\n Resolution:<\/strong> or, if we want to start populating manually\u00a0later, for example, at night:<\/p>\n and for start:<\/p>\n After a half-day process is finished, the error no longer appeared.<\/p>\n","protected":false},"excerpt":{"rendered":" 2014-05-31 11:09:30<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-83","post","type-post","status-publish","format-standard","hentry","category-s-sql-server-en"],"_links":{"self":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/83","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=83"}],"version-history":[{"count":7,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/83\/revisions"}],"predecessor-version":[{"id":472,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/83\/revisions\/472"}],"wp:attachment":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=83"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=83"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=83"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nThere is a full-text index on the table IndexTable (about 3 billion rows).
\nWhen start populating getting a lot of errors in the full text log:<\/p>\n
\nOnly recreating the index helped, and, after that, populating:<\/p>\nDROP FULLTEXT INDEX ON [dbo].[IndexTable]\nCREATE FULLTEXT INDEX ON [dbo].[IndexTable]( [IndexValue] LANGUAGE [Russian])\nKEY INDEX [PK_IndexTable] ON ([FT_IndexTeble], FILEGROUP [ftfg_FT_IndexTeble])\nWITH (CHANGE_TRACKING = OFF, STOPLIST = SYSTEM)<\/pre>\n
...CHANGE_TRACKING = OFF, NO POPULATION...<\/code><\/pre>\nALTER FULLTEXT INDEX ON [dbo].[IndexTable] START FULL POPULATION<\/code><\/pre>\n