Uploaded image for project: 'Atlassian Intelligence'
  1. Atlassian Intelligence
  2. AI-437

CQL search throws error "Exception executing cql as async search"

    • Severity 3 - Minor

      Issue Summary

      Using the GET method to this specific API request, we get below exception:

      https://<instance>/wiki/rest/api/search?limit=1000&cql=parent=xxxxxxxx
      
      com.atlassian.confluence.api.service.exceptions.ServiceException: Exception executing cql as async search: parent=xxxxxxxxx
      

      Environment

      1. Confluence Cloud

      Expected Results

      No error on the page, and the page details should be displayed.

      Actual Results

      Splunk shows below error:

      Caused by: org.elasticsearch.ElasticsearchException: too_many_clauses:too_many_clauses: maxClauseCount is set to 1024
      com.atlassian.confluence.impl.search.elasticsearch.rest.ResponseErrorParser.handleOtherException(ResponseErrorParser.java:113)
      com.atlassian.confluence.impl.search.elasticsearch.rest.ResponseErrorParser.parseErrorResponse(ResponseErrorParser.java:61)
      com.atlassian.confluence.impl.search.elasticsearch.rest.ResponseErrorParser.handleShardSearchFailure(ResponseErrorParser.java:93)
      com.atlassian.confluence.impl.search.elasticsearch.rest.ResponseErrorParser.lambda$handleShardSearchFailures$0(ResponseErrorParser.java:88)
      java.lang.Iterable.forEach(Iterable.java:75)
      com.atlassian.confluence.impl.search.elasticsearch.rest.ResponseErrorParser.handleShardSearchFailures(ResponseErrorParser.java:88)
      ... 42 more	
        	}	
        	 ext:	{	[+]	
        	}	
        	 hostname:	 dde06fed3820	
        	 level:	 WARN	
        	 logger:	 com.atlassian.confluence.rest.api.model.ExceptionConverter	
        	 m:	{	[+]	
        	}	
        	 message:	 Could not map exception type com.atlassian.confluence.api.service.exceptions.ServiceException to a specific REST status. Defaulting to InternalServerError	
        	 micros_container:	 confluence	
        	 product:	 confluence	
        	 thread:	 http-bio-8081-exec-60 [tenantId:xxxxxxxxxxxxxxxx] [traceId:00cf48a5c560cd7f]	
        	 time:	 2019-08-20T12:10:59Z	
        	 timestamp:	 2019-08-20T12:10:59.410	
      

       

      Workaround

      Currently there is no known workaround for this behaviour. A workaround will be added here when available

        1. Confluence.postman_collection2.json
          1 kB
        2. Confluence.postman_collection.json
          1 kB
        3. screenshot-1.png
          screenshot-1.png
          342 kB
        4. screenshot-2.png
          screenshot-2.png
          378 kB

          Form Name

            [AI-437] CQL search throws error "Exception executing cql as async search"

            pqz made changes -
            Component/s Original: Search - Core [ 46383 ]
            Component/s New: Search - Core [ 75296 ]
            Key Original: CONFCLOUD-67763 New: AI-437
            QA Demo Status Original: Not Done [ 14330 ]
            QA Kickoff Status Original: Not Done [ 14234 ]
            Support reference count Original: 2
            Project Original: Confluence Cloud [ 18513 ] New: Atlassian Intelligence [ 23110 ]
            Matthew Hunter made changes -
            Resolution New: Timed out [ 10 ]
            Status Original: Long Term Backlog [ 12073 ] New: Closed [ 6 ]
            Matthew Hunter made changes -
            Labels Original: CQL core-experience q1-19-cc-ecosystem search-squad-ktlo soft-serve New: CQL core-experience q1-19-cc-ecosystem search-squad-ktlo soft-serve stale-bulk-close202202
            Bugfix Automation Bot made changes -
            Support reference count Original: 1 New: 2
            Max Henash (Inactive) made changes -
            Link New: This issue causes CONFDEV-68096 [ CONFDEV-68096 ]
            Max Henash (Inactive) made changes -
            Link Original: This issue blocks CONFDEV-68096 [ CONFDEV-68096 ]
            Max Henash (Inactive) made changes -
            Link New: This issue blocks CONFDEV-68096 [ CONFDEV-68096 ]
            Max Henash (Inactive) made changes -
            Link Original: This issue relates to CONFDEV-68096 [ CONFDEV-68096 ]
            Max Henash (Inactive) made changes -
            Sprint Original: CC Softserve 20 - WFH sprint [ 5811 ]
            Assignee Original: Max Henash [ mhenash@atlassian.com ]
            Max Henash (Inactive) made changes -
            Sprint New: CC Softserve 20 - WFH sprint [ 5811 ]

              Unassigned Unassigned
              lhou1 Lorien Hou
              Affected customers:
              3 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: