[CI] MixedClusterEsqlSpecIT test {csv-spec:stats.CountDistinctWithConditions} failing #134993
Description
Build Scans:
- elasticsearch-intake #28645 / 9.0.8_bwc-snapshots
- elasticsearch-intake #28644 / 9.0.8_bwc-snapshots
- elasticsearch-intake #28643 / 9.0.8_bwc-snapshots
- elasticsearch-intake #28641 / 9.0.8_bwc-snapshots
- elasticsearch-pull-request #93212 / 9.0.8_part_3_bwc-snapshots
- elasticsearch-pull-request #92568 / 9.1.4_part_3_bwc-snapshots
- elasticsearch-pull-request #92568 / 9.0.7_part_3_bwc-snapshots
- elasticsearch-pull-request #92568 / 8.19.4_part_3_bwc-snapshots
- elasticsearch-pull-request #92521 / 9.1.4_part_3_bwc-snapshots
- elasticsearch-pull-request #92521 / 8.19.4_part_3_bwc-snapshots
Reproduction Line:
./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v9.0.8#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {csv-spec:stats.CountDistinctWithConditions}" -Dtests.seed=48509ED24BF7EB86 -Dtests.bwc=true -Dtests.locale=ar-QA -Dtests.timezone=Atlantic/Canary -Druntime.java=24 Applicable branches:
main
Reproduces locally?:
N/A
Failure History:
See dashboard
Failure Message:
org.elasticsearch.client.ResponseException: method [GET], host [http://[::1]:35291], URI [/_query/async/FmpaN0FHeDZ3U19tVXZROFV0aHFtckEcaGZYamxyUHdURDJmazZJM3BtLVJPZzoyNTk0Ng==?wait_for_completion_timeout=6000s&pretty=true&error_trace=true], status line [HTTP/1.1 400 Bad Request] Warnings: [No limit defined, adding default limit of [1000]] { "error" : { "root_cause" : [ { "type" : "verification_exception", "reason" : "verification_exception: Found 1 problem\nline 3:21: Unknown function [TO_AGGREGATE_METRIC_DOUBLE]", "stack_trace" : "org.elasticsearch.xpack.esql.VerificationException: verification_exception: Found 1 problem\nline 3:21: Unknown function [TO_AGGREGATE_METRIC_DOUBLE]\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.verify(Analyzer.java:194)\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.analyze(Analyzer.java:188)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.lambda$analyzedPlan$7(EsqlSession.java:317)\n\tat org.elastic [truncated] Issue Reasons:
- [main] 4 consecutive failures in step 9.0.8_bwc-snapshots
- [main] 4 consecutive failures in step 9.0.7_part_3_bwc-snapshots
- [main] 20 failures in test test {csv-spec:stats.CountDistinctWithConditions} (3.5% fail rate in 572 executions)
- [main] 4 failures in step 9.0.8_bwc-snapshots (80.0% fail rate in 5 executions)
- [main] 3 failures in step pr-upgrade-part-3 (0.7% fail rate in 414 executions)
- [main] 4 failures in step 8.19.4_part_3_bwc-snapshots (22.2% fail rate in 18 executions)
- [main] 4 failures in step 9.1.4_part_3_bwc-snapshots (22.2% fail rate in 18 executions)
- [main] 4 failures in step 9.0.7_part_3_bwc-snapshots (100.0% fail rate in 4 executions)
- [main] 4 failures in pipeline elasticsearch-intake (4.1% fail rate in 97 executions)
- [main] 5 failures in pipeline elasticsearch-pull-request (1.2% fail rate in 414 executions)
Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.