Resolve "Query contains too many nested clauses Error" in OpenSearch

Symptom

Your application reports the following OpenSearch error:

Query contains too many nested clauses; maxClauseCount is set to 1024

This error will typically appear in your application error log, such as Magento's exception.log.

Solution

• Add the following to the file /mnt/jrc-confs/opensearch/opensearch.env:

indices.query.bool.max_clause_count=4096

• Restart the OpenSearch service via the AutoPilot interface in Actions > Restart Service > opensearch
• Verify that the setting has been applied with the following command:

curl -sX GET "http://search.internal:9200/_cluster/settings?pretty&include_defaults=true" | grep clause

If the change was applied successfully, the above command should return the following:

"max_clause_count" : "4096"