Wednesday, 15 July 2015

SQL: How to Fix: "Word breaking timed out for full-text query string."

Issue: No resultset for any title search.

When running this query in Query Analyzer, it's returning this error message: 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.
exec p_fetch_search_results '"act"', '', 'ACT', '', 0, 2014, 0, 500, 0, 'N', 'N', 'N', 'N', ''
 
Solution:

SELECT FULLTEXTSERVICEPROPERTY('VerifySignature');
GO
-- if 1, then turn off verify_signature
EXEC sp_fulltext_service 'verify_signature', 0;
GO
 
 
 Explanation:
 If you are running the full text service on SQL Server 2005, a 45 second attempt to verify signature is performed, while your users are waiting for the full text query to return.     Since most web page timeouts are ~30 seconds, this causes the page to timeout.    See the following link, which recomends   1. Upgrade to SQL Server 2008   2. or Turn off verify signature 

No comments:

Post a Comment