[CI] CrossClusterEsqlRCS1EnrichUnavailableRemotesIT testEsqlEnrichWithSkipUnavailable failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #9091 / windows-2022_checkpart4_platform-support-windows
• elasticsearch-periodic-platform-support #9013 / windows-2019_checkpart4_platform-support-windows
• elasticsearch-pull-request #77898 / part-4

Reproduction Line:

gradlew ":x-pack:plugin:security:qa:multi-cluster:javaRestTest" --tests "org.elasticsearch.xpack.remotecluster.CrossClusterEsqlRCS1EnrichUnavailableRemotesIT.testEsqlEnrichWithSkipUnavailable" -Dtests.seed=781E9733DF5DD0DB -Dtests.locale=ru-KZ -Dtests.timezone=America/Dominica -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: test: esqlEnrichWithSkipUnavailableTrue: id
Expected: is <1>
     but: was <2>

Issue Reasons:

• [8.19] 3 failures in test testEsqlEnrichWithSkipUnavailable (0.9% fail rate in 340 executions)
• [8.19] 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]

Pinging @elastic/es-search-foundations (Team:Search Foundations)

[smalyshev]

@pawankartik-elastic IIRC it's your test? Please take a look.