[CI] EsqlActionTaskIT testCancelRequestWhenFailingFetchingPages failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5261 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic-platform-support #5234 / debian-12_platform-support-unix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.EsqlActionTaskIT.testCancelRequestWhenFailingFetchingPages" -Dtests.seed=B6103446EBC03B2C -Dtests.locale=kn-Knda-IN -Dtests.timezone=Europe/London -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: a string containing "failed to fetch pages"
     but: was "Failed execution"

Issue Reasons:

• [8.x] 2 failures in test testCancelRequestWhenFailingFetchingPages (1.8% fail rate in 113 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] 5 failures in test testCancelRequestWhenFailingFetchingPages (2.6% fail rate in 194 executions)
• [main] 4 failures in step part-3 (4.1% fail rate in 98 executions)
• [main] 4 failures in pipeline elasticsearch-pull-request (4.0% fail rate in 99 executions)

Build Scans:

• elasticsearch-intake #14045 / part3
• elasticsearch-pull-request #45141 / part-3
• elasticsearch-pull-request #45123 / part-3
• elasticsearch-pull-request #45118 / part-3
• elasticsearch-pull-request #45114 / part-3

[elasticsearchmachine]

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