[CI] MixedClusterEsqlSpecIT test {enrich.ShadowingMultiLimit0 SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #3211 / 8.12.2_bwc
• elasticsearch-periodic #3208 / 8.12.2_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 {enrich.ShadowingMultiLimit0 SYNC}" -Dtests.seed=B065CA6C7AD71850 -Dtests.bwc=true -Dtests.locale=mt-MT -Dtests.timezone=Canada/Yukon -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Different column type for column [city_boundary] (GEO_SHAPE != NULL) expected:<GEO_SHAPE> but was:<NULL>

Issue Reasons:

• [main] 2 consecutive failures in test test {enrich.ShadowingMultiLimit0 SYNC} (100.0% fail rate)
• [main] 2 consecutive failures in step 8.12.2_bwc (100.0% fail rate)
• [main] 2 consecutive failures in pipeline elasticsearch-periodic (100.0% fail rate)

Note:
This issue was created using new, in-development muting automation. Please mind any issues.

[elasticsearchmachine]

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

[nik9000]

@alex-spies could you have a look at this one?