What to do when we got the warn "Selection hierarchy.name ...is getting big and now has size" ?

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

manuek_

Hi,

We have the warning "[org.nuxeo.ecm.core.storage.sql.Selection] Selection hierarchy.name for id=... is getting big and now has size: 15000" since few weeks.

What are we supposed to do with ?

How the threshold have been choosen ? Is it a per default value or calculated with server parameters ?

When I check in the database in hierarchy table with the mentionned id, primarytype is "TaskRoot". psql=# select count(*) from hierarchy where parentid='..'; count

16410

All of them have for primarytype 'TaskDoc'. Are they all for unterminated workflows ?

Our users experiments troubles to use nuxeo (we had to stop/start it twice since yesterday as we got an error 500). Is this warning can have a relation with the difficulties and slowless observe ?

Thank you for your help

Note : We have a nuxeo 5.8.0-HF31

ben_

Hi,

This is a warning because you have more than 15k documents in a container and this might reveal a performance problem. You can get rid of this warning by using the org.nuxeo.vcs.selection.warn.threshold property using a bigger value.

But in your case may be your problem is related to this long list of workflow tasks, you need to check the state of theses tasks to see if they are unterminated or if there is a cleanup problem, see https://jira.nuxeo.com/browse/NXP-12621 and https://jira.nuxeo.com/browse/NXP-15085.

Regards

ben