Skip to content

[CI] MultiClusterSpecIT test {csv-spec:lookup-join.MvJoinKeyOnFrom} failing #132554

Closed
#132744
Closed
[CI] MultiClusterSpecIT test {csv-spec:lookup-join.MvJoinKeyOnFrom} failing#132554
#132744
Assignees
ivancea
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

Description

@elasticsearchmachine
elasticsearchmachine
opened on Aug 7, 2025

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v9.1.1#newToOld" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {csv-spec:lookup-join.MvJoinKeyOnFrom}" -Dtests.seed=75613A2986A82F13 -Dtests.bwc=true -Dtests.locale=ar-MR -Dtests.timezone=Etc/GMT-3 -Druntime.java=21

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 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] 6 failures in test test {csv-spec:lookup-join.MvJoinKeyOnFrom} (0.9% fail rate in 669 executions)
  • [main] 2 failures in step 9.0.5_part_3_bwc-snapshots (2.9% fail rate in 68 executions)
  • [main] 2 failures in pipeline elasticsearch-pull-request (2.9% fail rate in 70 executions)

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

Activity

  1. elasticsearchmachine
    added
    >test-failureTriaged test failures from CI
    :Analytics/ES|QLAKA ESQL
    on Aug 7, 2025

  2. elasticsearchmachine commented on Aug 7, 2025

    @elasticsearchmachine
    elasticsearchmachine
    on Aug 7, 2025
    CollaboratorAuthor

    This has been muted on branch main

    Mute Reasons:

    • [main] 6 failures in test test {csv-spec:lookup-join.MvJoinKeyOnFrom} (0.9% fail rate in 669 executions)
    • [main] 2 failures in step 9.0.5_part_3_bwc-snapshots (2.9% fail rate in 68 executions)
    • [main] 2 failures in pipeline elasticsearch-pull-request (2.9% fail rate in 70 executions)

    Build Scans:

  3. elasticsearchmachine
    added a commit that references this issue on Aug 7, 2025

    Mute org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT test {csv-sp…

    58f050a
  4. elasticsearchmachine
    added
    Team:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)
    needs:riskRequires assignment of a risk label (low, medium, blocker)
    on Aug 7, 2025

  5. elasticsearchmachine commented on Aug 7, 2025

    @elasticsearchmachine
    elasticsearchmachine
    on Aug 7, 2025
    CollaboratorAuthor

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

  6. alex-spies commented on Aug 11, 2025

    @alex-spies
    alex-spies
    on Aug 11, 2025
    Contributor

    This is just #130296 and #128030 after renaming the tests.

  7. alex-spies
    assigned
    ivancea
    on Aug 11, 2025
  8. alex-spies
    marked [CI] EsqlSpecIT test {lookup-join.MvJoinKeyOnTheLookupIndex ASYNC} failing #128030 as a duplicate of this issue on Aug 11, 2025
  9. alex-spies
    marked [CI] EsqlSpecIT test {lookup-join.MvJoinKeyOnFrom SYNC} failing #130296 as a duplicate of this issue on Aug 11, 2025
  10. alex-spies
    added
    low-riskAn open issue or test failure that is a low risk to future releases
    and removed
    needs:riskRequires assignment of a risk label (low, medium, blocker)
    on Aug 11, 2025
  11. ivancea
    unmarked [CI] EsqlSpecIT test {lookup-join.MvJoinKeyOnTheLookupIndex ASYNC} failing #128030 as a duplicate of this issue on Aug 14, 2025
  12. ivancea
    unmarked [CI] EsqlSpecIT test {lookup-join.MvJoinKeyOnFrom SYNC} failing #130296 as a duplicate of this issue on Aug 14, 2025
  13. ivancea
    closed this as completedin 4e3602don Aug 14, 2025
  14. ivancea
    added a commit that references this issue on Aug 14, 2025

    ESQL: Fix async operator warnings not always sent when blocking (elas…

    4e3602d
  15. joshua-adams-1
    added a commit that references this issue on Aug 14, 2025

    ESQL: Fix async operator warnings not always sent when blocking (elas…

    45f4703
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

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

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions