[CI] CrossClusterAsyncQueryIT testStopQueryLocal failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #6121 / windows-2022_checkpart3_platform-support-windows
• elasticsearch-pull-request #54427 / part-3
• elasticsearch-pull-request #54172 / part-3

Reproduction Line:

gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.CrossClusterAsyncQueryIT.testStopQueryLocal" -Dtests.seed=9118AB4453C6411D -Dtests.locale=fr-PM -Dtests.timezone=Africa/Ouagadougou -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: not <running>
     but: was <running>

Issue Reasons:

• [main] 3 failures in test testStopQueryLocal (0.9% fail rate in 327 executions)
• [main] 2 failures in step part-3 (1.5% fail rate in 132 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (1.5% fail rate in 131 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 testStopQueryLocal (0.9% fail rate in 327 executions)
• [main] 2 failures in step part-3 (1.5% fail rate in 132 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (1.5% fail rate in 131 executions)

Build Scans:

• elasticsearch-periodic-platform-support #6121 / windows-2022_checkpart3_platform-support-windows
• elasticsearch-pull-request #54427 / part-3
• elasticsearch-pull-request #54172 / part-3

[elasticsearchmachine]

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

[elasticsearchmachine]

Pinging @elastic/es-search-foundations (Team:Search Foundations)

[alex-spies]

@smalyshev , I hope it's okay I assign you to this, as you recently made changes to this test.

[alex-spies]

@smalyshev , I don't understand the test well enough to properly assess the risk - I assume this is not a blocker, but cannot say if this should be low risk. I'll go with medium - please correct me if you disagree!

[smalyshev]

Same as #121672 but pre-refactoring. Closing this one - will continue with the other one.