MSSQLSERVER_30053

Details

Product Name

SQL Server

Product Version

11.0

Product Build Number

Event ID

30053

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

FTXT_QUERY_E_WORDBREAKINGTIMEOUT

Message Text

Word breaking timed out for the full-text query string. This can happen if the wordbreaker took a long time to process the full-text query string, or if a large number of queries are running on the server. Try running the query again under a lighter load.

Explanation

A word-breaking timeout error can occur in the following situations:

  • The word breaker for the query language is configured incorrectly; for example, its registry settings are incorrect.

  • The word breaker malfunctions for a specific query string.

  • The word breaker returns too much data for a specific query string. Excess data is treated as a potential buffer overrun attack, and shuts down the filter daemon process (fdhost.exe), which hosts the word-breaking services.

  • The filter daemon process configuration is incorrect.

    The most common configuration problems are password expiration or a domain policy that prevents the filter daemon account from logging on.

  • A very heavy query workload is running on the server instance; for example, the word-breaker took a long time to process the full-text query string, or a large number of queries are running on the server. Note that this is the least likely cause.

User Action

Select the user action that is appropriate to the probable cause of the timeout, as follows:

Probable cause

User action

The word breaker for the query language is configured incorrectly.

If you are using a third-party word breaker it might be incorrectly registered with the operating system. In this case, re-register the word breaker. For more information, see Revert the Word Breakers Used by Search to the Previous Version.

The word breaker malfunctions for a specific query string.

If the word breaker is supported by SQL Server, contact Microsoft Customer Service and Support.

The word breaker returns too much data for a specific query string.

If the word breaker is supported by SQL Server, contact Microsoft Customer Service and Support.

The filter daemon process configuration is incorrect.

Ensure that you are using the current password and that a domain policy is not preventing the filter daemon account from logging on.

A very heavy query workload is running on the server instance.

Try running the query again under a lighter load.

See Also

Reference

sp_help_fulltext_system_components (Transact-SQL)

Concepts

Set the Service Account for the Full-text Filter Daemon Launcher

Full-Text Search (SQL Server)

Configure and Manage Word Breakers and Stemmers for Search

Configure and Manage Filters for Search