[CI] CrossClusterQueryWithPartialResultsIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #6717 / encryption-at-rest
• elasticsearch-intake #19088 / part3
• elasticsearch-periodic-platform-support #6671 / rhel-8_platform-support-unix
• elasticsearch-pull-request #59520 / part-3
• elasticsearch-intake #18727 / part3

Reproduction Line:

undefined

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

undefined

Issue Reasons:

• [8.x] 5 failures in class org.elasticsearch.xpack.esql.action.CrossClusterQueryWithPartialResultsIT (0.8% fail rate in 655 executions)
• [8.x] 2 failures in step part3 (3.2% fail rate in 62 executions)
• [8.x] 2 failures in pipeline elasticsearch-intake (3.2% fail rate in 62 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)