[CI] CrossClusterAsyncQueryIT testStopQueryLocal failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #22641 / part3
• elasticsearch-periodic #7981 / single-processor-node-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.CrossClusterAsyncQueryIT.testStopQueryLocal" -Dtests.seed=F70BF6B2390D76A5 -Dtests.locale=seh-MZ -Dtests.timezone=Asia/Makassar -Druntime.java=24

Applicable branches:
9.0

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

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

Issue Reasons:

• [9.0] 2 failures in test testStopQueryLocal (1.0% fail rate in 191 executions)

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

[elasticsearchmachine]

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

[elasticsearchmachine]

This has been muted on branch 9.0

Mute Reasons:

• [9.0] 2 failures in test testStopQueryLocal (1.0% fail rate in 191 executions)

Build Scans:

• elasticsearch-intake #22641 / part3
• elasticsearch-periodic #7981 / single-processor-node-tests

[smalyshev]

Should be fixed by #131130