[CI] HeapAttackIT testLookupExplosionNoFetch failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #8025 / almalinux-8-aarch64_checkpart1_platform-support-arm
• elasticsearch-periodic-platform-support #7947 / ubuntu-2404-aarch64_checkpart1_platform-support-arm
• elasticsearch-periodic-platform-support #7911 / ubuntu-2004_platform-support-unix

Reproduction Line:

./gradlew ":test:external-modules:test-esql-heap-attack:javaRestTest" --tests "org.elasticsearch.xpack.esql.heap_attack.HeapAttackIT.testLookupExplosionNoFetch" -Dtests.seed=FAE10A848D7D09BA -Dtests.locale=ja -Dtests.timezone=Canada/Yukon -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [POST], host [http://[::1]:37951], URI [/_query?error_trace=], status line [HTTP/1.1 429 Too Many Requests]
Warnings: [No limit defined, adding default limit of [1000]]
{"error":{"root_cause":[{"type":"circuit_breaking_exception","reason":"[request] Data too large, data for [serialize lookup join response] would be [561439584/535.4mb], which is larger than the limit of [322122547/307.1mb]","bytes_wanted":561439584,"bytes_limit":322122547,"durability":"TRANSIENT","stack_trace":"org.elasticsearch.common.breaker.CircuitBreakingException: [request] Data too large, data for [serialize lookup join response] would be [561439584/535.4mb], which is larger than the limit of [322122547/307.1mb]\n\tat org.elasticsearch.common.breaker.ChildMemoryCircuitBreaker.circuitBreak(ChildMemoryCircuitBreaker.java:92)\n\tat org.elasticsearch.common.breaker.ChildMemoryCircuitBreaker.limit(ChildMemoryCircuitBreaker.java:182)\n\tat org.elasticsearch.common.break
[truncated]

Issue Reasons:

• [8.19] 3 failures in test testLookupExplosionNoFetch (0.6% fail rate in 509 executions)
• [8.19] 3 failures in pipeline elasticsearch-periodic-platform-support (17.6% fail rate in 17 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)

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 4 failures in test testLookupExplosionNoFetch (0.4% fail rate in 932 executions)
• [main] 2 failures in step ubuntu-2404-aarch64_checkpart1_platform-support-arm (10.5% fail rate in 19 executions)
• [main] 2 failures in step part-1 (0.6% fail rate in 323 executions)
• [main] 2 failures in pipeline elasticsearch-periodic-platform-support (10.0% fail rate in 20 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (0.6% fail rate in 322 executions)

Build Scans:

• elasticsearch-periodic-platform-support #7865 / ubuntu-2404-aarch64_checkpart1_platform-support-arm
• elasticsearch-pull-request #69036 / part-1
• elasticsearch-pull-request #69008 / part-1
• elasticsearch-periodic-platform-support #7751 / ubuntu-2404-aarch64_checkpart1_platform-support-arm

[astefan]

I found two previous reports for this specific tests, even though it might not be the same source, would you mind having another look at it @nik9000?