Build Scans:

• elasticsearch-periodic #5123 / 8.11.4_bwc
• elasticsearch-periodic #5117 / 8.12.2_bwc
• elasticsearch-periodic #5111 / 8.11.4_bwc
• elasticsearch-periodic #5111 / 8.12.2_bwc
• elasticsearch-periodic #5105 / 8.12.2_bwc
• elasticsearch-pull-request #43652 / 8.16.2_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {stats.CountEvalExpWithGrouping SYNC}" -Dtests.seed=3D14D19DD95855EC -Dtests.bwc=true -Dtests.locale=vec-IT -Dtests.timezone=Etc/GMT+9 -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 "9" but was "49" row 0 column 1:a list containing row 0 column 1:0: expected "1" but was "null" 

Issue Reasons:

• [8.x] 3 consecutive failures in step 8.12.2_bwc
• [8.x] 6 failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT (2.2% fail rate in 279 executions)
• [8.x] 2 failures in step 8.11.4_bwc (20.0% fail rate in 10 executions)
• [8.x] 3 failures in step 8.12.2_bwc (33.3% fail rate in 9 executions)
• [8.x] 4 failures in pipeline elasticsearch-periodic (57.1% fail rate in 7 executions)

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