[CI] StoredFieldsSequentialIT testAggTenPercentConfiguredToTenPct failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #8620 / windows-2019_checkpart3_platform-support-windows
• elasticsearch-pull-request #74347 / part-3

Reproduction Line:

gradlew ":x-pack:plugin:esql:qa:server:single-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.single_node.StoredFieldsSequentialIT.testAggTenPercentConfiguredToTenPct" -Dtests.seed=A75999C72786D230 -Dtests.locale=lt -Dtests.timezone=Asia/Pontianak -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected a map containing
                                                    operator: "ValuesSourceReaderOperator[fields = [test]]"
                                                      status: a map containing
                                                 readers_built: a map containing
 stored_fields[requires_source:true, fields:0, sequential: true]: expected a value equal to or greater than <1> but was <missing>
                                      test:column_at_a_time:null: <2> unexpected but ok
stored_fields[requires_source:true, fields:0, sequential: false]: <2> unexpected but ok
                         test:row_stride:BlockSourceReader.Bytes: <2> unexpected but ok
                                               pages_processed: <2> unexpected but ok
                                                  rows_emitted: <100> unexpected but ok
                                                 process_nanos: <18808100> unexpected but ok
                   
[truncated]

Issue Reasons:

• [8.19] 2 failures in test testAggTenPercentConfiguredToTenPct (1.4% fail rate in 138 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)

[alex-spies]

Hi Nik, I think this is related to #127721 but I can't quickly assess the risk. Do you think you could help assess it?

[luigidellaquila]

It still got no risk assessment. I'm labeling it as medium risk, in case we can lower it if we think it's not so relevant

[nik9000]

I missed this one. Looking.

[nik9000]

Could also be fixed by #130217. Let's try that.