Skip to content

[CI] MixedClusterEsqlSpecIT test {lookup-join.LookupJoinOnTimeSeriesIndex SYNC} failing #129082

Closed
@elasticsearchmachine

Description

@elasticsearchmachine

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.18.3#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {lookup-join.LookupJoinOnTimeSeriesIndex SYNC}" -Dtests.seed=736AFD771EAB7F57 -Dtests.bwc=true -Dtests.locale=sw-CD -Dtests.timezone=Asia/Kolkata -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [POST], host [http://127.0.0.1:43507], URI [/_query?format=yaml&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: "Found 1 problem\nline 4:35: JOIN left field [language_code] of type [LONG]\
      \ is incompatible with right field [language_code] of type [INTEGER]"
    stack_trace: "org.elasticsearch.xpack.esql.VerificationException: Found 1 problem\n\
      line 4:35: JOIN left field [language_code] of type [LONG] is incompatible with\
      \ right field [language_code] of type [INTEGER]\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.verify(Analyzer.java:192)\n\
      \tat org.elasticsearch.xpack.esql.analysis.Analyzer.analyze(Analyzer.java:186)\n\
      \tat org.elasticsearch.xpack.esql.session.EsqlSession.lambda$analyzedPlan$7(EsqlSession.java:313)\n\
      \tat org.elastics
[truncated]

Issue Reasons:

  • [8.19] 2 consecutive failures in step 8.18.3_bwc-snapshots
  • [8.19] 2 consecutive failures in step openjdk23_8.18.3_java-matrix-bwc
  • [8.19] 5 consecutive failures in step 8.12.2_bwc
  • [8.19] 4 consecutive failures in step 8.11.4_bwc
  • [8.19] 2 consecutive failures in pipeline elasticsearch-pull-request
  • [8.19] 84 failures in test test {lookup-join.LookupJoinOnTimeSeriesIndex SYNC} (53.2% fail rate in 158 executions)
  • [8.19] 29 failures in step 8.18.3_bwc-snapshots (48.3% fail rate in 60 executions)
  • [8.19] 4 failures in step openjdk17_8.18.3_java-matrix-bwc (30.8% fail rate in 13 executions)
  • [8.19] 6 failures in step openjdk17_8.18.3_java-fips-matrix-bwc (46.2% fail rate in 13 executions)
  • [8.19] 8 failures in step graalvm-ce17_8.18.3_java-matrix-bwc (61.5% fail rate in 13 executions)
  • [8.19] 7 failures in step openjdk22_8.18.3_java-matrix-bwc (53.8% fail rate in 13 executions)
  • [8.19] 6 failures in step openjdk21_8.18.3_java-matrix-bwc (50.0% fail rate in 12 executions)
  • [8.19] 11 failures in step openjdk23_8.18.3_java-matrix-bwc (84.6% fail rate in 13 executions)
  • [8.19] 4 failures in step 8.18.3_bwc (33.3% fail rate in 12 executions)
  • [8.19] 5 failures in step 8.12.2_bwc (100.0% fail rate in 5 executions)

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

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