[CI] EsqlSpecIT test {rerank.Reranker using another sort order ASYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #22558 / part3
• elasticsearch-pull-request #70081 / part-3
• elasticsearch-pull-request #70060 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {rerank.Reranker using another sort order ASYNC}" -Dtests.seed=188EE70F617AA567 -Dtests.locale=pcm -Dtests.timezone=Asia/Muscat -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [DELETE], host [http://[::1]:38591], URI [/_query/async/FmFyV1hDX1JiUXI2d2hUNTl4NWRqbkEcSzZGMkJoNHlTQjJYUGFDcXBqY21qZzo3MjMxMQ==?pretty=true&error_trace=true], status line [HTTP/1.1 502 Bad Gateway]
{
  "error" : {
    "root_cause" : [
      {
        "type" : "node_disconnected_exception",
        "reason" : "[test-cluster-0][127.0.0.1:36449][indices:data/read/async_search/delete] disconnected",
        "stack_trace" : "org.elasticsearch.transport.NodeDisconnectedException: [test-cluster-0][127.0.0.1:36449][indices:data/read/async_search/delete] disconnected\n"
      }
    ],
    "type" : "node_disconnected_exception",
    "reason" : "[test-cluster-0][127.0.0.1:36449][indices:data/read/async_search/delete] disconnected",
    "stack_trace" : "org.elasticsearch.transport.NodeDisconnectedException: [test-cluster-0][127.0.0.1:36449][indices:data/read/async_search/delete] disconnected\n"
  },
  "status" : 502
}

Issue Reasons:

• [main] 3 failures in test test {rerank.Reranker using another sort order ASYNC} (1.2% fail rate in 249 executions)
• [main] 2 failures in step part-3 (2.1% fail rate in 94 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (2.2% fail rate in 93 executions)

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

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 3 failures in test test {rerank.Reranker using another sort order ASYNC} (1.2% fail rate in 249 executions)
• [main] 2 failures in step part-3 (2.1% fail rate in 94 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (2.2% fail rate in 93 executions)

Build Scans:

• elasticsearch-intake #22558 / part3
• elasticsearch-pull-request #70081 / part-3
• elasticsearch-pull-request #70060 / part-3

[elasticsearchmachine]

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