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

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5117 / graalvm-ce17_checkpart3_java-matrix
• elasticsearch-periodic #5117 / openjdk17_checkpart3_java-matrix
• elasticsearch-periodic #5117 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic #5111 / openjdk17_checkpart3_java-matrix
• elasticsearch-periodic #5111 / graalvm-ce17_checkpart3_java-matrix
• elasticsearch-periodic #5111 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic #5105 / openjdk17_checkpart3_java-matrix
• elasticsearch-periodic #5105 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic #5105 / graalvm-ce17_checkpart3_java-matrix
• elasticsearch-periodic #5099 / graalvm-ce17_checkpart3_java-matrix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {categorize.On REVERSE(CONCAT()) SYNC}" -Dtests.seed=8F742372EDC44D91 -Dtests.locale=km-KH -Dtests.timezone=America/Recife -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.x

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.*?"

Issue Reasons:

• [8.x] 4 consecutive failures in step graalvm-ce17_checkpart3_java-matrix
• [8.x] 4 consecutive failures in step openjdk17_checkpart3_java-matrix
• [8.x] 4 consecutive failures in step openjdk17_checkpart3_java-fips-matrix
• [8.x] 12 failures in test test {categorize.On REVERSE(CONCAT()) SYNC} (10.0% fail rate in 120 executions)
• [8.x] 4 failures in step graalvm-ce17_checkpart3_java-matrix (100.0% fail rate in 4 executions)
• [8.x] 4 failures in step openjdk17_checkpart3_java-matrix (100.0% fail rate in 4 executions)
• [8.x] 4 failures in step openjdk17_checkpart3_java-fips-matrix (100.0% fail rate in 4 executions)
• [8.x] 4 failures in pipeline elasticsearch-periodic (100.0% fail rate in 4 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)

[ivancea]

Same as:
#117707
#117708
#117713