[CI] CrossClusterQueryWithFiltersIT testFilterWithMissingRemoteIndex failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #9114 / rocky-9_platform-support-unix
• elasticsearch-periodic #9063 / openjdk21_checkpart3_java-matrix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.CrossClusterQueryWithFiltersIT.testFilterWithMissingRemoteIndex" -Dtests.seed=122F9E421935B8A8 -Dtests.locale=zh-Hans-CN -Dtests.timezone=Europe/Berlin -Druntime.java=24

Applicable branches:
9.1

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

junit.framework.AssertionFailedError: Unexpected exception type, expected RemoteException but got org.elasticsearch.ElasticsearchTimeoutException: java.util.concurrent.TimeoutException: Timeout waiting for task.

Issue Reasons:

• [9.1] 2 failures in test testFilterWithMissingRemoteIndex (1.4% fail rate in 140 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)

[smalyshev]

I suspect from the logs that this may be caused by #130292 fix not being there yet, as the run is from commit 741a4a0294c406a8b38326e8234d94cdd617f541 and the fix was merged later. Let's wait and see if it happens again on fresher code.