Always getting version conflicts issue when trying to remove fields from Elasticsearch

Question

I am just trying to remove a field from all documents in my Elasticsearch index in Kibana on AWS and it is always giving me version conflicts error for all of the documents even though I am issuing just one request and sure that no one else is updating the index at the moment. I tried nearly all of the solutions from here but all of them lead to the same issue and no documents get updated:

Remove a field from a Elasticsearch document

For instance:

POST /grch38_test__wes__grch38__variants__20210222/_update_by_query?conflicts=proceed
{
  "script": {
    "inline": "ctx._source.remove(\"AC\")"
  },
  "query" : {
      "exists": { "field": "AC" }
  }
}

Why is this happening? What could I try?

Exact message:

{
  "took" : 12768,
  "timed_out" : false,
  "total" : 11034,
  "updated" : 0,
  "deleted" : 0,
  "batches" : 12,
  "version_conflicts" : 11034,
  "noops" : 0,
  "retries" : {
    "bulk" : 0,
    "search" : 0
  },
  "throttled_millis" : 0,
  "requests_per_second" : -1.0,
  "throttled_until_millis" : 0,
  "failures" : [ ]
}

What is the exact error msg? – Joe - GMapsBook.com Feb 23 '21 at 15:55 — Joe - GMapsBook.com, Feb 23 '21 at 15:55
Hi, I updated the question with the resulting output – Nikita Vlasenko Feb 23 '21 at 18:08 — Nikita Vlasenko, Feb 23 '21 at 18:08

score 0 · Accepted Answer · answered Feb 24 '21 at 15:37

0

Finally I was able to solve it using the solution found in the thread:

ElasticSearch: Delete field from all documents where it exists (with Painless?)

answered Feb 24 '21 at 15:37

Nikita Vlasenko

4,004
7
47
87

can u atleast share the solution which worked for u? i tried all possible solutions from link u mentioned but nothing working for me – tempEngineer Jul 14 '22 at 12:23

Always getting version conflicts issue when trying to remove fields from Elasticsearch

1 Answers1