[CI] EsqlSpecIT test {csv-spec:approximation.Approximate stats by with zero variance} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #12383 / encryption-at-rest
• elasticsearch-pull-request #152759 / part-5
• elasticsearch-pull-request #152735 / part-5
• elasticsearch-pull-request #152735 / part-5

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {csv-spec:approximation.Approximate stats by with zero variance}" -Dtests.seed=572380722CD9B9F9 -Dtests.locale=nb-SJ -Dtests.timezone=Europe/Amsterdam -Druntime.java=26

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.Exception: Test abandoned because suite timeout was reached.

Issue Reasons:

• [main] 1 consecutive failures in test test {csv-spec:approximation.Approximate stats by with zero variance}
• [main] 1 consecutive failures in step encryption-at-rest
• [main] 1 consecutive failures in pipeline elasticsearch-periodic
• [main] 4 failures in test test {csv-spec:approximation.Approximate stats by with zero variance} (0.5% fail rate in 852 executions)
• [main] 3 failures in step part-5 (0.8% fail rate in 384 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (0.5% fail rate in 380 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] 1 consecutive failures in test test {csv-spec:approximation.Approximate stats by with zero variance}
• [main] 1 consecutive failures in step encryption-at-rest
• [main] 1 consecutive failures in pipeline elasticsearch-periodic
• [main] 4 failures in test test {csv-spec:approximation.Approximate stats by with zero variance} (0.5% fail rate in 852 executions)
• [main] 3 failures in step part-5 (0.8% fail rate in 384 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (0.5% fail rate in 380 executions)

Build Scans:

• elasticsearch-periodic #12383 / encryption-at-rest
• elasticsearch-pull-request #152759 / part-5
• elasticsearch-pull-request #152735 / part-5
• elasticsearch-pull-request #152735 / part-5

[elasticsearchmachine]

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