topic Re: What to do when we got the warn "Selection hierarchy.name ...is getting big and now has size" ? in Nuxeo Forum

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

manuek_ — Wed, 08 Jul 2015 10:55:28 GMT

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

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

ben_ — Thu, 09 Jul 2015 07:55:13 GMT

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

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

manuek_ — Thu, 09 Jul 2015 09:46:24 GMT

This answer deleted to go in the Ben'answer comment

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

manuek_ — Thu, 09 Jul 2015 09:49:32 GMT

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

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

Alain_ESCAFFRE — Mon, 13 Jul 2015 13:04:43 GMT

Yes please, you should add it as a comment

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

manuek_ — Mon, 13 Jul 2015 13:15:23 GMT

Hi,

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

ben_ — Wed, 22 Jul 2015 15:21:53 GMT

Hi,