[CI] ManyShardsIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8347 / openjdk21_checkpart3_java-fips-matrix
• elasticsearch-periodic #8347 / openjdk21_checkpart3_java-matrix
• elasticsearch-periodic #8341 / openjdk21_checkpart3_java-fips-matrix
• elasticsearch-periodic #8341 / openjdk21_checkpart3_java-matrix
• elasticsearch-periodic #8335 / openjdk21_checkpart3_java-fips-matrix
• elasticsearch-periodic #8335 / openjdk21_checkpart3_java-matrix
• elasticsearch-pull-request #72013 / part-3
• elasticsearch-periodic #8327 / openjdk21_checkpart3_java-matrix
• elasticsearch-periodic #8327 / openjdk21_checkpart3_java-fips-matrix
• elasticsearch-periodic #8318 / openjdk21_checkpart3_java-fips-matrix

Reproduction Line:

undefined

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

undefined

Issue Reasons:

• [main] 2 consecutive failures in class org.elasticsearch.xpack.esql.action.ManyShardsIT
• [main] 21 consecutive failures in step openjdk21_checkpart3_java-fips-matrix
• [main] 20 consecutive failures in step openjdk21_checkpart3_java-matrix
• [main] 42 failures in class org.elasticsearch.xpack.esql.action.ManyShardsIT (4.9% fail rate in 856 executions)
• [main] 21 failures in step openjdk21_checkpart3_java-fips-matrix (100.0% fail rate in 21 executions)
• [main] 20 failures in step openjdk21_checkpart3_java-matrix (100.0% fail rate in 20 executions)
• [main] 21 failures in pipeline elasticsearch-periodic (95.5% fail rate in 22 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)