[SYNCOPE-1725] Error when searching with high number of OR or AND conditions with Elasticsearch

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.1
• Fix Version/s: 3.0.2, 4.0.0
• Component/s: core
• Labels: elasticsearch
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 23/Jan/23 12:54
• Updated: 17/Feb/23 07:58
• Resolved: 23/Jan/23 14:13

Description

When the FIQL expression contains a high number of OR or AND clauses, the transformed query to Elasticsearch returns HTTP 400 with an error payload like as follows:

{
  "error": {
    "root_cause": [
      {
        "type": "parsing_exception",
        "reason": "Failed to parse",
        "line": 1,
        "col": 2608
      }
    ],
    "type": "parsing_exception",
    "reason": "Failed to parse",
    "line": 1,
    "col": 2608,
    "caused_by": {
      "type": "x_content_parse_exception",
      "reason": "[1:2608] [bool] failed to parse field [must]",
      "caused_by": {
        "type": "illegal_argument_exception",
        "reason": "The nested depth of the query exceeds the maximum nested depth for queries set in [indices.query.bool.max_nested_depth]"
      }
    }
  },
  "status": 400
}