Skip to content

Can't execute deleteByQuery without 409 conflict #518

@RyuuGan

Description

@RyuuGan

Hey guys. Just want to know if I'm the only one who can't use deleteByQuery API in ElasticSeatch 5.0.

When I'm doing this query via elasticsearch.Client it always returns 409: version conflict, current version [x] is different than the one provided [y], but when i'm doing this request via curl (got it from log: 'trace') then it work perfectly. Any ideas?

Log from elasticsearch log

Elasticsearch DEBUG: 2017-03-23T10:22:43Z
  Request complete

Trace: { [Error: Conflict]
  status: 409,
  displayName: 'Conflict',
  message: 'Conflict',
  path: '/courses/document/_delete_by_query',
  query: {},
  body: '{"query":{"bool":{"must":[{"term":{"realm":"test"}},{"term":{"course":"564d8a0264ee521611bd87fe"}},{"term":{"unit":"564d843e421061bd10339ca9"}}]}}}',
  statusCode: 409,
  response: '{"took":5,"timed_out":false,"total":8,"deleted":0,"batches":1,"version_conflicts":8,"noops":0,"retries":{"bulk":0,"search":0},"throttled_millis":0,"requests_per_second":-1.0,"throttled_until_millis":0,"failures":[{"index":"courses","type":"document","id":"564d8462421061bd10339caf","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d8462421061bd10339caf]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"2","index":"courses"},"status":409},{"index":"courses","type":"document","id":"564d858e421061bd10339cbd","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d858e421061bd10339cbd]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"0","index":"courses"},"status":409},{"index":"courses","type":"document","id":"564d849d421061bd10339cb4","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d849d421061bd10339cb4]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"0","index":"courses"},"status":409},{"index":"courses","type":"document","id":"5666e87e699ed126107e8b5d","cause":{"type":"version_conflict_engine_exception","reason":"[document][5666e87e699ed126107e8b5d]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"4","index":"courses"},"status":409},{"index":"courses","type":"document","id":"564d8a0264ee521611bd880d","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d8a0264ee521611bd880d]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"4","index":"courses"},"status":409},{"index":"courses","type":"document","id":"564d85b2421061bd10339cc2","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d85b2421061bd10339cc2]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"1","index":"courses"},"status":409},{"index":"courses","type":"document","id":"564d8a0264ee521611bd880e","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d8a0264ee521611bd880e]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"1","index":"courses"},"status":409},{"index":"courses","type":"document","id":"564d843e421061bd10339ca9","cause":{"type":"version_conflict_engine_exception","reason":"[document][564d843e421061bd10339ca9]: version conflict, current version [6] is different than the one provided [5]","index_uuid":"Y2qQlayORi6R76WO4q0rOQ","shard":"3","index":"courses"},"status":409}]}'

curl request:

  curl -XPOST "http://localhost:9200/courses/document/_delete_by_query" -d '{
    "query": {
      "bool": {
        "must": [
          {
            "term": {
              "realm": "test"
            }
          },
          {
            "term": {
              "course": "564d8a0264ee521611bd87fe"
            }
          },
          {
            "term": {
              "unit": "564d843e421061bd10339ca9"
            }
          }
        ]
      }
    }
  }'
{
    "took": 20,
    "timed_out": false,
    "total": 8,
    "deleted": 8,
    "batches": 1,
    "version_conflicts": 0,
    "noops": 0,
    "retries": {
        "bulk": 0,
        "search": 0
    },
    "throttled_millis": 0,
    "requests_per_second": -1,
    "throttled_until_millis": 0,
    "failures": []
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions