[CI] EsqlActionBreakerIT testUnsupportedTypesOrdinalGrouping failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #17851 / part3
• elasticsearch-intake #17779 / part3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.EsqlActionBreakerIT.testUnsupportedTypesOrdinalGrouping" -Dtests.seed=FF7C56A500B32893 -Dtests.locale=en-LR -Dtests.timezone=Australia/North -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: an instance of org.elasticsearch.common.breaker.CircuitBreakingException
     but: <org.elasticsearch.ElasticsearchTimeoutException: java.util.concurrent.TimeoutException: Timeout waiting for task.> is a org.elasticsearch.ElasticsearchTimeoutException

Issue Reasons:

• [main] 2 failures in test testUnsupportedTypesOrdinalGrouping (1.0% fail rate in 209 executions)
• [main] 2 failures in step part3 (6.3% fail rate in 32 executions)
• [main] 2 failures in pipeline elasticsearch-intake (6.3% fail rate in 32 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] 2 failures in test testUnsupportedTypesOrdinalGrouping (1.0% fail rate in 209 executions)
• [main] 2 failures in step part3 (6.3% fail rate in 32 executions)
• [main] 2 failures in pipeline elasticsearch-intake (6.3% fail rate in 32 executions)

Build Scans:

• elasticsearch-intake #17851 / part3
• elasticsearch-intake #17779 / part3

[elasticsearchmachine]

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

[idegtiarenko]

Seems related to #122228

[astefan]

@dnhatn I am assigning this one to you, as well, since you took the other one @idegtiarenko mentioned and they seem to be in the same area. Please, let me know otherwise.

[dnhatn]

Fixed in #122290