[CI] MixedClusterClientYamlTestSuiteIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #11577 / 9.0.8_bwc
• elasticsearch-periodic #11577 / 9.0.8_bwc
• elasticsearch-periodic-java-ea #112 / 9.0.8_bwc
• elasticsearch-pull-request #109757 / 9.0.8_bwc
• elasticsearch-pull-request #109747 / 9.0.8_bwc
• elasticsearch-pull-request #109705 / 9.0.8_bwc
• elasticsearch-pull-request #109683 / 9.0.8_bwc
• elasticsearch-pull-request #109661 / 9.0.8_bwc
• elasticsearch-pull-request #109594 / 9.0.8_bwc
• elasticsearch-periodic #11573 / 9.0.8_bwc

Reproduction Line:

./gradlew ":qa:mixed-cluster:v9.0.8#mixedClusterTest" -Dtests.class="org.elasticsearch.backwards.MixedClusterClientYamlTestSuiteIT" -Dtests.method="test {p0=search.highlight/20_fvh/Highlight multiple documents}" -Dtests.seed=822F667AA91F7544 -Dtests.bwc=true -Dtests.locale=pt-PT -Dtests.timezone=Europe/Bratislava -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: org.junit.internal.runners.model.MultipleFailureException: There were 3 errors:
  java.lang.AssertionError(expected [2xx] status code but api [search] returned [500 Internal Server Error] [{"error":{"root_cause":[{"type":"illegal_state_exception","reason":"unexpected docvalues type SORTED_NUMERIC for field 'id' (expected=NUMERIC). Re-index with correct docvalues type.","stack_trace":"org.elasticsearch.ElasticsearchException$1: unexpected docvalues type SORTED_NUMERIC for field 'id' (expected=NUMERIC). Re-index with correct docvalues type.\n\tat org.elasticsearch.server@9.0.8/org.elasticsearch.ElasticsearchException.guessRootCauses(ElasticsearchException.java:758)\n\tat org.elasticsearch.server@9.0.8/org.elasticsearch.action.search.SearchPhaseExecutionException.guessRootCauses(SearchPhaseExecutionException.java:167)\n\tat org.elasticsearch.server@9.0.8/org.elasticsearch.ElasticsearchException.guessRootCauses(ElasticsearchException.java:740)\n\tat org.elasticsea
[truncated]

Issue Reasons:

• [main] 8 consecutive failures in step 9.0.8_bwc
• [main] 25 failures in class org.elasticsearch.backwards.MixedClusterClientYamlTestSuiteIT (2.5% fail rate in 999 executions)
• [main] 19 failures in step 9.0.8_bwc (90.5% fail rate in 21 executions)
• [main] 2 failures in step 9.2.3_part_6_bwc-snapshots (0.8% fail rate in 236 executions)
• [main] 2 failures in step 8.19.9_part_6_bwc-snapshots (0.8% fail rate in 237 executions)
• [main] 2 failures in step 9.1.9_part_6_bwc-snapshots (0.8% fail rate in 236 executions)
• [main] 2 failures in pipeline elasticsearch-periodic (100.0% fail rate in 2 executions)
• [main] 15 failures in pipeline elasticsearch-pull-request (5.9% fail rate in 256 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

Pinging @elastic/es-delivery (Team:Delivery)

[neilbhavsar]

Likely product issue needs to be assigned to product team