# State tracker file update - JDBC input plugin

**URL:** <https://discuss.elastic.co/t/state-tracker-file-update-jdbc-input-plugin/263268>\
**Category:** Logstash\
**Created:** [February 4, 2021, 4:53pm UTC](https://discuss.elastic.co/t/state-tracker-file-update-jdbc-input-plugin/263268 "2021-02-04T16:53:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mruthyu](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@mruthyu](https://discuss.elastic.co/u/mruthyu)\
**Post date:** [February 4, 2021, 4:53pm UTC](https://discuss.elastic.co/t/state-tracker-file-update-jdbc-input-plugin/263268/1 "2021-02-04T16:53:23Z")

</div>

Would like to know when the state tracker file get's updated. We are using the jdbc input plugin and modified date from the table has been used as the state tracker field. Would like to know when the state tracker files gets updated - Is it when the record has been read or the records have been indexed into elasticsearch and then after receiving the acknowledgement from elasticsearch.

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [February 4, 2021, 5:04pm UTC](https://discuss.elastic.co/t/state-tracker-file-update-jdbc-input-plugin/263268/2 "2021-02-04T17:04:32Z")

</div>

The file is [updated](https://github.com/logstash-plugins/logstash-input-jdbc/blob/0cee881dcdae5ba75716dacab54aba8da13086b6/lib/logstash/plugin_mixins/jdbc/jdbc.rb#L255) when the SQL statement is successfully executed. The input cannot know what filters or outputs its events will be sent to, so it cannot know that you intend to index them.

---

<div class="post-metadata">

**Author:** ![mruthyu](https://avatars.discourse-cdn.com/v4/letter/m/bb73d2/32.png) [@mruthyu](https://discuss.elastic.co/u/mruthyu)\
**Post date:** [February 10, 2021, 7:28am UTC](https://discuss.elastic.co/t/state-tracker-file-update-jdbc-input-plugin/263268/3 "2021-02-10T07:28:27Z")

</div>

Thank you.

---

<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:** [March 10, 2021, 7:29am UTC](https://discuss.elastic.co/t/state-tracker-file-update-jdbc-input-plugin/263268/4 "2021-03-10T07:29:04Z")

</div>

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