# Update document id issue

**URL:** <https://discuss.elastic.co/t/update-document-id-issue/62643>\
**Category:** Logstash\
**Created:** [October 10, 2016, 3:21pm UTC](https://discuss.elastic.co/t/update-document-id-issue/62643 "2016-10-10T15:21:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ggp](https://avatars.discourse-cdn.com/v4/letter/g/278dde/32.png) [@ggp](https://discuss.elastic.co/u/ggp)\
**Post date:** [October 10, 2016, 3:21pm UTC](https://discuss.elastic.co/t/update-document-id-issue/62643/1 "2016-10-10T15:21:17Z")

</div>

I am trying to update one of the document id's "name" field value and don't see the document getting updated, any inputs would be very helpful. Here is the log stash config i have

> input {  
> jdbc {  
> # Postgres jdbc connection string to our database, mydb  
> jdbc\_connection\_string =\> "jdbc:postgresql://127.0.0.1:5009/data"  
> # The user we wish to execute our statement as  
> jdbc\_user =\> "data"  
> jdbc\_password=\>"data"  
> # The path to our downloaded jdbc driver  
> jdbc\_driver\_library =\> "/postgresql-9.4.1209.jar"  
> # The name of the driver class for Postgresql  
> jdbc\_driver\_class =\> "org.postgresql.Driver"  
> #sql\_log\_level =\> "debug"  
> jdbc\_paging\_enabled =\> "true"  
> jdbc\_page\_size =\> "5000"  
> schedule =\> "\* \* \* \* \*"  
> # our query  
> clean\_run =\> true  
> last\_run\_metadata\_path =\> "/logstash/.test\_metadata"  
> use\_column\_value =\> true  
> tracking\_column =\> id  
> statement =\> "SELECT id,name,update\_date from data where id \> :sql\_last\_value"  
> }  
> }

> output {  
> elasticsearch{  
> hosts =\> ["127.0.0.1"]  
> index =\> "test\_data"  
> action =\> "index"  
> document\_type =\> "data"  
> document\_id =\> "%{id}"  
> upsert =\> ' {  
> "name" : "%{data.name}",  
> "update\_date" : "%{data.update\_date}"  
> } '  
> }  
> }

---

<div class="post-metadata">

**Author:** ![ggp](https://avatars.discourse-cdn.com/v4/letter/g/278dde/32.png) [@ggp](https://discuss.elastic.co/u/ggp)\
**Post date:** [October 16, 2016, 3:17pm UTC](https://discuss.elastic.co/t/update-document-id-issue/62643/2 "2016-10-16T15:17:50Z")

</div>

can someone please help me here with any missing configs

---

<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:** [July 6, 2017, 4:34am UTC](https://discuss.elastic.co/t/update-document-id-issue/62643/3 "2017-07-06T04:34:04Z")

</div>