[CI] RestEsqlIT testProfileOrdinalsGroupingOperator {SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #4320 / debian-11_platform-support-unix
• elasticsearch-pull-request #34910 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:single-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.single_node.RestEsqlIT.testProfileOrdinalsGroupingOperator {SYNC}" -Dtests.seed=32E678B91A6371D6 -Dtests.locale=ff-Adlm -Dtests.timezone=Canada/Eastern -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.IndexOutOfBoundsException: Index 2 out of bounds for length 2

Issue Reasons:

• [main] 2 failures in test testProfileOrdinalsGroupingOperator {SYNC} (0.6% fail rate in 329 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 testProfileOrdinalsGroupingOperator {SYNC} (0.6% fail rate in 329 executions)

Build Scans:

• elasticsearch-periodic-platform-support #4320 / debian-11_platform-support-unix
• elasticsearch-pull-request #34910 / part-3

[elasticsearchmachine]

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