[CI] EsqlNodeFailureIT testFailureLoadingFields failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #17772 / part3
• elasticsearch-pull-request #56163 / part-3
• elasticsearch-periodic #6286 / single-processor-node-tests
• elasticsearch-pull-request #55807 / part-3
• elasticsearch-pull-request #55605 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.EsqlNodeFailureIT.testFailureLoadingFields" -Dtests.seed=2C7EA0BE99BF339E -Dtests.locale=cs-CZ -Dtests.timezone=Pacific/Saipan -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

junit.framework.AssertionFailedError: Unexpected exception type, expected IllegalStateException but got [ok/8uQcn207Q0ia3A91OZz9JA][[ok][4]] org.elasticsearch.action.NoShardAvailableActionException: no shard copies found

Issue Reasons:

• [main] 5 failures in test testFailureLoadingFields (1.4% fail rate in 359 executions)
• [main] 3 failures in step part-3 (2.8% fail rate in 107 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (2.8% fail rate in 108 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] 3 failures in test testFailureLoadingFields (1.3% fail rate in 240 executions)
• [main] 2 failures in step part-3 (3.5% fail rate in 57 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (3.6% fail rate in 56 executions)

Build Scans:

• elasticsearch-periodic #6286 / single-processor-node-tests
• elasticsearch-pull-request #55807 / part-3
• elasticsearch-pull-request #55605 / part-3

[elasticsearchmachine]

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

[alex-spies]

Got a fresh build scan with another failure: https://gradle-enterprise.elastic.co/s/rqtnzpknfnsyg/tests/task/:x-pack:plugin:esql:internalClusterTest/details/org.elasticsearch.xpack.esql.action.EsqlNodeFailureIT/testFailureLoadingFields?top-execution=1

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 5 failures in test testFailureLoadingFields (1.4% fail rate in 359 executions)
• [main] 3 failures in step part-3 (2.8% fail rate in 107 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (2.8% fail rate in 108 executions)

Build Scans:

• elasticsearch-intake #17772 / part3
• elasticsearch-pull-request #56163 / part-3
• elasticsearch-periodic #6286 / single-processor-node-tests
• elasticsearch-pull-request #55807 / part-3
• elasticsearch-pull-request #55605 / part-3