[CI] FieldExtractorIT testTextFieldWithKeywordSubfield failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8730 / 8.14.3_bwc
• elasticsearch-periodic #8724 / 8.12.2_bwc
• elasticsearch-periodic #8712 / 8.14.3_bwc
• elasticsearch-periodic #8700 / 8.12.2_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.14.3#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.FieldExtractorIT" -Dtests.method="testIpFieldWithTextOrKeywordSubfield" -Dtests.seed=20032EB44C609A19 -Dtests.bwc=true -Dtests.locale=bn-IN -Dtests.timezone=America/Santo_Domingo -Druntime.java=24

Applicable branches:
8.18

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected a map containing
columns: a list containing
        0: a map containing
       name: "ip_field"
       type: "ip"
        1: a map containing
       name: "ip_field.str"
       type: "text"
 values: a list containing
        0: a list containing
          0: "232.86.65.12"
          1: expected "232.86.65.12" but was null

Issue Reasons:

• [8.18] 4 failures in test testTextFieldWithKeywordSubfield (5.6% fail rate in 72 executions)
• [8.18] 2 failures in step 8.14.3_bwc (33.3% fail rate in 6 executions)
• [8.18] 2 failures in step 8.12.2_bwc (40.0% fail rate in 5 executions)
• [8.18] 4 failures in pipeline elasticsearch-periodic (66.7% fail rate in 6 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)