[CI] EsqlSpecIT test {lookup-join.MvJoinKeyOnTheLookupIndex ASYNC} failing #128030
Description
Build Scans:
- elasticsearch-periodic #8150 / openjdk21_checkpart3_java-matrix
- elasticsearch-pull-request #71316 / part-3
Reproduction Line:
./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {lookup-join.MvJoinKeyOnTheLookupIndex ASYNC}" -Dtests.seed=3CD9BD9A23D76E3A -Dtests.locale=is-Latn-IS -Dtests.timezone=Africa/Maseru -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_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] 2 failures in test test {lookup-join.MvJoinKeyOnTheLookupIndex ASYNC} (0.9% fail rate in 229 executions)
Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.