How to rerun Logstash jdbc input plugin?

Question

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 plug-in 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.

When I try to re run it logstash is still standing. How can I get it to read the data again?

I tried to locate .logstash_jdbc_last_run with no luck in /home , /root and even /tmp. When I echo $USER_HOME it shows an empty line.

Answer 1

You can try to set clean_run to true.

https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-clean_run

clean_run

• Value type is boolean
• Default value is false

Whether the previous run state should be preserved