# Elasticsearch update by query problem

**URL:** <https://discuss.elastic.co/t/elasticsearch-update-by-query-problem/226611>\
**Category:** 中文提问与讨论\
**Created:** [April 6, 2020, 3:59am UTC](https://discuss.elastic.co/t/elasticsearch-update-by-query-problem/226611 "2020-04-06T03:59:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![111306](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/111306/32/65170_2.png) [@111306](https://discuss.elastic.co/u/111306)\
**Post date:** [April 6, 2020, 3:59am UTC](https://discuss.elastic.co/t/elasticsearch-update-by-query-problem/226611/1 "2020-04-06T03:59:45Z")

</div>

遇到一个问题，我的 elasticsearch 版本是 7.6.1 ，使用的系统是 Debian 9 。我们在线上运行 elasticsearch 时，发现使用 update\_by\_query 接口发现有时并没有更新，但单个请求又是成功的。什么情况下会显示更新成功，但并没有发生更新呢？请问这个是什么问题，困扰很久了。

---

<div class="post-metadata">

**Author:** ![111306](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/111306/32/65170_2.png) [@111306](https://discuss.elastic.co/u/111306)\
**Post date:** [April 6, 2020, 9:42am UTC](https://discuss.elastic.co/t/elasticsearch-update-by-query-problem/226611/2 "2020-04-06T09:42:45Z")

</div>

经过调试发现一些问题，就是由于我们的更新请求比较多，似乎 elasticsearch 不更新了。

```auto
POST /messages/_update_by_query?conflicts=proceed
{
  "query": {
    "term":{
      "roomId":"5d944ee17e78d618bec1a39b"
    }
   },
   "script":{"source":"ctx._source.status = 2"}
}

```

返回值一开始是

```auto
{
    "took": 69,
    "timed_out": false,
    "total": 388,
    "updated": 388,
    "deleted": 0,
    "batches": 1,
    "version_conflicts": 0,
    "noops": 0,
    "retries": {
        "bulk": 0,
        "search": 0
    },
    "throttled_millis": 0,
    "requests_per_second": -1,
    "throttled_until_millis": 0,
    "failures": []
}

```

变成

```auto
{
    "took": 22,
    "timed_out": false,
    "total": 388,
    "updated": 0,
    "deleted": 0,
    "batches": 1,
    "version_conflicts": 388,
    "noops": 0,
    "retries": {
        "bulk": 0,
        "search": 0
    },
    "throttled_millis": 0,
    "requests_per_second": -1,
    "throttled_until_millis": 0,
    "failures": []
}

```

updated 值为 0 。频繁更新下 elasticsearch 会不更新吗？

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 4, 2020, 9:50am UTC](https://discuss.elastic.co/t/elasticsearch-update-by-query-problem/226611/3 "2020-05-04T09:50:00Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.