Sql_last_value resets to 1969-12-31 19.00.00 after logstash restart

Elastic Stack Logstash
1

I have written a conf file as below to get data from Oracle SQL

jdbc {
jdbc_driver_library => "C:\dev\script\config\mssql-jdbc-6.2.2.jre8.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://1.2.3.4:1433;databaseName=MyDB;"
jdbc_user => "user"
jdbc_password => "****"
jdbc_validate_connection => true
schedule => "/3 * * * * *"
statement_filepath => "C:\dev\script\sql\script_es.sql"
last_run_metadata_path => "C:\dev\script\es_jdbc_last_run_metadata.log"
}

If I restart logstash it is not picking up from last run value, instead It resetting value to TIMESTMAP '1969-12-31 19.00.00 '.
if I keep the logstash scheduled for every 5min or something, it works as expected.

I am using this command to start logstash = > " logstash -f abc.conf --config.reload.automatic --path.data=C:/home/test/folder "

2

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