I have multiple jdbc input plugins in logstash writing to different indices in elastic search.
I'm using sql_last_value to send incremental updates. However, the timestamp in last_run_metadata_path is only getting updated where there are updates to the MySQL database. If there are no updates, timestamp in the last_run_metadata_path file is not updating. Is this expected?
I deleted the files and restarted logstash. However, the old timestamps are back. Has anyone seen this?
Deleting the file while logstash is running isn't of use because logstash writes the file again on shutdown to preserve the last state. To start a new you would have to shutdown logstash, delete the file and start logstash again (or use the config option clean_run to ignore the value saved).
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.