[CI] MultiClusterSpecIT test {fork.ForkWithDissect} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7819 / 9.1.0_bwc
• elasticsearch-pull-request #69138 / 9.1.0_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v9.1.0#newToOld" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {fork.ForkWithDissect}" -Dtests.seed=BC62296BB7090E9F -Dtests.bwc=true -Dtests.locale=mai -Dtests.timezone=America/Santarem -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected more data but no more entries found after [2]
Data mismatch:

Actual:
_fork:keyword | emp_no:integer | x:keyword | y:keyword | z:keyword | w:keyword
fork1         | 10048          | Florian   | 10048     | Syrotiuk  | null     
fork1         | 10081          | Zhongwei  | 10081     | Rosen     | null     

Expected:
_fork:keyword | emp_no:integer | x:keyword | y:keyword | z:keyword | w:keyword
fork1         | 10048          | Florian   | 10048     | Syrotiuk  | null     
fork1         | 10081          | Zhongwei  | 10081     | Rosen     | null     
fork2         | 10048          | Syrotiuk  | 10048     | null      | Florian  
fork2         | 10081          | Rosen     | 10081     | null      | Zhongwei 

Issue Reasons:

• [main] 2 failures in test test {fork.ForkWithDissect} (0.3% fail rate in 791 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 test {fork.ForkWithDissect} (0.3% fail rate in 791 executions)

Build Scans:

• elasticsearch-periodic #7819 / 9.1.0_bwc
• elasticsearch-pull-request #69138 / 9.1.0_bwc-snapshots

[elasticsearchmachine]

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

[ioanatia]

closed with #127309

tracking CCS support for FORK in #121950