[CI] MixedClusterEsqlSpecIT test {string.LucenePushdownMultipleAnd SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #6948 / 8.12.2_bwc
• elasticsearch-periodic #6948 / 8.11.4_bwc
• elasticsearch-periodic #6941 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.12.2#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {string.LucenePushdownOr SYNC}" -Dtests.seed=5482DA9E61C48CA2 -Dtests.bwc=true -Dtests.locale=ar-MA -Dtests.timezone=Africa/Ndjamena -Druntime.java=24

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [POST], host [http://[::1]:40997], URI [/_query?pretty=true&error_trace=true], status line [HTTP/1.1 400 Bad Request]
---
error:
  root_cause:
  - type: "parsing_exception"
    reason: "line 2:25: token recognition error at: ':'"
    stack_trace: "org.elasticsearch.xpack.esql.parser.ParsingException: line 2:25:\
      \ token recognition error at: ':'\n\tat org.elasticsearch.xpack.esql.parser.EsqlParser$1.syntaxError(EsqlParser.java:109)\n\
      \tat org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)\n\
      \tat org.antlr.v4.runtime.Lexer.notifyListeners(Lexer.java:364)\n\tat org.antlr.v4.runtime.Lexer.nextToken(Lexer.java:144)\n\
      \tat org.elasticsearch.xpack.esql.parser.EsqlParser$ParametrizedTokenSource.nextToken(EsqlParser.java:135)\n\
      \tat org.antlr.v4.runtime.BufferedTokenStream.fetch(BufferedTokenStream.java:169)\n\
      \tat org.antlr.v4.runtime.BufferedTokenStream.sync(BufferedTokenS
[truncated]

Issue Reasons:

• [8.x] 2 consecutive failures in test test {string.LucenePushdownMultipleAnd SYNC}
• [8.x] 2 consecutive failures in step 8.11.4_bwc
• [8.x] 3 failures in test test {string.LucenePushdownMultipleAnd SYNC} (3.1% fail rate in 97 executions)
• [8.x] 2 failures in step 8.11.4_bwc (100.0% fail rate in 2 executions)
• [8.x] 2 failures in pipeline elasticsearch-periodic (100.0% fail rate in 2 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[idegtiarenko]

Fixed by #124625