[CI] EsqlActionIT testGroupingStatsOnMissingFields failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8989 / release-tests
• elasticsearch-periodic #8982 / release-tests
• elasticsearch-periodic #8975 / release-tests
• elasticsearch-periodic #8968 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.EsqlActionIT.testGroupingStatsOnMissingFields" -Dtests.seed=29F77D1296606D66 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=es-BR -Dtests.timezone=America/Curacao -Druntime.java=24

Applicable branches:
8.18

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.action.ActionRequestValidationException: Validation Failed: 1: [pragma] only allowed in snapshot builds;

Issue Reasons:

• [8.18] 4 consecutive failures in step release-tests
• [8.18] 4 failures in test testGroupingStatsOnMissingFields (3.6% fail rate in 112 executions)
• [8.18] 4 failures in step release-tests (100.0% fail rate in 4 executions)
• [8.18] 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]

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

[dnhatn]

Fixed in #130177