[CI] EsqlActionBreakerIT testFromStatsGroupingAvgWithAliases failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #6744 / openjdk21_checkpart3_java-matrix
• elasticsearch-periodic #6737 / single-processor-node-tests
• elasticsearch-periodic #6730 / openjdk22_checkpart3_java-matrix
• elasticsearch-periodic #6723 / concurrent-search-tests
• elasticsearch-periodic #6723 / single-processor-node-tests
• elasticsearch-periodic-platform-support #6705 / almalinux-9_platform-support-unix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.EsqlActionBreakerIT.testDefaultTruncationSizeSetting" -Dtests.seed=F268B0FC98EAF54D -Dtests.locale=ar-LB -Dtests.timezone=Pacific/Wake -Druntime.java=21

Applicable branches:
8.18

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Request breaker not reset to 0 on node: node_s3
Expected: <0L>
     but: was <64L>

Issue Reasons:

• [8.18] 2 consecutive failures in step single-processor-node-tests
• [8.18] 6 failures in test testFromStatsGroupingAvgWithAliases (5.9% fail rate in 101 executions)
• [8.18] 2 failures in step single-processor-node-tests (66.7% fail rate in 3 executions)
• [8.18] 4 failures in pipeline elasticsearch-periodic (80.0% fail rate in 5 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)

[dnhatn]

Fixed in #123728