We are seeing an issue where the majority of a our lists counts now just show counts of "pending". 1 out of 10 refreshes will shows 50% of the lists with counts but with another refresh almost all go back to a count of "Pending". indexer shows no errors, xConnect shows no errors. Any thoughts on what is going on?
-
this error appear when the xConnect doesn't work as expected, have a look on searchIndexer logs– Vlad IobagiuDec 24, 2021 at 3:33
-
We have. In the last 24 hours we have only gotten one error. "Failed indexing next set of changes. There will be an attempt to recover from the failure." This all started happening after a rebuild of the xDb index was canceled though. I would not think that would have this effect though since it was canceled so, in turn, the rebuild index is not being used.– ToddBDec 24, 2021 at 15:57
1 Answer
This is caused by a combination of a couple of things.
- A large xDB contact database (60+ million).
- The need to execute a segmentation rule against that database.
- The need to execute a lot of segmentation rules at the same time (because you are looking at a list of segmentation lists so the rule has to run for all it is trying to show in the UI).
All this together means the system (SOLR) cannot execute and return the counts of all the lists with their segmentation rules applied fast enough to provide a count to the UI. So far the only answer has been a smaller database or bigger hardware.