[CI] MixedClusterEsqlSpecIT class failing

elasticsearchmachine commented 3 months ago

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {keep.ShadowingInternalWildcardAndExplicit SYNC}" -Dtests.seed=D7ACD760C5230FD4 -Dtests.bwc=true -Dtests.locale=is-IS -Dtests.timezone=Europe/Zurich -Druntime.java=22

Applicable branches: main

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:!('org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT'),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: Different number of columns returned; expected [emp_no, first_name, languages, last_name, gender] but actual was [last_name, emp_no, last_name, first_name, last_name, languages, last_name, gender, last_name]
Expected: a collection with size <5>
     but: collection size was <9>

Issue Reasons:

[main] 5 consecutive failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT
[main] 5 consecutive failures in step 8.11.4_bwc
[main] 4 consecutive failures in pipeline elasticsearch-periodic
[main] 9 failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT (56.3% fail rate in 16 executions)
[main] 9 failures in step 8.11.4_bwc (56.3% fail rate in 16 executions)
[main] 8 failures in pipeline elasticsearch-periodic (53.3% fail rate in 15 executions)

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

elasticsearchmachine commented 3 months ago

This has been muted on branch main

Mute Reasons:

[main] 5 consecutive failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT
[main] 5 consecutive failures in step 8.11.4_bwc
[main] 4 consecutive failures in pipeline elasticsearch-periodic
[main] 9 failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT (56.3% fail rate in 16 executions)
[main] 9 failures in step 8.11.4_bwc (56.3% fail rate in 16 executions)
[main] 8 failures in pipeline elasticsearch-periodic (53.3% fail rate in 15 executions)

Build Scans:

elasticsearchmachine commented 3 months ago

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

nik9000 commented 3 months ago

Marking this with the blocker risk because it disables lots of our backwards compatibility tests.

elastic / elasticsearch

[CI] MixedClusterEsqlSpecIT class failing #110978