# Match\_all & update\_by\_query & script error!

**URL:** <https://discuss.elastic.co/t/match-all-update-by-query-script-error/213724>\
**Category:** Elasticsearch\
**Created:** [January 3, 2020, 3:38pm UTC](https://discuss.elastic.co/t/match-all-update-by-query-script-error/213724 "2020-01-03T15:38:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![laoyang360](https://avatars.discourse-cdn.com/v4/letter/l/a9a28c/32.png) [@laoyang360](https://discuss.elastic.co/u/laoyang360)\
**Post date:** [January 3, 2020, 3:38pm UTC](https://discuss.elastic.co/t/match-all-update-by-query-script-error/213724/1 "2020-01-03T15:38:45Z")

</div>

```auto
# running ok
    POST products/_update_by_query
    {
      "script": {
        "source": "ctx._source.in_stock++",
        "lang": "painless"
      },
      "query": {
        "term": {
          "name": "LED TV"
        }
      }
    }
# running ok
    POST products/_search
    {
      "query": {
          "match_all": {}
      }
    }
# running error
    POST products/_update_by_query
    {
      "script": {
        "source": "ctx._source.in_stock++",
        "lang": "painless"
      },
      "query": {
          "match_all": {}
      }
    }

```

The errors as below:

{  
"error": {  
"root\_cause": [  
{  
"type": "script\_exception",  
"reason": "runtime error",  
"script\_stack": [  
"ctx.\_source.in\_stock++",  
"^---- HERE"  
],  
"script": "ctx.\_source.in\_stock++",  
"lang": "painless"  
}  
],  
"type": "script\_exception",  
"reason": "runtime error",  
"script\_stack": [  
"ctx.\_source.in\_stock++",  
"^---- HERE"  
],  
"script": "ctx.\_source.in\_stock++",  
"lang": "painless",  
"caused\_by": {  
"type": "null\_pointer\_exception",  
"reason": null  
}  
},  
"status": 400  
}

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [January 3, 2020, 3:55pm UTC](https://discuss.elastic.co/t/match-all-update-by-query-script-error/213724/2 "2020-01-03T15:55:07Z")

</div>

> [@laoyang360](#):
>
> in\_stock

may be some of the field in\_stock is value nill ?

---

<div class="post-metadata">

**Author:** ![laoyang360](https://avatars.discourse-cdn.com/v4/letter/l/a9a28c/32.png) [@laoyang360](https://discuss.elastic.co/u/laoyang360)\
**Post date:** [January 4, 2020, 12:45am UTC](https://discuss.elastic.co/t/match-all-update-by-query-script-error/213724/3 "2020-01-04T00:45:34Z")

</div>

```
# running ok
    POST products/_update_by_query
    {
      "script": {
        "source": "ctx._source.in_stock++",
        "lang": "painless"
      },
      "query": {
            "exists": {
            "field": "in_stock"
          }
      }
    }

```

Yes, you are right! thanks!

---

<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:** [February 1, 2020, 12:45am UTC](https://discuss.elastic.co/t/match-all-update-by-query-script-error/213724/4 "2020-02-01T00:45:46Z")

</div>

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