Hi everyone

I'm resigned to post my problem here cause I'm a bit disappointed by the domain I'm dealing with. I will describe you the problem, which occurs on a recent powerfull DNN-dedicated webserver.

My website is not so huge, it has 230 pages, 4000 articles managed with NewsArticles, a few custom modules which produces something like 3000 other item to index. I'm using the default Dnn Search provider.

A few days ago I remarked that most of the scheduled re-index jobs were still running from Dnn point-of-view (their duration were still growing even after app_restart). I decided so to have a look, and stopped them mannually from the DB. I disabled the scheduled task, and emptied the index tables with a simple DELETE script. Then I went to the Host > Search tab, defined the max-word-lenght to 35, min-word-lenght to 6, without indexing the common words, and without indexing the numbers, then click on re-index the website.

In the same time, I've setup a few line of SQL script in order to see what's happening SQL side.

SELECT COUNT(*) as TotalIndexedItems FROM [dbo].[SearchItem]
SELECT COUNT(*) as IndexItemsWithoutArticles FROM [dbo].[SearchItem] WHERE [Guid] NOT LIKe '%article%'
SELECT COUNT(*) as IndexedArticles FROM [dbo].[SearchItem] WHERE [Guid] LIKe '%article%'
SELECT COUNT(*) as TotalArticles FROM [dbo].[DnnForge_NewsArticles_Article] WHERE IsApproved = 1 and IsDraft = 0
SELECT COUNT(*) as ItemWords FROM [dbo].[SearchItemWord]
SELECT COUNT(*) as ItemWordsPosition FROM [dbo].[SearchItemWordPosition]
SELECT COUNT(*) as Words FROM [dbo].[SearchWord]

The re-indexing task never finished from the web brower point of view, but ended after a few second SQL side (between 2 and 4 minutes).
I runned it several times, and it stops randomly while inserting the items to index or inserting the words to index, in the middle of the articles indexation.

I first thought that it could be related to NewsArticles ISearchable interface, but it's not, as GetsearchItems end successfully from the dnn library side when I am in debug on dnn library.

By the way, while in debug on the DNN library, the re-index task launched from Hosts ends-up successfully. The scheduled task ends successfully too. (15000 indexed items, 30967 words, 182926 ItemWords and 450000 itemWordPos.)

Why when I am in release (whatever the DLLs are debug or release compiled), why the re-index task stops in nowhere ?

Any help would be much appreciated, I'm running out of arguments.

Cheers,

S.F.

Thank you for your answer Sebastian. Is there is a way to correct the search indexer without waiting for 5.2 ? Do you know when the 5.2 should be released ? :)

Cheers,

Sébastien

5.2.0 does'nt solve my case, the indexing job never finish client side and stop after a few seconds sql side (not all my articles are inserted in Indexed-Items, and the indexing job stop in the middle of the article list).

Cheers,

S.F.