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

[elasticsearchmachine]

Build Scans:
(9.0)

• elasticsearch-periodic-platform-support #6846 / ubuntu-2404-aarch64_checkpart3_platform-support-arm
• elasticsearch-periodic-platform-support #6786 / oraclelinux-9_platform-support-unix

(main)

• 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>}" -Dtests.seed=94CED618DAEC14A8 -Dtests.locale=jgo-CM -Dtests.timezone=Pacific/Truk -Druntime.java=24

Applicable branches:
main, 9.0

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.OutOfMemoryError: Java heap space

Issue Reasons:

• [9.0] 2 failures in test testGroupingAggregate {TestCase=<s>} (0.7% fail rate in 267 executions)
• [9.0] 2 failures in pipeline elasticsearch-periodic-platform-support (25.0% fail rate in 8 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)

[astefan]

@nik9000 could you have a look at this one, you've touched this one recently.

For the reference, this is the relevant part of the logs:

REPRODUCE WITH: ./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.expression.function.aggregate.ValuesTests.testGroupingAggregate {TestCase=<<no alt geo_shape>s>}" -Dtests.seed=E2F62EF29DBDBC33 -Dtests.locale=jgo-Latn-CM -Dtests.timezone=Australia/Queensland -Druntime.java=23

ValuesTests > testGroupingAggregate {TestCase=<<no alt geo_shape>s>} FAILED
    java.lang.OutOfMemoryError: Java heap space
        at __randomizedtesting.SeedInfo.seed([E2F62EF29DBDBC33:6174681FFFB5B3D0]:0)
        at org.elasticsearch.common.util.BigByteArray.get(BigByteArray.java:73)
        at org.elasticsearch.common.util.MockBigArrays$ByteArrayWrapper.get(MockBigArrays.java:399)
        at org.elasticsearch.common.util.BytesRefArray.get(BytesRefArray.java:106)
        at org.elasticsearch.compute.data.BytesRefArrayVector.getBytesRef(BytesRefArrayVector.java:72)
        at org.elasticsearch.compute.data.BytesRefArrayBlock.getBytesRef(BytesRefArrayBlock.java:98)
        at org.elasticsearch.compute.data.BlockUtils.valueAtOffset(BlockUtils.java:278)
        at org.elasticsearch.compute.data.BlockUtils.toJavaObject(BlockUtils.java:270)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase.lambda$extractResultsFromAggregator$6(AbstractAggregationTestCase.java:365)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase$$Lambda/0x000000002481bc50.apply(Unknown Source)
        at java.base/java.util.stream.IntPipeline$1$1.accept(IntPipeline.java:180)
        at java.base/java.util.stream.Streams$RangeIntSpliterator.forEachRemaining(Streams.java:104)
        at java.base/java.util.Spliterator$OfInt.forEachRemaining(Spliterator.java:712)
        at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:570)
        at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:560)
        at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:636)
        at java.base/java.util.stream.AbstractPipeline.evaluateToArrayNode(AbstractPipeline.java:291)
        at java.base/java.util.stream.ReferencePipeline.toArray(ReferencePipeline.java:656)
        at java.base/java.util.stream.ReferencePipeline.toArray(ReferencePipeline.java:662)
        at java.base/java.util.stream.ReferencePipeline.toList(ReferencePipeline.java:667)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase.extractResultsFromAggregator(AbstractAggregationTestCase.java:366)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase.aggregateGroupingSingleMode(AbstractAggregationTestCase.java:195)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase$$Lambda/0x0000000024819a98.accept(Unknown Source)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase.resolveExpression(AbstractAggregationTestCase.java:328)
        at org.elasticsearch.xpack.esql.expression.function.AbstractAggregationTestCase.testGroupingAggregate(AbstractAggregationTestCase.java:146)
        at java.base/java.lang.invoke.LambdaForm$DMH/0x0000000024000c00.invokeVirtual(LambdaForm$DMH)
        at java.base/java.lang.invoke.LambdaForm$MH/0x0000000024846800.invoke(LambdaForm$MH)
        at java.base/java.lang.invoke.Invokers$Holder.invokeExact_MT(Invokers$Holder)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invokeImpl(DirectMethodHandleAccessor.java:153)
        at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
        at java.base/java.lang.reflect.Method.invoke(Method.java:580)
        at com.carrotsearch.randomizedtesting.RandomizedRunner.invoke(RandomizedRunner.java:1763)
        at com.carrotsearch.randomizedtesting.RandomizedRunner$8.evaluate(RandomizedRunner.java:946)

[idegtiarenko]

I am assigning low risk as this is "java.lang.OutOfMemoryError: Java heap space" during test execution and is likely require test tuning rather than actual production code change. Please feel free to change the priority if you see otherwise.

[idegtiarenko]

Please note, this issue was observed in main too

[nik9000]

@craigtaverner added this support recently. I believe this is just a "too large" bit of test data. checking.