[CI] EsqlSpecIT test {categorize.On REVERSE(CONCAT()) ASYNC} failing

elasticsearchmachine commented 2 days ago

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {categorize.On REVERSE(CONCAT()) SYNC}" -Dtests.seed=8F742372EDC44D91 -Dtests.locale=km-KH -Dtests.timezone=America/Recife -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches: 8.x

Reproduces locally?: N/A

Failure History: See dashboard&_a=(controlGroupState:(initialChildControlState:('0c0c9cb8-ccd2-45c6-9b13-96bac4abc542':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:task.keyword,order:0,selectedOptions:!(),title:'GradleTask',type:optionsListControl),'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:className.keyword,order:1,selectedOptions:!(org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT),title:'Suite',type:optionsListControl),'144933da-5c1b-4257-a969-7f43455a7901':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:name.keyword,order:2,selectedOptions:!(test%20%7Bcategorize.On%20REVERSE(CONCAT())%20ASYNC%7D),title:'Test',type:optionsListControl)))))

Failure Message:

java.lang.AssertionError: Data mismatch:
row 0 column 1:a list containing
row 0 column 1:0: expected ".*?😊👍🏽.+?detcennocsiD.*?" but was ".*?😊🏽👍.+?detcennocsiD.*?"
row 1 column 1:a list containing
row 1 column 1:0: expected ".*?😊👍🏽.+?ot.+?detcennoC.*?" but was ".*?😊🏽👍.+?ot.+?detcennoC.*?"
row 2 column 1:a list containing
row 2 column 1:0: expected ".*?😊👍🏽.+?rorre.+?noitcennoC.*?" but was ".*?😊🏽👍.+?rorre.+?noitcennoC.*?"

Issue Reasons:

[8.x] 4 consecutive failures in step graalvm-ce17_checkpart3_java-matrix
[8.x] 4 consecutive failures in step openjdk17_checkpart3_java-matrix
[8.x] 4 consecutive failures in step openjdk17_checkpart3_java-fips-matrix
[8.x] 12 failures in test test {categorize.On REVERSE(CONCAT()) ASYNC} (10.0% fail rate in 120 executions)
[8.x] 4 failures in step graalvm-ce17_checkpart3_java-matrix (100.0% fail rate in 4 executions)
[8.x] 4 failures in step openjdk17_checkpart3_java-matrix (100.0% fail rate in 4 executions)
[8.x] 4 failures in step openjdk17_checkpart3_java-fips-matrix (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 commented 2 days ago

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

ivancea commented 2 days ago

Same as: https://github.com/elastic/elasticsearch/issues/117706 https://github.com/elastic/elasticsearch/issues/117708 https://github.com/elastic/elasticsearch/issues/117713

elastic / elasticsearch

[CI] EsqlSpecIT test {categorize.On REVERSE(CONCAT()) ASYNC} failing #117707