[CI] EsqlSpecIT test {csv-spec:lookup-join.MvJoinKeyFromRow} failing #132555
Description
Build Scans:
- elasticsearch-intake #26597 / part3
- elasticsearch-pull-request #84688 / part-3
- elasticsearch-periodic-platform-support #9829 / ubuntu-2404-aarch64_checkpart3_platform-support-arm
Reproduction Line:
./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {csv-spec:lookup-join.MvJoinKeyFromRow}" -Dtests.seed=D08844312A5E435 -Dtests.locale=ff-Adlm-CM -Dtests.timezone=America/Blanc-Sablon -Druntime.java=24 Applicable branches:
main
Reproduces locally?:
N/A
Failure History:
See dashboard
Failure Message:
java.lang.AssertionError: Expected a list containing 0: expected "Line 2: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 2:3: java.lang.IllegalArgumentException: LOOKUP JOIN encountered multi-value" but was <missing> Issue Reasons:
- [main] 2 consecutive failures in test test {csv-spec:lookup-join.MvJoinKeyFromRow}
- [main] 3 failures in test test {csv-spec:lookup-join.MvJoinKeyFromRow} (0.8% fail rate in 371 executions)
Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.