Build Scans:

• elasticsearch-intake #36762 / bc-upgrade-tests-part3
• elasticsearch-intake #36761 / bc-upgrade-tests-part3
• elasticsearch-intake #36760 / bc-upgrade-tests-part3
• elasticsearch-intake #36759 / bc-upgrade-tests-part3
• elasticsearch-intake #36757 / bc-upgrade-tests-part3
• elasticsearch-pull-request #133301 / pr-upgrade-part-3
• elasticsearch-pull-request #132934 / 9.2.8_part_3_bwc-snapshots
• elasticsearch-pull-request #132934 / 9.3.3_part_3_bwc-snapshots
• elasticsearch-pull-request #132900 / 9.3.3_part_3_bwc-snapshots
• elasticsearch-pull-request #132900 / 8.19.14_part_3_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:bcUpgradeTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {csv-spec:external-basic.topSnippetsFunction}" -Dtests.seed=EE63692E714CFF53 -Dtests.bwc.main.version=9.4.0-SNAPSHOT -Dtests.bwc.refspec.main=d4f31dec6b2cedb5990f120250b5fe630888e745 -Dtests.locale=zh-Hans-SG -Dtests.timezone=America/Argentina/Ushuaia -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Different column type for column [title] (KEYWORD != TEXT) expected:<KEYWORD> but was:<TEXT>

Issue Reasons:

• [main] 1 consecutive failures in test test {csv-spec:external-basic.topSnippetsFunction}
• [main] 5 consecutive failures in step bc-upgrade-tests-part3
• [main] 2 consecutive failures in step 9.2.8_part_3_bwc-snapshots
• [main] 2 consecutive failures in step 9.3.3_part_3_bwc-snapshots
• [main] 1 consecutive failures in step 8.19.14_part_3_bwc-snapshots
• [main] 5 consecutive failures in pipeline elasticsearch-intake
• [main] 12 failures in test test {csv-spec:external-basic.topSnippetsFunction} (2.1% fail rate in 570 executions)
• [main] 5 failures in step bc-upgrade-tests-part3 (5.1% fail rate in 99 executions)
• [main] 2 failures in step pr-upgrade-part-3 (0.4% fail rate in 466 executions)
• [main] 2 failures in step 9.2.8_part_3_bwc-snapshots (100.0% fail rate in 2 executions)
• [main] 2 failures in step 9.3.3_part_3_bwc-snapshots (100.0% fail rate in 2 executions)
• [main] 5 failures in pipeline elasticsearch-intake (5.1% fail rate in 99 executions)
• [main] 4 failures in pipeline elasticsearch-pull-request (0.9% fail rate in 466 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.