Forums (Obsolete)

Member

Eric2 - 9/6/2012 9:02:43 PM

Smart Search Indexer stuck in an infinite loop

I have an document index of the type of CMS.Product using the standard analyzer and default stop words.

Any time a product document is created or edited, the indexer goes into an infinite loop.

It adds and removes 10-20 rows per second to the CMS_SearchTask table and the event log in the site manager shows a similar 10-20 entries per second in the event log with a event code of UPDATEOBJ and a of Product. The user name and document name fields for the events are always null.

The problem completely disappears if I turn off smart search in the settings.

Any idea what could be going wrong?


Kentico Support	kentico_jurajo - 9/7/2012 3:46:40 AM RE:Smart Search Indexer stuck in an infinite loop Hi, What is the exact version you are using? Are you running Kentico in a web farm environment? What happens if you try it e.g. with CMS.News document type? What kind of tasks are logged? Best regards, Juraj Ondrus

Member

Eric2 - 9/9/2012 9:45:57 PM

RE:Smart Search Indexer stuck in an infinite loop

The exact version is 6.0.21.

No webfarm, it is just running on a single server.

I created an index for CMS.News and then created some documents of that type, it didn't cause any problems.

And here is a row from the CMS_SearchTasks table (Sorry about the formatting):

SearchTaskID SearchTaskType SearchTaskObjectType SearchTaskField SearchTaskValue SearchTaskServerName SearchTaskStatus SearchTaskPriority SearchTaskCreated
221638 update cms.document _id 255;258 NULL ready 0 2012-09-09 22:30:38.853

Also, I had forgotten to mention in my first post, I have added some fields to the CMS.Product document type through the site manager.


Kentico Support	kentico_jurajo - 9/11/2012 1:49:23 AM RE:Smart Search Indexer stuck in an infinite loop Hi, Thank you for the information. What are the search settings for given fields of your document type? It is strange that the issue does not occur on a default document type - there should not be any difference though. Best regards, Juraj Ondrus

Member

Eric2 - 9/11/2012 9:16:28 PM

RE:Smart Search Indexer stuck in an infinite loop

The 4 drop downs at the top of the search fields tab for the product document are set as such:

Title field: DocumentName
Content field: DocumentContent
Image field: SKUImagePath
Date field: DocumentCreatedWhen

And here is all the fields with their types, and which columns are checked:

[ProductID] [int] IDENTITY(1,1) NOT NULL - Searchable
[ProductName] [nvarchar](440) NULL - Content, Tokenized
[DisplayNew] [int] NULL -
[DisplayPopular] [int] NULL -
[ProductShortDescription] [nvarchar](1000) NULL - Content, Tokenized
[ProductLongDescription] [nvarchar](max) NULL - Content, Tokenized
[ProductKeywords] [nvarchar](4000) NULL - Content, Searchable, Tokenized
[Searchable] [bit] NOT NULL - Searchable
[VendorName] [nvarchar](500) NOT NULL - Content, Tokenized
[VendorID] [int] NOT NULL - Searchable
[CategoryIDs] [nvarchar](4000) NULL - Searchable

Kentico Support

kentico_jurajo - 9/12/2012 7:24:54 AM

RE:Smart Search Indexer stuck in an infinite loop

Hi,

Could you please add this key into your web.config file to prevent creating the tasks for page template for each document using the template:

<add key="CMSCreateTemplateSearchTasks" value="false" />

If it won't help, could you please write us an e-mail message to our support and grant us with access to your CMS so we can inspect this issue? Thank you.

Best regards,
Juraj Ondrus