Skip to content

[CI] CsvIT test {csv-spec:lookup-join.MvJoinKeyOnTheLookupIndex} failing #143442

@elasticsearchmachine

Description

@elasticsearchmachine

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.CsvIT" -Dtests.method="test {csv-spec:lookup-join.MvJoinKeyOnTheLookupIndex}" -Dtests.seed=E94BE49737A022E -Dtests.locale=fr-MU -Dtests.timezone=Etc/GMT-12 -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected a list containing
0: expected "Line 4:3: evaluation of [LOOKUP JOIN languages_lookup_non_unique_key ON language_code] failed, treating result as null. Only first 20 failures recorded." but was <missing>
1: expected "Line 4:3: java.lang.IllegalArgumentException: LOOKUP JOIN encountered multi-value" but was <missing>

Issue Reasons:

  • [main] 3 failures in test test {csv-spec:lookup-join.MvJoinKeyOnTheLookupIndex} (0.6% fail rate in 522 executions)
  • [main] 2 failures in step part-3 (0.7% fail rate in 307 executions)
  • [main] 2 failures in pipeline elasticsearch-pull-request (0.7% fail rate in 294 executions)

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

Metadata

Metadata

Labels

:Analytics/ES|QLAKA ESQL>test-failureTriaged test failures from CITeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)low-riskAn open issue or test failure that is a low risk to future releases

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions