REPRODUCE WITH: ./gradlew 'null' --tests "org.elasticsearch.xpack.esql.action.ManyShardsIT.testConcurrentQueries" -Dtests.seed=9AD8895DAA31433E -Dtests.locale=pl -Dtests.timezone=Asia/Dubai -Druntime.java=19

java.lang.AssertionError: Request breaker not reset to 0 on node: node_s0
Expected: <0L>
     but: was <192L>
Expected :<0L>
Actual   :<192L>
<Click to see difference>


	at __randomizedtesting.SeedInfo.seed([9AD8895DAA31433E:D8436A782A56361F]:0)
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
	at org.junit.Assert.assertThat(Assert.java:956)
	at org.elasticsearch.test.InternalTestCluster.lambda$ensureEstimatedStats$41(InternalTestCluster.java:2439)
	at org.elasticsearch.test.ESTestCase.assertBusy(ESTestCase.java:1196)
	at org.elasticsearch.test.ESTestCase.assertBusy(ESTestCase.java:1169)
	at org.elasticsearch.test.InternalTestCluster.ensureEstimatedStats(InternalTestCluster.java:2437)
	at org.elasticsearch.test.TestCluster.assertAfterTest(TestCluster.java:92)
	at org.elasticsearch.test.InternalTestCluster.assertAfterTest(InternalTestCluster.java:2486)
	at org.elasticsearch.test.ESIntegTestCase.afterInternal(ESIntegTestCase.java:590)
	at org.elasticsearch.test.ESIntegTestCase.cleanUpCluster(ESIntegTestCase.java:2327)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
	at java.base/java.lang.reflect.Method.invoke(Method.java:578)
	at com.carrotsearch.randomizedtesting.RandomizedRunner.invoke(RandomizedRunner.java:1758)
	at com.carrotsearch.randomizedtesting.RandomizedRunner$10.evaluate(RandomizedRunner.java:1004)
	at com.carrotsearch.randomizedtesting.rules.StatementAdapter.evaluate(StatementAdapter.java:36)
	at org.apache.lucene.tests.util.TestRuleSetupTeardownChained$1.evaluate(TestRuleSetupTeardownChained.java:48)
	at org.apache.lucene.tests.util.AbstractBeforeAfterRule$1.evaluate(AbstractBeforeAfterRule.java:43)

x-pack/plugin/esql/src/internalClusterTest/java/org/elasticsearch/xpack/esql/action/EsqlActionIT.java
record Group(double avg, long mi, long ma, long s, long c, String color) {}
        List<Group> expectedGroups = List.of(
            new Group(42, 42, 42, 420, 10, "blue"),
            new Group(44, 44, 44, 440, 10, "green"),
            new Group(43, 40, 46, 860, 20, "red")
        );
        
        List<Group> actualGroups = getValuesList(results).stream()
            .map(l -> new Group((Double) l.get(0), (Long) l.get(1), (Long) l.get(2), (Long) l.get(3), (Long) l.get(4), (String) l.get(5)))
            .sorted(comparing(c -> c.color))
            .toList();
        assertThat(actualGroups, equalTo(expectedGroups));
    }
    public void testFromSortWithTieBreakerLimit() {
        try (EsqlQueryResponse results = run("from test | sort data, count desc, time | limit 5 | keep data, count, time")) {
            logger.info(results);
            assertThat(
                getValuesList(results),
                contains(
                    List.of(1L, 44L, epoch + 2),
                    List.of(1L, 44L, epoch + 6),
                    List.of(1L, 44L, epoch + 10),
                    List.of(1L, 44L, epoch + 14),
                    List.of(1L, 44L, epoch + 18)
                )
            );
        }
    }
    public void testFromStatsProjectGroup() {
        EsqlQueryResponse results = run("from test | stats avg_count = avg(count) by data | keep data");