[CI] MultiClusterSpecIT test {csv-spec:lookup-join-expression.LookupMultiColTwoExprAndNoMatch} failing #136121
Description
Build Scans:
- elasticsearch-intake #29709 / 9.3.0_bwc-snapshots
- elasticsearch-pull-request #97256 / 8.19.5_part_3_bwc-snapshots
- elasticsearch-pull-request #97256 / 9.0.8_part_3_bwc-snapshots
- elasticsearch-pull-request #97256 / 9.1.5_part_3_bwc-snapshots
- elasticsearch-pull-request #97256 / 9.2.0_part_3_bwc-snapshots
Reproduction Line:
./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v9.3.0#bwcTest" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {csv-spec:lookup-join-expression.LookupMultiColTwoExprAndNoMatch}" -Dtests.seed=B1E500FCD18E3F19 -Dtests.bwc=true -Dtests.locale=ff-Latn-MR -Dtests.timezone=Etc/Greenwich -Druntime.java=25
Applicable branches:
main
Reproduces locally?:
N/A
Failure History:
See dashboard
Failure Message:
java.lang.AssertionError:
Data mismatch:
row 0 column 0:a list containing
row 0 column 0:0: expected "[1, 19, 20]" but was "1"
row 1 column 0:a list containing
row 1 column 0:0: expected "1" but was "[1, 19, 20]"
Actual:
left_id:integer | left_name:keyword | id_int:integer | name_str:keyword
1 | nomatch | null | null
[1, 19, 20] | nomatch | null | null
1 | nomatch | null | null
2 | nomatch | null | null
3 | nomatch | null | null
3 | nomatch | null | null
4 | nomatch | null | null
5 | nomatch | null | null
5 | nomatch | null | null
6 | nomatch | null | null
7 | nomatch | null | null
8 | nomatch | null
[truncated]
Issue Reasons:
- [main] 5 failures in test test {csv-spec:lookup-join-expression.LookupMultiColTwoExprAndNoMatch} (0.5% fail rate in 1000 executions)
Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.