[CI] MultiClusterSpecIT test {categorize.On REVERSE(CONCAT())} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8851 / openjdk17_8.17.8_java-fips-matrix-bwc
• elasticsearch-periodic #8851 / graalvm-ce17_8.17.8_java-matrix-bwc
• elasticsearch-periodic #8851 / openjdk17_8.18.3_java-fips-matrix-bwc
• elasticsearch-periodic #8851 / openjdk17_8.17.8_java-matrix-bwc
• elasticsearch-periodic #8851 / openjdk17_8.19.0_java-fips-matrix-bwc
• elasticsearch-periodic #8851 / graalvm-ce17_8.18.3_java-matrix-bwc
• elasticsearch-periodic #8851 / openjdk17_8.18.3_java-matrix-bwc
• elasticsearch-periodic #8851 / openjdk17_8.19.0_java-matrix-bwc
• elasticsearch-periodic #8851 / graalvm-ce17_8.19.0_java-matrix-bwc
• elasticsearch-periodic #8845 / openjdk17_8.17.8_java-fips-matrix-bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v8.17.8#bwcTest" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {categorize.On REVERSE(CONCAT())}" -Dtests.seed=181241041C10D5CC -Dtests.bwc=true -Dtests.locale=cgg -Dtests.timezone=Asia/Riyadh -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.19

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 ".*?😊.+?👍🏽.+?detcennocsiD.*?" but was ".*?😊🏽.+?👍.+?detcennocsiD.*?"
row 1 column 1:a list containing
row 1 column 1:0: expected ".*?😊.+?👍🏽.+?ot.+?detcennoC.*?" but was ".*?😊🏽.+?👍.+?ot.+?detcennoC.*?"
row 2 column 1:a list containing
row 2 column 1:0: expected ".*?😊.+?👍🏽.+?rorre.+?noitcennoC.*?" but was ".*?😊🏽.+?👍.+?rorre.+?noitcennoC.*?"
Actual:
COUNT():long | category:keyword
1            | .*?😊🏽.+?👍.+?detcennocsiD.*?
3            | .*?😊🏽.+?👍.+?ot.+?detcennoC.*?
3            | .*?😊🏽.+?👍.+?rorre.+?noitcennoC.*?

Expected:
COUNT():long | category:keyword
1            | .*?😊.+?👍🏽.+?detcennocsiD.*?
3            | .*?😊.+?👍🏽.+?ot.+?detcennoC.*?
3            | .*?😊.+?👍🏽.+?rorre.+?noitcennoC.*?

Issue Reasons:

• [8.19] 3 consecutive failures in step openjdk17_8.17.8_java-fips-matrix-bwc
• [8.19] 3 consecutive failures in step graalvm-ce17_8.17.8_java-matrix-bwc
• [8.19] 3 consecutive failures in step openjdk17_8.18.3_java-fips-matrix-bwc
• [8.19] 3 consecutive failures in step openjdk17_8.17.8_java-matrix-bwc
• [8.19] 3 consecutive failures in step openjdk17_8.19.0_java-fips-matrix-bwc
• [8.19] 3 consecutive failures in step graalvm-ce17_8.18.3_java-matrix-bwc
• [8.19] 3 consecutive failures in step openjdk17_8.18.3_java-matrix-bwc
• [8.19] 3 consecutive failures in step openjdk17_8.19.0_java-matrix-bwc
• [8.19] 3 consecutive failures in step graalvm-ce17_8.19.0_java-matrix-bwc
• [8.19] 27 failures in test test {categorize.On REVERSE(CONCAT())} (12.2% fail rate in 222 executions)
• [8.19] 3 failures in step openjdk17_8.17.8_java-fips-matrix-bwc (100.0% fail rate in 3 executions)
• [8.19] 3 failures in step graalvm-ce17_8.17.8_java-matrix-bwc (100.0% fail rate in 3 executions)
• [8.19] 3 failures in step openjdk17_8.18.3_java-fips-matrix-bwc (100.0% fail rate in 3 executions)
• [8.19] 3 failures in step openjdk17_8.17.8_java-matrix-bwc (100.0% fail rate in 3 executions)
• [8.19] 3 failures in step openjdk17_8.19.0_java-fips-matrix-bwc (100.0% fail rate in 3 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)