[CI] MixedClusterEsqlSpecIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #9262 / 8.13.4_bwc
• elasticsearch-periodic #9262 / 8.14.3_bwc
• elasticsearch-periodic #9262 / 8.11.4_bwc
• elasticsearch-periodic #9262 / 8.12.2_bwc
• elasticsearch-pull-request #79883 / 8.18.4_part_3_bwc-snapshots
• elasticsearch-pull-request #79839 / 8.18.4_part_3_bwc-snapshots
• elasticsearch-periodic #9255 / 8.12.2_bwc
• elasticsearch-periodic #9255 / 8.11.4_bwc
• elasticsearch-periodic #9255 / 8.13.4_bwc
• elasticsearch-periodic #9248 / 8.13.4_bwc

Reproduction Line:

undefined

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

undefined

Issue Reasons:

• [8.19] 21 consecutive failures in step 8.13.4_bwc
• [8.19] 5 consecutive failures in step 8.11.4_bwc
• [8.19] 21 consecutive failures in step 8.12.2_bwc
• [8.19] 76 failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT (12.1% fail rate in 630 executions)
• [8.19] 21 failures in step 8.13.4_bwc (100.0% fail rate in 21 executions)
• [8.19] 12 failures in step 8.14.3_bwc (57.1% fail rate in 21 executions)
• [8.19] 17 failures in step 8.11.4_bwc (81.0% fail rate in 21 executions)
• [8.19] 21 failures in step 8.12.2_bwc (100.0% fail rate in 21 executions)
• [8.19] 4 failures in step 8.18.4_part_3_bwc-snapshots (6.7% fail rate in 60 executions)
• [8.19] 21 failures in pipeline elasticsearch-periodic (100.0% fail rate in 21 executions)
• [8.19] 4 failures in pipeline elasticsearch-pull-request (6.8% fail rate in 59 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)

[mark-vieira]

I've muted this test suite in e59e98e since it's causing loads of failures the past few days. We should prioritize getting this fixed since the entire test suite is muted.