[CI] ValuesTests testGroupingAggregate {TestCase=<<no alt geo_shape>s> #2} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #19857 / part3
• elasticsearch-pull-request #61614 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.expression.function.aggregate.ValuesTests.testGroupingAggregate {TestCase=<<no alt geo_shape>s> #2}" -Dtests.seed=9ED6B334BDF60196 -Dtests.locale=vai -Dtests.timezone=Europe/Lisbon -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.OutOfMemoryError: Java heap space

Issue Reasons:

• [main] 2 failures in test testGroupingAggregate {TestCase=<s> Discovery: Support local (JVM level) discovery #2} (0.7% fail rate in 276 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 testGroupingAggregate {TestCase=<s> Discovery: Support local (JVM level) discovery #2} (0.7% fail rate in 276 executions)

Build Scans:

• elasticsearch-intake #19857 / part3
• elasticsearch-pull-request #61614 / part-3

[elasticsearchmachine]

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

[idegtiarenko]

This is same as #124330 but for a different branch. I am merging them.