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

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #11000 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #35514 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #34531 / 8.16.0_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.16.0#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {categorize.Categorize ASYNC}" -Dtests.seed=DA6FFF5BC79A0E06 -Dtests.bwc=true -Dtests.locale=sg-Latn-CF -Dtests.timezone=America/Adak -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 ASYNC} (0.7% fail rate in 405 executions)
• [8.x] 3 failures in step 8.16.0_bwc-snapshots (1.1% fail rate in 265 executions)
• [8.x] 2 failures in pipeline elasticsearch-pull-request (1.3% fail rate in 150 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 ASYNC} (0.5% fail rate in 794 executions)
• [main] 2 failures in step 8.16.0_bwc-snapshots (0.6% fail rate in 359 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (1.1% fail rate in 275 executions)

Build Scans:

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

[elasticsearchmachine]

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

[elasticsearchmachine]

This has been muted on branch 8.x

Mute Reasons:

• [8.x] 3 failures in test test {categorize.Categorize ASYNC} (0.7% fail rate in 405 executions)
• [8.x] 3 failures in step 8.16.0_bwc-snapshots (1.1% fail rate in 265 executions)
• [8.x] 2 failures in pipeline elasticsearch-pull-request (1.3% fail rate in 150 executions)

Build Scans:

• elasticsearch-intake #11000 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #35514 / 8.16.0_bwc-snapshots
• elasticsearch-pull-request #34531 / 8.16.0_bwc-snapshots

[elasticsearchmachine]

This issue has been closed because it has been open for too long with no activity.

Any muted tests that were associated with this issue have been unmuted.

If the tests begin failing again, a new issue will be opened, and they may be muted again.