[CI] MixedClusterEsqlSpecIT test {stats.CountFieldWithGrouping SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5117 / 8.12.2_bwc
• elasticsearch-periodic #5105 / 8.12.2_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.12.2#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {stats.GroupByAlias SYNC}" -Dtests.seed=357D36FF8C7ED9EC -Dtests.bwc=true -Dtests.locale=bem -Dtests.timezone=Atlantic/South_Georgia -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected more data but no more entries found after [1]
Data mismatch:
row 0 column 0:a list containing
row 0 column 0:0: expected <1.419999> but was <1.409999>
row 0 column 1:a list containing
row 0 column 1:0: expected "1" but was "null"

Issue Reasons:

• [8.x] 2 failures in test test {stats.CountFieldWithGrouping SYNC} (1.9% fail rate in 104 executions)
• [8.x] 2 failures in step 8.12.2_bwc (50.0% fail rate in 4 executions)
• [8.x] 2 failures in pipeline elasticsearch-periodic (50.0% fail rate in 4 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)