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

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8827 / 8.11.4_bwc
• elasticsearch-periodic #8815 / 8.11.4_bwc
• elasticsearch-periodic #8809 / 8.11.4_bwc
• elasticsearch-periodic #8797 / 8.11.4_bwc
• elasticsearch-periodic #8785 / 8.11.4_bwc
• elasticsearch-periodic #8773 / 8.11.4_bwc
• elasticsearch-periodic #8749 / 8.11.4_bwc
• elasticsearch-periodic #8743 / 8.11.4_bwc
• elasticsearch-periodic #8737 / 8.11.4_bwc
• elasticsearch-periodic #8719 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {dissect.EvalDissectSort ASYNC}" -Dtests.seed=5A0FE114F6ACB3FE -Dtests.bwc=true -Dtests.locale=fr-NE -Dtests.timezone=America/Monterrey -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [PUT], host [http://[::1]:33363], URI [/colors], status line [HTTP/1.1 400 Bad Request]
¿eerror¿jroot_cause�¿dtypex�mapper_parsing_exceptionfreasonxB[index_options] of type [hnsw] requires field [m] to be configuredÿÿdtypex�mapper_parsing_exceptionfreasonx[Failed to parse mapping: [index_options] of type [hnsw] requires field [m] to be configuredicaused_by¿dtypex�mapper_parsing_exceptionfreasonxB[index_options] of type [hnsw] requires field [m] to be configuredÿÿfstatus���ÿ

Issue Reasons:

• [8.19] 12 failures in test test {enrich.ShadowingLimit0 SYNC} (1.7% fail rate in 698 executions)
• [8.19] 12 failures in step 8.11.4_bwc (54.5% fail rate in 22 executions)
• [8.19] 12 failures in pipeline elasticsearch-periodic (54.5% fail rate in 22 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]

I wonder if this is related to #128907 #129495. Seems like the dense vector dataset colors has troubles on ingestion, affecting some unrelated tests. Specifically, enrich tests are busted because we create enrich policies after loading datasets (which currently throws when it sees colors).

@tteofili , could you please have a look at this one?

Edit: Sorry, linked the wrong PR initially.