Logstash JDBC_last _ not updating

Hi ,

I'm new to Elasticsearch and Logstash, trying to implement JDBC plugin.
I'm not sure why .logstash_last_run file is not getting updated. The values inside the file remains the same even after several runs.
value in file:
--- 0

Logstash conf file
input {
jdbc {
jdbc_validate_connection => true
jdbc_driver_library => "C:\Users\xxxx\Oracle\ojdbc\ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@xxxxxxx:xxxx/xx"
jdbc_user => "xxxx"
jdbc_password => "xxxxx"
schedule => "* * * * *"
statement => "SELECT SNO, UNITID FROM CONTAINERS WHERE SNO > :sql_last_value order by SNO"
clean_run => true
use_column_value => true
tracking_column => "SNO"
tracking_column_type => "numeric"
last_run_metadata_path => "C:\Users\xxxx.logstash_jdbc_last_run"

If you use 'clean_run => true' the contents of the file will get set to 0 each time the input is initialized.

Thanks a lot for the reply

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