Build Scans:

• elasticsearch-intake #9472 / 8.16.0_bwc-snapshots
• elasticsearch-intake #9473 / 8.16.0_bwc-snapshots
• elasticsearch-intake #9471 / 8.16.0_bwc-snapshots
• elasticsearch-intake #9470 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #30417 / 8.16.0_bwc-snapshots
• elasticsearch-intake #9469 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #30184 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #30033 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #30005 / 8.16.0_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.16.0#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {meta.CountFunctions ASYNC}" -Dtests.seed=644904B5974DE683 -Dtests.bwc=true -Dtests.locale=ebu-KE -Dtests.timezone=America/Eirunepe -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Data mismatch:
row 0 column 0:a list containing
row 0 column 0:0: expected "116" but was "117"
row 0 column 1:a list containing
row 0 column 1:0: expected "116" but was "117"
row 0 column 2:a list containing
row 0 column 2:0: expected "116" but was "117"

Issue Reasons:

• [main] 3 consecutive failures in test test {meta.CountFunctions ASYNC}
• [main] 3 consecutive failures in step 8.16.0_bwc-snapshots
• [main] 5 consecutive failures in pipeline elasticsearch-intake
• [main] 9 failures in test test {meta.CountFunctions ASYNC} (2.4% fail rate in 382 executions)
• [main] 9 failures in step 8.16.0_bwc-snapshots (3.5% fail rate in 259 executions)
• [main] 5 failures in pipeline elasticsearch-intake (7.0% fail rate in 71 executions)
• [main] 4 failures in pipeline elasticsearch-pull-request (2.1% fail rate in 194 executions)

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