November Happy Hour will be moved to Thursday December 5th.

Epi find seems to be stuck in delete loop

Vote:
 

Hi, 
We try to use find, but we encourter issues.  After we delete quete a few articles (abuot 300), find tries to remove them from index, but seems to be stuck. 
The error log shows this:


EPiServer.Find.ServiceException: The remote server returned an error: (429) Too Many Requests.
Too many requests ---> System.Net.WebException: The remote server returned an error: (429) Too Many Requests.
at System.Net.HttpWebRequest.GetResponse()
at EPiServer.Find.Connection.JsonRequest.GetResponseStream()
at EPiServer.Find.Api.Command.GetResponse[TResult](IJsonRequest request)
--- End of inner exception stack trace ---
at EPiServer.Find.Api.Command.GetResponse[TResult](IJsonRequest request)
at EPiServer.Find.Api.DeleteByQueryCommand.Execute()
at EPiServer.Find.Cms.ContentIndexer.RemoveFromIndex(ContentReference contentLink, Boolean cascade, String language)
at EPiServer.Find.Cms.ContentEventIndexer.IndexPageQueue()

And this is repeaten infinitely. It looks that find tries to delete ittems from index, fails, retries, fails and so on.

What could be wrong here?

Find version is 12.2.4

Cms version is 9.12.2

Regards,

#179473
Edited, Jun 13, 2017 14:49
Vote:
 

Try to query this view (can't remember the one that Find use), do you have a lot of rows there?

Select *
From [dbo].[VW_EPiServer.Find.Cms.IndexingQueueReference]


 

#179479
Jun 13, 2017 15:34
Vote:
 

Hi,
I have abuot 600 items in there.

#179480
Jun 13, 2017 15:39
Vote:
 

It should be empty (at least it is that on the sites I tested it on where we are indexeing)

If you dare (not supported from Episerver and not supported by me and you MUST take a backup of the database first) you can run this query to delete the items from the queue and after that run the reindex job

Delete R01
from [tblBigTable] as R01 
inner join tblBigTableIdentity as [Identity] on R01.pkId=[Identity].pkId 
where R01.StoreName='EPiServer.Find.Cms.IndexingQueueReference' and R01.Row=1
#179481
Jun 13, 2017 15:50
Vote:
 

Hi, 
This fixes the problem temporarily until the next delete, then the probleam appears again.
It looks like an bug in episrever find to me

#179498
Jun 14, 2017 7:35
Vote:
 

Also we have multiplew servers, and all three seems to be trying to empty this queue. This probably amplifies the problem

#179499
Jun 14, 2017 7:46
Vote:
 

Hi Giedrius,

Since you are on Find 12.2.4 there are a couple of issues that could give you this problem

The first one could cause these HTTPS 404 in the first place

(Fixed in EPiServer.Find 12.3.1)

http://world.episerver.com/documentation/Release-Notes/ReleaseNote/?releaseNoteId=FIND-1468

And this second could cause items (on exceptions and errors) get stuck in the queue permanently which would cause them to be processed more than once

(Fixed in EPiServer.Find 12.4.0)

http://world.episerver.com/documentation/Release-Notes/ReleaseNote/?releaseNoteId=FIND-2087

So please evaluate latest version of Find.

#179622
Jun 16, 2017 14:09
Vote:
 

Hi,
It's easy to say that, but we are using episerver 9 currenly, so cannot go to any newer version.

#179623
Jun 16, 2017 14:17
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.