[CI] EsqlClientYamlIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8393 / 8.11.4_bwc
• elasticsearch-periodic #8393 / 8.13.4_bwc
• elasticsearch-periodic #8387 / 8.12.2_bwc
• elasticsearch-periodic #8381 / 8.13.4_bwc
• elasticsearch-periodic #8375 / 8.13.4_bwc
• elasticsearch-periodic #8369 / 8.13.4_bwc
• elasticsearch-periodic #8363 / 8.13.4_bwc
• elasticsearch-periodic #8363 / 8.12.2_bwc
• elasticsearch-periodic #8351 / 8.15.5_bwc
• elasticsearch-periodic #8351 / 8.13.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#yamlRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.EsqlClientYamlIT" -Dtests.method="test {p0=esql/160_union_types/load single index ip_long and aggregate client_ip my message}" -Dtests.seed=5238F3759C7EA17A -Dtests.bwc=true -Dtests.locale=ar-SO -Dtests.timezone=MIT -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: circuit breakers not reset to 0Expected a map containing
estimated_size_in_bytes: expected <0> but was <368>
         estimated_size: expected "0b" but was "368b"
               overhead: <1.0> unexpected but ok
    limit_size_in_bytes: <322122547> unexpected but ok
             limit_size: "307.1mb" unexpected but ok
                tripped: <0> unexpected but ok

Issue Reasons:

• [8.19] 24 failures in class org.elasticsearch.xpack.esql.qa.mixed.EsqlClientYamlIT (3.8% fail rate in 627 executions)
• [8.19] 2 failures in step 8.11.4_bwc (14.3% fail rate in 14 executions)
• [8.19] 12 failures in step 8.13.4_bwc (57.1% fail rate in 21 executions)
• [8.19] 3 failures in step 8.14.3_bwc (15.0% fail rate in 20 executions)
• [8.19] 6 failures in step 8.12.2_bwc (46.2% fail rate in 13 executions)
• [8.19] 15 failures in pipeline elasticsearch-periodic (71.4% fail rate in 21 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)

[idegtiarenko]

Closed by #128452