[CI] EsqlClientYamlIT test {p0=esql/120_profile/avg 8.14 or after} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #22803 / 8.19.0_bwc-snapshots
• elasticsearch-intake #22799 / 8.19.0_bwc-snapshots
• elasticsearch-pull-request #71034 / 8.19.0_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.19.0#yamlRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.EsqlClientYamlIT" -Dtests.method="test {p0=esql/120_profile/avg 8.14 or after}" -Dtests.seed=D1E2FEE3F4D7C5CC -Dtests.bwc=true -Dtests.locale=om-KE -Dtests.timezone=Pacific/Fakaofo -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.RuntimeException: Failure at [esql/120_profile:136]: element was a list with 1 elements, but [1] was out of bounds

Issue Reasons:

• [main] 2 consecutive failures in step 8.19.0_bwc-snapshots
• [main] 3 failures in test test {p0=esql/120_profile/avg 8.14 or after} (1.2% fail rate in 260 executions)
• [main] 3 failures in step 8.19.0_bwc-snapshots (2.6% fail rate in 114 executions)
• [main] 2 failures in pipeline elasticsearch-intake (5.4% fail rate in 37 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] 2 failures in test test {p0=esql/120_profile/avg 8.14 or after} (0.8% fail rate in 257 executions)
• [main] 2 failures in step 8.19.0_bwc-snapshots (1.8% fail rate in 113 executions)

Build Scans:

• elasticsearch-intake #22799 / 8.19.0_bwc-snapshots
• elasticsearch-pull-request #71034 / 8.19.0_bwc-snapshots

[elasticsearchmachine]

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

[ivancea]

Could be a flaky test after #127745
I'll try to reproduce it

[nik9000]

This is almost certainly a backport mistake I made with #127775 . We're fixing it.