[CI] CrossClusterAsyncQueryStopIT testStopQueryInlineStats failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #29557 / part3
• elasticsearch-intake #29543 / part3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.CrossClusterAsyncQueryStopIT.testStopQueryInlineStats" -Dtests.seed=20114C4CC666B76A -Dtests.locale=mi -Dtests.timezone=Indian/Maldives -Druntime.java=25

Applicable branches:
9.2

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: <45L>
     but: was <13L>

Issue Reasons:

• [9.2] 2 failures in test testStopQueryInlineStats (28.6% fail rate in 7 executions)
• [9.2] 2 failures in step part3 (66.7% fail rate in 3 executions)
• [9.2] 2 failures in pipeline elasticsearch-intake (66.7% fail rate in 3 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 consecutive failures in test testStopQueryInlineStats
• [main] 2 consecutive failures in step part-3
• [main] 2 consecutive failures in pipeline elasticsearch-pull-request
• [main] 7 failures in test testStopQueryInlineStats (33.3% fail rate in 21 executions)
• [main] 6 failures in step part-3 (40.0% fail rate in 15 executions)
• [main] 5 failures in pipeline elasticsearch-pull-request (38.5% fail rate in 13 executions)

Build Scans:

• elasticsearch-intake #28676 / part3
• elasticsearch-pull-request #93373 / part-3
• elasticsearch-pull-request #93361 / part-3
• elasticsearch-pull-request #93363 / part-3
• elasticsearch-pull-request #93361 / part-3
• elasticsearch-pull-request #93358 / part-3
• elasticsearch-pull-request #93359 / part-3

[elasticsearchmachine]

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

[GalLalouche]

@smalyshev Looks you added this assertion in #134323. Could you please investigate?

[smalyshev]

Seems to reproduce on repeated testing, so looks like I missed something there. Will investigate.