[CI] MixedClusterEsqlSpecIT test {rename.ShadowingSubfields SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8719 / 8.12.2_bwc
• elasticsearch-periodic #8719 / 8.11.4_bwc
• elasticsearch-periodic #8713 / 8.12.2_bwc
• elasticsearch-periodic #8713 / 8.11.4_bwc
• elasticsearch-periodic #8689 / 8.12.2_bwc
• elasticsearch-periodic #8689 / 8.11.4_bwc
• elasticsearch-periodic #8683 / 8.12.2_bwc
• elasticsearch-periodic #8677 / 8.12.2_bwc
• elasticsearch-periodic #8653 / 8.11.4_bwc
• elasticsearch-periodic #8641 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.12.2#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {math.MvMax SYNC}" -Dtests.seed=59BCC13F9AD4FACA -Dtests.bwc=true -Dtests.locale=fil -Dtests.timezone=Asia/Istanbul -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Data mismatch:
row 1 column 1:a list containing
row 1 column 1:0: expected "[-6, 4, 5, 12]" but was "null"
row 1 column 2:a list containing
row 1 column 2:0: expected "12" but was "null"
row 2 column 1:a list containing
row 2 column 1:0: expected "[-7, 3, 8, 10]" but was "null"
row 2 column 2:a list containing
row 2 column 2:0: expected "10" but was "null"
row 3 column 1:a list containing
row 3 column 1:0: expected "0" but was "null"
row 3 column 2:a list containing
row 3 column 2:0: expected "0" but was "null"
row 5 column 1:a list containing
row 5 column 1:0: expected "[-1, 9]" but was "null"
row 5 column 2:a list containing
row 5 column 2:0: expected "9" but was "null"
row 6 column 1:a list containing
row 6 column 1:0: expected "[12, 14]" but was "null"
row 6 column 2:a list containing
row 6 column 2:0: expected "14" but was "null"
Actual:
emp_no:integer | salary_change.int:integer | salary_change:integer
10009          | null                      | null
1
[truncated]

Issue Reasons:

• [8.19] 2 consecutive failures in step 8.12.2_bwc
• [8.19] 2 consecutive failures in step 8.11.4_bwc
• [8.19] 12 failures in test test {rename.ShadowingSubfields SYNC} (1.8% fail rate in 675 executions)
• [8.19] 5 failures in step 8.12.2_bwc (26.3% fail rate in 19 executions)
• [8.19] 7 failures in step 8.11.4_bwc (35.0% fail rate in 20 executions)
• [8.19] 9 failures in pipeline elasticsearch-periodic (45.0% fail rate in 20 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)