[CI] MultiClusterSpecIT test {date.IN operator with null in list, doesn't find match} failing #120348
Description
Build Scans:
- elasticsearch-periodic #5950 / 8.13.4_bwc
- elasticsearch-pull-request #51533 / 8.13.4_bwc
- elasticsearch-pull-request #51533 / 8.13.4_bwc
- elasticsearch-periodic #5945 / 8.13.4_bwc
- elasticsearch-periodic #5940 / 8.13.4_bwc
- elasticsearch-periodic #5935 / 8.13.4_bwc
- elasticsearch-periodic #5930 / 8.13.4_bwc
- elasticsearch-periodic #5925 / 8.13.4_bwc
- elasticsearch-periodic #5920 / 8.13.4_bwc
- elasticsearch-periodic #5915 / 8.13.4_bwc
Reproduction Line:
./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v8.13.4#oldToNew" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {date.IN operator with null in list, doesn't find match}" -Dtests.seed=ED4032AA8E32DF54 -Dtests.bwc=true -Dtests.locale=rn -Dtests.timezone=Europe/Sofia -Druntime.java=23
Applicable branches:
8.x
Reproduces locally?:
N/A
Failure History:
See dashboard
Failure Message:
java.lang.AssertionError: Expected an empty list
0: <unexpected> but was "Line 3:24: evaluation of [TO_DATETIME(\\\"1900-02-19T00:00:00Z\\\")] failed, treating result as null. Only first 20 failures recorded."
1: <unexpected> but was "Line 3:24: java.lang.IllegalArgumentException: failed to parse date field [1900-02-19T00:00:00Z] with format [yyyy-MM-dd'T'HH:mm:ss.SSS'Z']"
Issue Reasons:
- [8.x] 11 failures in test test {date.IN operator with null in list, doesn't find match} (1.2% fail rate in 952 executions)
- [8.x] 11 failures in step 8.13.4_bwc (100.0% fail rate in 11 executions)
- [8.x] 9 failures in pipeline elasticsearch-periodic (100.0% fail rate in 9 executions)
Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.