[CI] EnrichIT testAvgDurationByArtist failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #6527 / oraclelinux-9_platform-support-unix
• elasticsearch-pull-request #58092 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.EnrichIT.testAvgDurationByArtist" -Dtests.seed=BC97B63594E42D7C -Dtests.locale=naq -Dtests.timezone=Africa/Gaborone -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: an empty collection
     but: <[LEAK: resource was not cleaned up before it was garbage-collected.
Recent access records: 
Created at:
	in [elasticsearch[main-cluster-0][search][T#2]][testStopQueryLocal]
	org.elasticsearch.search.internal.SearchContext.<init>(SearchContext.java:79)
	org.elasticsearch.search.DefaultSearchContext.<init>(DefaultSearchContext.java:172)
	org.elasticsearch.search.SearchService.createSearchContext(SearchService.java:1191)
	org.elasticsearch.search.SearchService.createSearchContext(SearchService.java:1166)
	org.elasticsearch.xpack.esql.plugin.DataNodeComputeHandler$DataNodeRequestExecutor.lambda$acquireSearchContexts$5(DataNodeComputeHandler.java:318)
	org.elasticsearch.action.ActionRunnable$2.accept(ActionRunnable.java:58)
	org.elasticsearch.action.ActionRunnable$2.accept(ActionRunnable.java:55)
	org.elasticsearch.action.ActionRunnable$4.doRun(ActionRunnable.java:101)
	org.elasticsearch.common.util.concurrent.AbstractRunna
[truncated]

Issue Reasons:

• [main] 2 failures in test testAvgDurationByArtist (0.5% fail rate in 421 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 testAvgDurationByArtist (0.5% fail rate in 421 executions)

Build Scans:

• elasticsearch-periodic-platform-support #6527 / oraclelinux-9_platform-support-unix
• elasticsearch-pull-request #58092 / part-3

[elasticsearchmachine]

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

[dnhatn]

I'm closing this issue since this test wasn't the problem in those two CI failures. I’ll open a PR to re-enable this test.