How to have a checkpoint using a TimeStamp field (sql_last_value)

Hi ELK community,
Here is a challenge that I am facing while tracking a TimeStamp filed in logstash.

I am connecting to Postgresql table which has a field named "Recorded_time" with a datatype TimeStamp.
I want to have this field as the tracking field in my Logstash configuration file.
Here is the challenge that I am currently facing and need help from the community.
The sql_last_value of the tracked column "Recorded_time" is not getting saved in the file "logstash_jdbc_last_run_t_data.txt" (refer to the config file detail: last_run_metadata_path => "C:/ELK/logstash_jdbc_last_run_t_data.txt")

For your reference here is an Example: Value stored in the column "Recorded_time" = "2018-01-28 04:22:59.171428-05"

Here is how my Config file looks like.

use_column_value => true
tracking_column => recorded_time
record_last_run => true
tracking_column_type => "timestamp"
jdbc_default_timezone => "US/Eastern"
last_run_metadata_path => "C:/ELK/logstash_jdbc_last_run_t_data.txt"

Any help on this is highly appreciated.

Naveen Silvester

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