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

[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

[manuek_]

Hi,

[ben_]

Hi,

[manuek_]

This answer deleted to go in the Ben'answer comment

[manuek_]

May be I should have comment the Ben answer and not answer ?

[Alain_ESCAFFRE]

Yes please, you should add it as a comment