[CI] MixedClusterEsqlSpecIT test {categorize.Categorize SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #4509 / 8.17.0_bwc
• elasticsearch-periodic #4484 / openjdk22_8.16.0_java-matrix-bwc
• elasticsearch-periodic #4425 / 8.16.0_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.17.0#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {categorize.Categorize SYNC}" -Dtests.seed=59AF13CA95DCEFE0 -Dtests.bwc=true -Dtests.locale=th-Thai-TH -Dtests.timezone=Europe/Gibraltar -Druntime.java=22

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Data mismatch:
row 0 column 0:a list containing
row 0 column 0:0: expected "3" but was "1"
row 0 column 1:a list containing
row 0 column 1:0: expected "[Connected to 10.1.0.1, Connected to 10.1.0.2, Connected to 10.1.0.3]" but was "Disconnected"
row 1 column 1:a list containing
row 1 column 1:0: expected "Connection error" but was "[Connected to 10.1.0.1, Connected to 10.1.0.2, Connected to 10.1.0.3]"
row 2 column 0:a list containing
row 2 column 0:0: expected "1" but was "3"
row 2 column 1:a list containing
row 2 column 1:0: expected "Disconnected" but was "Connection error"

Issue Reasons:

• [8.x] 3 failures in test test {categorize.Categorize SYNC} (0.6% fail rate in 498 executions)
• [8.x] 3 failures in pipeline elasticsearch-periodic (16.7% fail rate in 18 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] 4 failures in test test {categorize.Categorize SYNC} (0.5% fail rate in 795 executions)
• [main] 3 failures in step 8.16.0_bwc-snapshots (0.8% fail rate in 359 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (1.1% fail rate in 276 executions)

Build Scans:

• elasticsearch-intake #10313 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #33001 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #32838 / 9.0.0_bwc-snapshots
• elasticsearch-pull-request #32738 / 8.16.0_bwc-snapshots

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)