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

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #4760 / openjdk22_checkpart3_java-matrix
• elasticsearch-intake #12393 / part3

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.Categorize SYNC}" -Dtests.seed=6ED48B5D1C6338B5 -Dtests.locale=fr-Latn-FR -Dtests.timezone=America/Tijuana -Druntime.java=22

Applicable branches:
8.16

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.16] 2 failures in test test {categorize.Categorize SYNC} (1.0% fail rate in 209 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] 3 failures in test test {categorize.Categorize SYNC} (3.2% fail rate in 95 executions)
• [main] 2 failures in step part-3 (4.8% fail rate in 42 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (4.7% fail rate in 43 executions)

Build Scans:

• elasticsearch-periodic #4094 / openjdk21_checkpart3_java-matrix
• elasticsearch-pull-request #31541 / part-3
• elasticsearch-pull-request #31512 / part-3

[elasticsearchmachine]

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

[jan-elastic]

#113089

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 4 failures in test test {categorize.Categorize SYNC} (2.2% fail rate in 181 executions)
• [main] 2 failures in step part-3 (2.0% fail rate in 102 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (2.0% fail rate in 102 executions)

Build Scans:

• elasticsearch-intake #9884 / part3
• elasticsearch-periodic #4094 / openjdk21_checkpart3_java-matrix
• elasticsearch-pull-request #31541 / part-3
• elasticsearch-pull-request #31512 / part-3