[CI] GenerativeIT test failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #7567 / rhel-9_platform-support-unix
• elasticsearch-pull-request #67059 / part-3
• elasticsearch-pull-request #67005 / part-3
• elasticsearch-pull-request #66982 / part-3
• elasticsearch-pull-request #66934 / part-3
• elasticsearch-pull-request #66906 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:single-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.single_node.GenerativeIT.test" -Dtests.seed=9BEB71494829D856 -Dtests.locale=es-419 -Dtests.timezone=America/Havana -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: query: from hos*,languages,message_types | stats  `host_group` = max(language_code), blwldNmdNT = count_distinct(ip1), `type` = max(language_code) by ip0| rename type as language_code | lookup join languages_lookup on language_code | rename language_code AS host_group, `blwldNmdNT` AS XestDuQGgH, host_group AS GrGohjSgZDKC | eval  `XestDuQGgH` = 8114584234002416914, LkJAzHvh = -584594685, `ip0` = "RybGIVMRgk", eLJEZHIT = 922367746, XestDuQGgH = false | where  NOT true AND  NOT false AND true | where true OR  NOT true | eval  eLJEZHIT = true, eLJEZHIT = false, `ip0` = null, LoHDpeHrPhQ = 2106562490, `XestDuQGgH` = null, udcDrTDNWEn = true, btMNxWSTgt = true, KrKFGkPeVf = 5964325812842123566, language_name = null | where  NOT LoHDpeHrPhQ >= 50 OR LkJAzHvh != 50 OR  NOT LkJAzHvh >= 50 OR  NOT false| rename GrGohjSgZDKC as language_code | lookup join languages_lookup on language_code | enrich languages_policy on language_name | enrich languages_policy on language_
[truncated]

Issue Reasons:

• [main] 6 failures in test test (2.2% fail rate in 267 executions)
• [main] 5 failures in step part-3 (4.2% fail rate in 120 executions)
• [main] 5 failures in pipeline elasticsearch-pull-request (4.3% fail rate in 116 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 6 failures in test test (2.2% fail rate in 267 executions)
• [main] 5 failures in step part-3 (4.2% fail rate in 120 executions)
• [main] 5 failures in pipeline elasticsearch-pull-request (4.3% fail rate in 116 executions)

Build Scans:

• elasticsearch-periodic-platform-support #7567 / rhel-9_platform-support-unix
• elasticsearch-pull-request #67059 / part-3
• elasticsearch-pull-request #67005 / part-3
• elasticsearch-pull-request #66982 / part-3
• elasticsearch-pull-request #66934 / part-3
• elasticsearch-pull-request #66906 / part-3

[elasticsearchmachine]

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