[CI] CsvTests test {csv-spec:stats.WeightedAvgFieldMvWarning} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #26848 / part3
• elasticsearch-pull-request #85575 / part-3
• elasticsearch-intake #26837 / part3
• elasticsearch-intake #26813 / part3
• elasticsearch-intake #26810 / part3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.CsvTests" -Dtests.method="test {csv-spec:stats.WeightedAvgFieldMvWarning}" -Dtests.seed=58421F59AB27D21F -Dtests.locale=hi-Deva-IN -Dtests.timezone=America/Vancouver -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected a list containing
0: expected "Line 3:17: evaluation of [weighted_avg(salary_change.int, height)] failed, treating result as null. Only first 20 failures recorded." but was <missing>
1: expected "Line 3:17: java.lang.IllegalArgumentException: single-value function encountered multi-value" but was <missing>

Issue Reasons:

• [main] 5 failures in test test {csv-spec:stats.WeightedAvgFieldMvWarning} (2.2% fail rate in 227 executions)
• [main] 4 failures in step part3 (8.2% fail rate in 49 executions)
• [main] 4 failures in pipeline elasticsearch-intake (8.2% fail rate in 49 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] 3 failures in test test {csv-spec:stats.WeightedAvgFieldMvWarning} (1.4% fail rate in 222 executions)
• [main] 3 failures in step part3 (6.8% fail rate in 44 executions)
• [main] 3 failures in pipeline elasticsearch-intake (6.8% fail rate in 44 executions)

Build Scans:

• elasticsearch-intake #26837 / part3
• elasticsearch-intake #26813 / part3
• elasticsearch-intake #26810 / part3

[elasticsearchmachine]

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

[idegtiarenko]

Closed by #132843