[CI] AggregationsClientYamlTestSuiteIT test {yaml=aggregations/stats_metric_fail_formatting/fail formatting} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #4318 / oraclelinux-8_platform-support-unix
• elasticsearch-periodic #4304 / openjdk17_checkpart1_java-fips-matrix

Reproduction Line:

./gradlew ':modules:aggregations:yamlRestTest' --tests "org.elasticsearch.aggregations.AggregationsClientYamlTestSuiteIT.test {yaml=aggregations/stats_metric_fail_formatting/fail formatting}" -Dtests.seed=980E8D054D575C06 -Dtests.locale=ann -Dtests.timezone=America/Guayaquil -Druntime.java=22

Applicable branches:
8.15

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Failure at [aggregations/stats_metric_fail_formatting:32]: expected [4xx|5xx] status code but api [search] returned [200 OK] [---
took: 6
timed_out: false
_shards:
  total: 2
  successful: 1
  skipped: 0
  failed: 1
  failures:
  - shard: 0
    index: "test_date"
    node: "TV4ngqESQoGBwA9k9qzHqg"
    reason:
      type: "illegal_argument_exception"
      reason: "Cannot format stat [sum] with format [DocValueFormat.DateTime(format[date_hour_minute_second_millis]\
        \ locale[], Z, MILLISECONDS)]"
      caused_by:
        type: "date_time_exception"
        reason: "Field Year cannot be printed as the value 18028 exceeds the maximum\
          \ print width of 4"
hits:
  total:
    value: 0
    relation: "eq"
  max_score: null
  hits: []
aggregations:
  the_stats:
    count: 0
    min: null
    max: null
    avg: null
    sum: 0.0
]

Issue Reasons:

• [8.15] 2 failures in test test {yaml=aggregations/stats_metric_fail_formatting/fail formatting} (0.6% fail rate in 328 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] 4 failures in test test {yaml=aggregations/stats_metric_fail_formatting/fail formatting} (2.6% fail rate in 156 executions)
• [main] 2 failures in step rest-compatibility (11.1% fail rate in 18 executions)
• [main] 2 failures in pipeline elasticsearch-periodic (50.0% fail rate in 4 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (9.5% fail rate in 21 executions)

Build Scans:

• elasticsearch-periodic #4310 / openjdk23_checkrestcompat_java-matrix
• elasticsearch-pull-request #34714 / rest-compatibility
• elasticsearch-pull-request #34713 / rest-compatibility
• elasticsearch-periodic #4298 / single-processor-node-tests

[elasticsearchmachine]

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