Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-110407

"My Workflow Tasks > Assigned to my Roles" page can not be loaded due to too_many_clauses: maxClauseCount when the user is a member of a high number of sites

    Details

      Description

      Steps to reproduce on master, 7.2.x, 7.1.x (DXP profile) - Simplified to avoid re-compiling and adapting the dummyfactory to master

      1. Start DXP and connect to a remote ES6
      2. Create 5 new blank sites
      3. Stop the ES server
      4. Set indices.query.bool.max_clause_count: 5 in ES_HOME/config/elasticsearch.yml just to show that this limit has an impact on the Workflow portlets
      5. Restart ES
      6. Visit the My Workflow Tasks > Assigned to my Roles page.
         Result : Same error as below.

      Steps to reproduce: 7.1.x, 7.2.x (DXP profile) - Similar to the customer's use case

      1. Start DXP and connect to a remote ES6.
      2. Deploy the DummyFactory module.
      3. Add the Dummy Factory widget to a page.
      4. Create 2024 sites (blank is fine).
      5. Visit the My Workflow Tasks > Assigned to my Roles page.

       
       Result:

      2020-03-12 13:57:22.454 ERROR [http-nio-7111-exec-3][render_portlet_jsp:131] null
       NotSerializableExceptionWrapper[too_many_clauses: maxClauseCount is set to 1024]
        at org.apache.lucene.search.BooleanQuery$Builder.add(BooleanQuery.java:114)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:422)
        at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:385)
        at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
        at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:383)
        at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
        at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:385)
        at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
        at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:385)
        at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
        at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:383)
        at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)
        at org.elasticsearch.index.query.BoolQueryBuilder.doToQuery(BoolQueryBuilder.java:383)
        at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:105)
        at org.elasticsearch.index.query.BoolQueryBuilder.addBooleanClauses(BoolQueryBuilder.java:415)

      Workaround

      1. Stop ES.
      2. Set indices.query.bool.max_clause_count: 2048 in ES_HOME/config/elasticsearch.yml
      3. Restart ES.
      4. Visit the Assigned to My Roles page again.
        Page is loaded without errors.

      Reference:
      https://www.elastic.co/guide/en/elasticsearch/reference/current/search-settings.html

        Attachments

          Activity

            People

            Assignee:
            melody.wu Melody Wu
            Reporter:
            inacio.nery Inácio Nery
            Participants of an Issue:
            Recent user:
            Jason Pince
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              36 weeks, 1 day ago

                Packages

                Version Package
                7.3.1 CE GA2
                7.3.2 CE GA3
                7.3.10 DXP GA1
                Master