[CI] MultiClusterSpecIT test {categorize.Categorize} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #12577 / 8.16.0_bwc-snapshots
• elasticsearch-intake #12575 / 8.16.0_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v8.16.0#bwcTest" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {categorize.Categorize}" -Dtests.seed=8988D753C1815663 -Dtests.bwc=true -Dtests.locale=dje -Dtests.timezone=America/Argentina/San_Luis -Druntime.java=23

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] 2 consecutive failures in step 8.16.0_bwc-snapshots
• [8.x] 2 failures in test test {categorize.Categorize} (1.6% fail rate in 125 executions)
• [8.x] 2 failures in step 8.16.0_bwc-snapshots (5.3% fail rate in 38 executions)
• [8.x] 2 failures in pipeline elasticsearch-intake (8.7% fail rate in 23 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 8.x

Mute Reasons:

• [8.x] 2 consecutive failures in step 8.16.0_bwc-snapshots
• [8.x] 2 failures in test test {categorize.Categorize} (1.6% fail rate in 125 executions)
• [8.x] 2 failures in step 8.16.0_bwc-snapshots (5.3% fail rate in 38 executions)
• [8.x] 2 failures in pipeline elasticsearch-intake (8.7% fail rate in 23 executions)

Build Scans:

• elasticsearch-intake #12577 / 8.16.0_bwc-snapshots
• elasticsearch-intake #12575 / 8.16.0_bwc-snapshots

[elasticsearchmachine]

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