# Jdbc input plugin -- cannot locate last\_run\_metadata\_path

**URL:** <https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716>\
**Category:** Logstash\
**Created:** [May 23, 2016, 12:41pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716 "2016-05-23T12:41:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Neil\_Alex](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neil_alex/32/61990_2.png) [@Neil\_Alex](https://discuss.elastic.co/u/Neil_Alex)\
**Post date:** [May 23, 2016, 12:41pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716/1 "2016-05-23T12:41:49Z")

</div>

Hello ,

I am using logstash 2.3 in an Ubuntu 14.04 , not as a service ( just extracted the tar.gz ). I successfully ran logstash jdbc input plugin and fetched some data from my sql server. Now I wanna re run the same , i forgot to set record\_last\_run to false during the test run. Now when i try to re run it logstasg is standing still.. How can i get it to read the data again? I tried to locate .logstash\_jdbc\_last\_run with no luck.

Thanks

Neil

---

<div class="post-metadata">

**Author:** ![jcome](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@jcome](https://discuss.elastic.co/u/jcome)\
**Post date:** [May 23, 2016, 1:36pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716/2 "2016-05-23T13:36:12Z")

</div>

On windows, it is in the main directory of the user (C:/Users/%username%).  
Did you try in /root, /home/user or even in /tmp (where applications data are)?

---

<div class="post-metadata">

**Author:** ![Neil\_Alex](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/neil_alex/32/61990_2.png) [@Neil\_Alex](https://discuss.elastic.co/u/Neil_Alex)\
**Post date:** [May 23, 2016, 3:42pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716/3 "2016-05-23T15:42:50Z")

</div>

Yeah... i checked all of them... in /root , /home as well as tmp. Its not there.. when i echo the $USER\_HOME its an empty line. I assume its not set...

---

<div class="post-metadata">

**Author:** ![jcome](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@jcome](https://discuss.elastic.co/u/jcome)\
**Post date:** [May 24, 2016, 8:34am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716/4 "2016-05-24T08:34:55Z")

</div>

If you look at the input-jdbc configuration, you have  
(vendor\bundle\jruby\1.9\gems\logstash-input-jdbc-XXX\lib\logstash\inputs)

# Path to file with last run time

config :last\_run\_metadata\_path, :validate =\> :string, :default =\> "#{ENV['HOME']}/.logstash\_jdbc\_last\_run"

Or just male a "Select \* from table" without using sql\_last\_run, that should be working correctly.

---

<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:56am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-cannot-locate-last-run-metadata-path/50716/5 "2017-07-06T04:56:30Z")

</div>