Skip to content

[CI] MixedClusterEsqlSpecIT test {lookup-join.LookupJoinOnTimeSeriesIndex ASYNC} failing #129078

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 ASYNC}" -Dtests.seed=5F5B8E68127C1753 -Dtests.bwc=true -Dtests.locale=ar-IL -Dtests.timezone=Europe/Belgrade -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [GET], host [http://[::1]:34059], URI [/_query/async/FnRfaGR5dTJFUThpTHI2WVdQRWNQN1EcNzBwaVA0X3BSVHFLWnFzZDlnZXQyZzozODk1Nw==?wait_for_completion_timeout=60s&pretty=true&error_trace=true], status line [HTTP/1.1 400 Bad Request]
Warnings: [No limit defined, adding default limit of [1000]]
¿eerror¿jroot_cause�¿dtypevverification_exceptionfreasonx¤verification_exception: Found 1 problem
line 4:35: JOIN left field [language_code] of type [LONG] is incompatible with right field [language_code] of type [INTEGER]kstack_trace�y��org.elasticsearch.xpack.esql.VerificationException: verification_exception: Found 1 problem
line 4:35: JOIN left field [language_code] of type [LONG] is incompatible with right field [language_code] of type [INTEGER]
	at org.elasticsearch.xpack.esql.analysis.Analyzer.verify(Analyzer.java:192)
	at org.elasticsearch.xpack.esql.analysis.Analyzer.analyze(Analyzer.java:186)
	at org.elasticsearch.xpack.esql.session.EsqlSessi
[truncated]

Issue Reasons:

  • [8.19] 2 consecutive failures in step 8.18.3_bwc-snapshots
  • [8.19] 2 consecutive failures in step openjdk21_8.18.3_java-matrix-bwc
  • [8.19] 2 consecutive failures in step 8.18.3_bwc
  • [8.19] 2 consecutive failures in pipeline elasticsearch-intake
  • [8.19] 74 failures in test test {lookup-join.LookupJoinOnTimeSeriesIndex ASYNC} (51.0% fail rate in 145 executions)
  • [8.19] 31 failures in step 8.18.3_bwc-snapshots (50.8% fail rate in 61 executions)
  • [8.19] 6 failures in step openjdk17_8.18.3_java-fips-matrix-bwc (50.0% fail rate in 12 executions)
  • [8.19] 6 failures in step graalvm-ce17_8.18.3_java-matrix-bwc (50.0% fail rate in 12 executions)
  • [8.19] 6 failures in step openjdk17_8.18.3_java-matrix-bwc (50.0% fail rate in 12 executions)
  • [8.19] 4 failures in step openjdk22_8.18.3_java-matrix-bwc (33.3% fail rate in 12 executions)
  • [8.19] 8 failures in step openjdk21_8.18.3_java-matrix-bwc (66.7% fail rate in 12 executions)
  • [8.19] 6 failures in step openjdk23_8.18.3_java-matrix-bwc (50.0% fail rate in 12 executions)
  • [8.19] 6 failures in step 8.18.3_bwc (54.5% fail rate in 11 executions)
  • [8.19] 8 failures in pipeline elasticsearch-intake (66.7% fail rate in 12 executions)
  • [8.19] 12 failures in pipeline elasticsearch-periodic (100.0% fail rate in 12 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