[CI] StandardVersusLogsIndexModeRandomDataChallengeRestIT testHistogramAggregation failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #9811 / part1
• elasticsearch-pull-request #31652 / part-1
• elasticsearch-pull-request #31506 / part-1

Reproduction Line:

./gradlew ":modules:data-streams:javaRestTest" --tests "org.elasticsearch.datastreams.logsdb.qa.StandardVersusLogsIndexModeRandomDataChallengeRestIT.testHistogramAggregation" -Dtests.seed=FFFD197B88B36E3D -Dtests.locale=ar-SA -Dtests.timezone=Antarctica/Syowa -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [GET], host [http://[::1]:45305], URI [/logs-apache-contender/_search], status line [HTTP/1.1 500 Internal Server Error]
{"error":{"root_cause":[{"type":"string_index_out_of_bounds_exception","reason":"Range [0, 6) out of bounds for length 5"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"fetch","grouped":true,"failed_shards":[{"shard":0,"index":".ds-logs-apache-contender-2024.09.18-000001","node":"WP2EwvNxTeSSzPK4qbGGRQ","reason":{"type":"string_index_out_of_bounds_exception","reason":"Range [0, 6) out of bounds for length 5"}}],"caused_by":{"type":"string_index_out_of_bounds_exception","reason":"Range [0, 6) out of bounds for length 5","caused_by":{"type":"string_index_out_of_bounds_exception","reason":"Range [0, 6) out of bounds for length 5"}}},"status":500}

Issue Reasons:

• [main] 3 failures in test testHistogramAggregation (1.4% fail rate in 220 executions)
• [main] 2 failures in step part-1 (2.1% fail rate in 96 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (2.1% fail rate in 95 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] 3 failures in test testHistogramAggregation (1.4% fail rate in 220 executions)
• [main] 2 failures in step part-1 (2.1% fail rate in 96 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (2.1% fail rate in 95 executions)

Build Scans:

• elasticsearch-intake #9811 / part1
• elasticsearch-pull-request #31652 / part-1
• elasticsearch-pull-request #31506 / part-1

[elasticsearchmachine]

Pinging @elastic/es-storage-engine (Team:StorageEngine)

[kkrik-es]

Another duplicate.