[CI] HeapAttackIT testLookupExplosionManyMatches failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #6126 / rhel-7_platform-support-unix
• elasticsearch-periodic-platform-support #6050 / ubuntu-2404_platform-support-unix

Reproduction Line:

./gradlew ":test:external-modules:test-esql-heap-attack:javaRestTest" --tests "org.elasticsearch.xpack.esql.heap_attack.HeapAttackIT.testLookupExplosionManyMatches" -Dtests.seed=84260B8935292342 -Dtests.locale=kxv-IN -Dtests.timezone=ECT -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

junit.framework.AssertionFailedError: Expected exception ResponseException but no exception was thrown

Issue Reasons:

• [8.x] 2 failures in test testLookupExplosionManyMatches (0.4% fail rate in 564 executions)
• [8.x] 2 failures in pipeline elasticsearch-periodic-platform-support (15.4% fail rate in 13 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 testLookupExplosionManyMatches (0.4% fail rate in 475 executions)

Build Scans:

• elasticsearch-periodic-platform-support #6107 / windows-2022_checkpart1_platform-support-windows
• elasticsearch-pull-request #53887 / part-1

[elasticsearchmachine]

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

[alex-spies]

@nik9000 , this one also somehow returned a result. I'd appreciate if you could take a look :)

[2025-02-01T23:45:53,242][ERROR][o.e.x.e.h.HeapAttackIT   ] [testLookupExplosionManyMatches] should have failed but got {took=94926, is_partial=false, columns=[{name=COUNT(location), type=long}], values=[[15000000]]}	

[nik9000]

• elasticsearch-periodic-platform-support Limit the number of bytes that can be allocated to process requests. #6050 / ubuntu-2404_platform-support-unix

Despite this saying "should have failed but didn't" this is actually a timeout. In the Verifier.

elasticsearch-periodic-platform-support #6126 / rhel-7_platform-support-unix

This one didn't fail:

[2025-02-01T23:44:18,304][INFO ][o.e.x.e.h.HeapAttackIT   ] [testLookupExplosionManyMatches] --> test testLookupExplosionManyMatches started querying
[2025-02-01T23:45:42,561][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][249] overhead, spent [269ms] collecting in the last [1s]
[2025-02-01T23:45:47,579][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][254] overhead, spent [253ms] collecting in the last [1s]
[2025-02-01T23:45:48,600][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][255] overhead, spent [299ms] collecting in the last [1s]
[2025-02-01T23:45:53,241][INFO ][o.e.x.e.h.HeapAttackIT   ] [testLookupExplosionManyMatches] --> test testLookupExplosionManyMatches completed querying
[2025-02-01T23:45:53,242][ERROR][o.e.x.e.h.HeapAttackIT   ] [testLookupExplosionManyMatches] should have failed but got {took=94926, is_partial=false, columns=[{name=COUNT(location), type=long}], values=[[15000000]]}

elasticsearch-periodic-platform-support #6107 / windows-2022_checkpart1_platform-support-windows

Everything failed. The whole build seems broken.

elasticsearch-pull-request #53887 / part-1

Timeout in the Analyzer. In resolveEval.

[nik9000]

Timeout in the Analyzer. In resolveEval.

There isn't an eval in this test. I think that's some kind of other failure.