[CI] XPackRestIT test {p0=esql/60_usage/Basic ESQL usage output (telemetry) non-snapshot version} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5216 / release-tests
• elasticsearch-pull-request #44738 / release-tests
• elasticsearch-periodic #5210 / release-tests
• elasticsearch-pull-request #44655 / release-tests
• elasticsearch-periodic #5204 / release-tests
• elasticsearch-periodic #5174 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:yamlRestTest" --tests "org.elasticsearch.xpack.test.rest.XPackRestIT.test {p0=esql/60_usage/Basic ESQL usage output (telemetry) non-snapshot version}" -Dtests.seed=E6C22E69350F89EA -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=lag-TZ -Dtests.timezone=Asia/Khandyga -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Failure at [esql/60_usage:166]: field [esql.functions] doesn't have length [123]
Expected: <123>
     but: was <124>

Issue Reasons:

• [main] 5 consecutive failures in test test {p0=esql/60_usage/Basic ESQL usage output (telemetry) non-snapshot version}
• [main] 5 consecutive failures in step release-tests
• [main] 3 consecutive failures in pipeline elasticsearch-periodic
• [main] 2 consecutive failures in pipeline elasticsearch-pull-request
• [main] 6 failures in test test {p0=esql/60_usage/Basic ESQL usage output (telemetry) non-snapshot version} (54.5% fail rate in 11 executions)
• [main] 6 failures in step release-tests (54.5% fail rate in 11 executions)
• [main] 4 failures in pipeline elasticsearch-periodic (66.7% fail rate in 6 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (40.0% fail rate in 5 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] 2 failures in test test {p0=esql/60_usage/Basic ESQL usage output (telemetry) non-snapshot version} (8.0% fail rate in 25 executions)

Build Scans:

• elasticsearch-periodic #5174 / release-tests
• elasticsearch-pull-request #43368 / part-3

[elasticsearchmachine]

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

[luigidellaquila]

Most likely due to #117838