[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&_a=(controlGroupInput:(chainingSystem:HIERARCHICAL,controlStyle:twoLine,ignoreParentSettings:(ignoreFilters:!f,ignoreQuery:!f,ignoreTimerange:!f,ignoreValidations:!t),panels:('0c0c9cb8-ccd2-45c6-9b13-96bac4abc542':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:task.keyword,grow:!t,id:'0c0c9cb8-ccd2-45c6-9b13-96bac4abc542',searchTechnique:wildcard,selectedOptions:!(),singleSelect:!t,title:'Gradle%20Task',width:medium),grow:!t,order:0,type:optionsListControl,width:small),'144933da-5c1b-4257-a969-7f43455a7901':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:name.keyword,grow:!t,id:'144933da-5c1b-4257-a969-7f43455a7901',searchTechnique:wildcard,selectedOptions:!('test%20%7Bcategorize.Categorize%20SYNC%7D'),title:Test,width:medium),grow:!t,order:2,type:optionsListControl,width:medium),'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:className.keyword,grow:!t,id:'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850',searchTechnique:wildcard,selectedOptions:!('org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT'),title:Suite,width:medium),grow:!t,order:1,type:optionsListControl,width:medium)))))

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)