Skip to content

[CI] MixedClusterEsqlSpecIT test {date.IN operator with null in list, doesn't find match, EVAL to check value SYNC} failing #120151

Closed
@elasticsearchmachine

Description

@elasticsearchmachine

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.13.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {date.IN operator with null in list, doesn't find match SYNC}" -Dtests.seed=6750F5066B95DCDA -Dtests.bwc=true -Dtests.locale=ak-GH -Dtests.timezone=Canada/Yukon -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, EVAL to check value SYNC} (4.3% fail rate in 257 executions)
  • [8.x] 5 failures in step 8.12.2_bwc (71.4% fail rate in 7 executions)
  • [8.x] 2 failures in step 8.13.4_bwc (28.6% fail rate in 7 executions)
  • [8.x] 4 failures in step 8.11.4_bwc (57.1% fail rate in 7 executions)
  • [8.x] 6 failures in pipeline elasticsearch-periodic (100.0% fail rate in 6 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)medium-riskAn open issue or test failure that is a medium risk to future releases

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions