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

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8471 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-pull-request #72673 / part-3
• elasticsearch-pull-request #72218 / 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=F4DB286E9CADE56D -Dtests.locale=fr-BL -Dtests.timezone=America/St_Barthelemy -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.OutOfMemoryError: Java heap space

Issue Reasons:

• [8.19] 3 failures in test testGroupingAggregate {TestCase=<s> Discovery: Support local (JVM level) discovery #2} (0.4% fail rate in 845 executions)
• [8.19] 2 failures in step part-3 (2.7% fail rate in 73 executions)
• [8.19] 2 failures in pipeline elasticsearch-pull-request (2.8% fail rate in 72 executions)

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

[elasticsearchmachine]

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

[alex-spies]

This seems to be the same as #128709.