[CI] CrossClusterQueryWithPartialResultsIT testFailToStartRequestOnRemoteCluster failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #10015 / rocky-8_platform-support-unix
• elasticsearch-intake #26903 / part3
• elasticsearch-periodic-platform-support #10001 / rhel-7_platform-support-unix
• elasticsearch-periodic-platform-support #10001 / oraclelinux-7_platform-support-unix
• elasticsearch-periodic #9990 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-pull-request #85504 / part-3
• elasticsearch-periodic #9962 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic-platform-support #9966 / oraclelinux-9_platform-support-unix
• elasticsearch-periodic-platform-support #9959 / ubuntu-2204_platform-support-unix
• elasticsearch-periodic-platform-support #9952 / opensuse-leap-15_platform-support-unix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.CrossClusterQueryWithPartialResultsIT.testFailToStartRequestOnRemoteCluster" -Dtests.seed=2F06D4640D1E4A97 -Dtests.locale=en-IN -Dtests.timezone=Africa/Khartoum -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: <skipped>
     but: was <partial>

Issue Reasons:

• [8.19] 21 failures in test testFailToStartRequestOnRemoteCluster (3.1% fail rate in 679 executions)
• [8.19] 3 failures in step rocky-8_platform-support-unix (15.0% fail rate in 20 executions)
• [8.19] 2 failures in step openjdk17_checkpart3_java-fips-matrix (10.0% fail rate in 20 executions)
• [8.19] 2 failures in step oraclelinux-9_platform-support-unix (11.1% fail rate in 18 executions)
• [8.19] 3 failures in step oraclelinux-7_platform-support-unix (18.8% fail rate in 16 executions)
• [8.19] 2 failures in step rhel-7_platform-support-unix (11.1% fail rate in 18 executions)
• [8.19] 13 failures in pipeline elasticsearch-periodic-platform-support (61.9% fail rate in 21 executions)
• [8.19] 2 failures in pipeline elasticsearch-periodic (9.5% fail rate in 21 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)

[smalyshev]

I think this is the same issue as in #132614 just needs a backport to 8.19? Not sure why I didn't backport it, maybe some code change is needed?

[dnhatn]

@smalyshev Yes, I think so. Can you backport the changes to 8.19?

[smalyshev]

Backported in #132949