[CI] GenerativeIT test failing #131508
Description
Build Scans:
- elasticsearch-periodic #9440 / encryption-at-rest
- elasticsearch-pull-request #81658 / part-3
- elasticsearch-pull-request #81618 / part-3
- elasticsearch-pull-request #81599 / part-3
- elasticsearch-pull-request #81412 / part-3
- elasticsearch-pull-request #81412 / part-3
- elasticsearch-pull-request #81203 / part-3
- elasticsearch-pull-request #81148 / part-3
- elasticsearch-pull-request #81148 / part-3
- elasticsearch-pull-request #80976 / part-3
Reproduction Line:
./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.GenerativeIT.test" -Dtests.seed=B184F0960CE6BD0D -Dtests.locale=ko-KP -Dtests.timezone=Etc/GMT-13 -Druntime.java=24
Applicable branches:
main
Reproduces locally?:
N/A
Failure History:
See dashboard
Failure Message:
java.lang.AssertionError: query: from mv_sample_data | dissect message "%{qpRbPZwc} %{UbWGGBtGlG} %{DVLbsKYvS}" | mv_expand `qpRbPZwc` | CHANGE_POINT event_duration ON @timestamp AS `qpRbPZwc`, `UbWGGBtGlG` | keep qpRbPZwc, @timestamp | where false AND false AND false| rename qpRbPZwc as message | lookup join message_types_lookup on message| rename type as message | lookup join message_types_lookup on message | sort type DESC | limit 7896 | rename `@timestamp` AS `VGjcBqSUqiMg` | rename message AS ZvuHgaUFfZff, `ZvuHgaUFfZff` AS type | keep VGjcBqSUqiMg, `type`| rename type as message | lookup join message_types_lookup on message
exception: method [POST], host [http://[::1]:46381], URI [/_query?format=yaml&pretty=true&error_trace=true], status line [HTTP/1.1 500 Internal Server Error]
---
error:
root_cause:
- type: "illegal_state_exception"
reason: "Found 1 problem\nline 1:562: Plan [Join[LEFT,[message{r}#2951],[message{r}#2951],[message{f}#2960]]]\
\ optimized incorrectl
[truncated]
Issue Reasons:
- [main] 11 failures in test test (1.7% fail rate in 658 executions)
- [main] 9 failures in step part-3 (2.9% fail rate in 307 executions)
- [main] 7 failures in pipeline elasticsearch-pull-request (2.3% fail rate in 303 executions)
- [main] 2 failures in pipeline elasticsearch-periodic (20.0% fail rate in 10 executions)
Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.