[CI] MixedClusterEsqlSpecIT test {string.ReverseGraphemeClusters ASYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #4533 / openjdk17_8.16.0_java-fips-matrix-bwc
• elasticsearch-periodic #4533 / openjdk17_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4533 / graalvm-ce17_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4528 / openjdk17_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4528 / openjdk17_8.16.0_java-fips-matrix-bwc
• elasticsearch-periodic #4528 / graalvm-ce17_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4523 / openjdk17_8.16.0_java-fips-matrix-bwc
• elasticsearch-periodic #4523 / openjdk17_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4523 / graalvm-ce17_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4518 / openjdk17_8.16.0_java-fips-matrix-bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.16.0#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {string.ReverseGraphemeClusters ASYNC}" -Dtests.seed=A1F9161D0AB42EB5 -Dtests.bwc=true -Dtests.locale=gd-Latn-GB -Dtests.timezone=Africa/Bissau -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.16

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Data mismatch:
row 0 column 1:a list containing
row 0 column 1:0: expected "ठाीकं💖🎉👍🏽😊ûôîêâùòìèàúóíéá" but was "ीठाकं💖🎉🏽👍😊ûôîêâùòìèàúóíéá"

Issue Reasons:

• [8.16] 3 consecutive failures in test test {string.ReverseGraphemeClusters ASYNC}
• [8.16] 17 consecutive failures in step openjdk17_8.16.0_java-fips-matrix-bwc
• [8.16] 17 consecutive failures in step openjdk17_8.16.0_java-matrix-bwc
• [8.16] 17 consecutive failures in step graalvm-ce17_8.16.0_java-matrix-bwc
• [8.16] 51 failures in test test {string.ReverseGraphemeClusters ASYNC} (25.1% fail rate in 203 executions)
• [8.16] 17 failures in step openjdk17_8.16.0_java-fips-matrix-bwc (100.0% fail rate in 17 executions)
• [8.16] 17 failures in step openjdk17_8.16.0_java-matrix-bwc (100.0% fail rate in 17 executions)
• [8.16] 17 failures in step graalvm-ce17_8.16.0_java-matrix-bwc (100.0% fail rate in 17 executions)
• [8.16] 17 failures in pipeline elasticsearch-periodic (100.0% fail rate in 17 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)

[fang-xing-esql]

A duplicate of #114560.