Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[CI] MultiClusterSpecIT test {date.Implicit casting strings to dates for IN operator} failing #120155

Open
elasticsearchmachine opened this issue Jan 14, 2025 · 3 comments
Open

[CI] MultiClusterSpecIT test {date.Implicit casting strings to dates for IN operator} failing #120155

elasticsearchmachine opened this issue Jan 14, 2025 · 3 comments
Assignees
@not-napoleon
Labels
:Analytics/ES|QL AKA ESQL medium-risk An open issue or test failure that is a medium risk to future releases Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) >test-failure Triaged test failures from CI

Comments

@elasticsearchmachine
Copy link
Collaborator

elasticsearchmachine commented Jan 14, 2025 •
edited
Loading

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v8.14.3#newToOld" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {date.Implicit casting strings to dates for IN operator}" -Dtests.seed=FF019A261106D068 -Dtests.bwc=true -Dtests.locale=en-MG -Dtests.timezone=America/Argentina/Catamarca -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected more data but no more entries found after [0]
Data mismatch:

Actual:
emp_no:integer | first_name:keyword

Expected:
emp_no:integer | first_name:keyword
10006          | Anneke            
10025          | Prasadram

Issue Reasons:

  • [8.x] 5 consecutive failures in step 8.14.3_bwc
  • [8.x] 4 consecutive failures in step 8.15.5_bwc
  • [8.x] 4 consecutive failures in step 8.13.4_bwc
  • [8.x] 13 failures in test test {date.Implicit casting strings to dates for IN operator} (2.5% fail rate in 519 executions)
  • [8.x] 5 failures in step 8.14.3_bwc (100.0% fail rate in 5 executions)
  • [8.x] 4 failures in step 8.15.5_bwc (100.0% fail rate in 4 executions)
  • [8.x] 4 failures in step 8.13.4_bwc (100.0% fail rate in 4 executions)
  • [8.x] 4 failures in pipeline elasticsearch-periodic (100.0% fail rate in 4 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.
@elasticsearchmachine elasticsearchmachine added :Analytics/ES|QL AKA ESQL >test-failure Triaged test failures from CI Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) needs:risk Requires assignment of a risk label (low, medium, blocker) labels Jan 14, 2025
@elasticsearchmachine
Copy link
Collaborator Author

Pinging @elastic/es-analytical-engine (Team:Analytics)

@elasticsearchmachine
Copy link
Collaborator Author

This has been muted on branch 8.x

Mute Reasons:

  • [8.x] 6 consecutive failures in step 8.13.4_bwc
  • [8.x] 5 consecutive failures in step 8.14.3_bwc
  • [8.x] 5 consecutive failures in step 8.15.5_bwc
  • [8.x] 16 failures in test test {date.Implicit casting strings to dates for IN operator} (1.9% fail rate in 849 executions)
  • [8.x] 6 failures in step 8.13.4_bwc (100.0% fail rate in 6 executions)
  • [8.x] 5 failures in step 8.14.3_bwc (100.0% fail rate in 5 executions)
  • [8.x] 5 failures in step 8.15.5_bwc (100.0% fail rate in 5 executions)
  • [8.x] 5 failures in pipeline elasticsearch-periodic (100.0% fail rate in 5 executions)

Build Scans:

elasticsearchmachine added a commit that referenced this issue Jan 16, 2025
@elasticsearchmachine
Mute org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT test {date.I…
d41b338 
…mplicit casting strings to dates for IN operator} #120155
@craigtaverner craigtaverner added medium-risk An open issue or test failure that is a medium risk to future releases and removed needs:risk Requires assignment of a risk label (low, medium, blocker) labels Jan 17, 2025
@not-napoleon not-napoleon mentioned this issue Jan 21, 2025
Merged
not-napoleon added a commit that referenced this issue Jan 22, 2025
@not-napoleon
[8.x] Esql date casting tests #120420 (#120543)
4c24fa7 
Resolves #120159
Resolves #120157
Resolves #120151
Resolves #120158
Resolves #120155
Resolves #120156
Resolves #120348
Resolves #120349

This adds appropriate ignore annotations for the date tests I added in #119772 to not run the tests against very old versions.
@elasticsearchmachine
Copy link
Collaborator Author

This has been muted on branch 8.x

Mute Reasons:

  • [8.x] 5 consecutive failures in step 8.14.3_bwc
  • [8.x] 4 consecutive failures in step 8.15.5_bwc
  • [8.x] 4 consecutive failures in step 8.13.4_bwc
  • [8.x] 13 failures in test test {date.Implicit casting strings to dates for IN operator} (2.5% fail rate in 519 executions)
  • [8.x] 5 failures in step 8.14.3_bwc (100.0% fail rate in 5 executions)
  • [8.x] 4 failures in step 8.15.5_bwc (100.0% fail rate in 4 executions)
  • [8.x] 4 failures in step 8.13.4_bwc (100.0% fail rate in 4 executions)
  • [8.x] 4 failures in pipeline elasticsearch-periodic (100.0% fail rate in 4 executions)

Build Scans:

elasticsearchmachine added a commit that referenced this issue Jan 22, 2025
@elasticsearchmachine
Mute org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT test {date.I…
8f7d96d 
…mplicit casting strings to dates for IN operator} #120155
@alex-spies alex-spies mentioned this issue Feb 4, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@not-napoleon not-napoleon

Labels
:Analytics/ES|QL AKA ESQL medium-risk An open issue or test failure that is a medium risk to future releases Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) >test-failure Triaged test failures from CI
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@craigtaverner @not-napoleon @elasticsearchmachine