Hello all, I am using Logstash 6.5.4 and started pulling data from my SQL Server, the first 50,000 records went in fine by batches of 10,000 at a time, but after a couple of hours.. everything stopped updating, the tracking files do not change anymore and no new data is coming in... could someone telle me what is going on... here are my lines of settings..
select top 10000 * from datasource WHERE convert(datetime,LogonDate,126) > CONVERT(datetime, :sql_last_value, 126) ORDER BY logondate"
clean_run => false
schedule => "0 */1 * * * *"
use_column_value => true
record_last_run => true
tracking_column => "logondate"
tracking_column_type => "timestamp"
last_run_metadata_path => "C:\Program Files\Elasticsearch\logstash-6.5.4\Tracking\last_run_LOGIN.txt"