[CI] HeapAttackIT testSortByManyLongsSuccess failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #6759 / single-processor-node-tests
• elasticsearch-periodic #6745 / single-processor-node-tests

Reproduction Line:

./gradlew ":test:external-modules:test-esql-heap-attack:javaRestTest" --tests "org.elasticsearch.xpack.esql.heap_attack.HeapAttackIT.testEnrichExplosionManyMatches" -Dtests.seed=25F269D7FF8C8AC1 -Dtests.configure_test_clusters_with_one_processor=true -Dtests.locale=cv-RU -Dtests.timezone=America/Cayenne -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.net.ConnectException: Connection refused

Issue Reasons:

• [8.x] 2 failures in test testSortByManyLongsSuccess (2.0% fail rate in 101 executions)
• [8.x] 2 failures in step single-processor-node-tests (50.0% fail rate in 4 executions)
• [8.x] 2 failures in pipeline elasticsearch-periodic (50.0% fail rate in 4 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 looks like it could be the same as #123805 - @nik9000 , I'll throw this your way since you planned to look at that!

From testEnrichExplosionManyMatches:

[2025-03-03T12:02:45,144][WARN ][o.e.i.b.request          ] [test-cluster-0] [request] New used memory 322135519 [307.2mb] for data of [<reused_arrays>] would be larger than configured breaker: 322122547 [307.1mb], breaking	
[2025-03-03T12:04:33,417][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1677] overhead, spent [254ms] collecting in the last [1s]	
[2025-03-03T12:04:34,428][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1678] overhead, spent [314ms] collecting in the last [1s]	
[2025-03-03T12:04:36,440][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1680] overhead, spent [256ms] collecting in the last [1s]	
[2025-03-03T12:04:37,442][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1681] overhead, spent [262ms] collecting in the last [1s]	
[2025-03-03T12:04:38,444][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1682] overhead, spent [257ms] collecting in the last [1s]	
[2025-03-03T12:04:39,455][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1683] overhead, spent [305ms] collecting in the last [1s]	
[2025-03-03T12:04:40,457][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1684] overhead, spent [277ms] collecting in the last [1s]	
[2025-03-03T12:04:41,467][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1685] overhead, spent [276ms] collecting in the last [1s]	
[2025-03-03T12:04:42,469][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1686] overhead, spent [324ms] collecting in the last [1s]	
[2025-03-03T12:04:43,475][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1687] overhead, spent [278ms] collecting in the last [1s]	
[2025-03-03T12:04:44,477][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1688] overhead, spent [300ms] collecting in the last [1s]	
[2025-03-03T12:04:45,480][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1689] overhead, spent [286ms] collecting in the last [1s]	
[2025-03-03T12:04:46,482][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1690] overhead, spent [317ms] collecting in the last [1s]	
[2025-03-03T12:04:47,504][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1691] overhead, spent [329ms] collecting in the last [1s]	
[2025-03-03T12:04:49,523][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1693] overhead, spent [272ms] collecting in the last [1s]	
[2025-03-03T12:04:50,527][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1694] overhead, spent [283ms] collecting in the last [1s]	
[2025-03-03T12:04:51,529][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1695] overhead, spent [294ms] collecting in the last [1s]	
[2025-03-03T12:04:52,535][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1696] overhead, spent [296ms] collecting in the last [1s]	
[2025-03-03T12:04:53,540][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1697] overhead, spent [271ms] collecting in the last [1s]	
[2025-03-03T12:04:54,544][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1698] overhead, spent [275ms] collecting in the last [1s]	
[2025-03-03T12:04:55,547][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1699] overhead, spent [251ms] collecting in the last [1s]	
[2025-03-03T12:04:57,557][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1701] overhead, spent [272ms] collecting in the last [1s]	
[2025-03-03T12:04:58,591][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1702] overhead, spent [290ms] collecting in the last [1s]	
[2025-03-03T12:05:00,594][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1704] overhead, spent [287ms] collecting in the last [1s]	
[2025-03-03T12:05:01,600][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1705] overhead, spent [276ms] collecting in the last [1s]	
[2025-03-03T12:05:02,602][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1706] overhead, spent [256ms] collecting in the last [1s]	
[2025-03-03T12:05:03,605][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1707] overhead, spent [259ms] collecting in the last [1s]	
[2025-03-03T12:05:04,609][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1708] overhead, spent [267ms] collecting in the last [1s]	
[2025-03-03T12:05:05,617][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1709] overhead, spent [304ms] collecting in the last [1s]	
[2025-03-03T12:05:06,619][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1710] overhead, spent [261ms] collecting in the last [1s]	
[2025-03-03T12:05:07,625][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1711] overhead, spent [295ms] collecting in the last [1s]	
[2025-03-03T12:05:09,632][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1713] overhead, spent [301ms] collecting in the last [1s]	
[2025-03-03T12:05:10,635][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1714] overhead, spent [277ms] collecting in the last [1s]	
[2025-03-03T12:05:12,648][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1716] overhead, spent [301ms] collecting in the last [1s]	
[2025-03-03T12:05:15,667][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1719] overhead, spent [282ms] collecting in the last [1s]	
[2025-03-03T12:05:16,669][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1720] overhead, spent [253ms] collecting in the last [1s]	
[2025-03-03T12:05:17,672][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1721] overhead, spent [296ms] collecting in the last [1s]	
[2025-03-03T12:05:18,675][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1722] overhead, spent [299ms] collecting in the last [1s]	
[2025-03-03T12:05:19,681][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1723] overhead, spent [287ms] collecting in the last [1s]	
[2025-03-03T12:05:20,698][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1724] overhead, spent [295ms] collecting in the last [1s]	
[2025-03-03T12:05:21,723][INFO ][o.e.m.j.JvmGcMonitorService] [test-cluster-1] [gc][1725] overhead, spent [374ms] collecting in the last [1s]	
[2025-03-03T12:05:22,029][INFO ][o.e.x.e.h.HeapAttackIT   ] [testEnrichExplosionManyMatches] --> test testEnrichExplosionManyMatches triggering OOM after 5m	
[2025-03-03T12:05:22,055][ERROR][o.e.t.e.h.RestTriggerOutOfMemoryAction] [test-cluster-1] triggering out of memory	
java.lang.OutOfMemoryError: Java heap space

[idegtiarenko]

#124300 and corresponding 8.x backport should help to stabilize this test.