Logstash stops executing jdbc query

Elastic Stack Logstash
1

Hello,

I have logstash running a jdbc input with a 5 minute scheduler and after few hours logstash stops doing the query.

The latest log I have is:

[2019-11-25T18:00:31,645][DEBUG][logstash.inputs.jdbc     ] Executing JDBC query {:statement=>"my sql statement", :parameters=>{:sql_last_value=>436524103}, :count=>12287}
[2019-11-25T18:00:33,495][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline.
[2019-11-25T18:00:33,749][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ParNew"}
[2019-11-25T18:00:33,749][DEBUG][logstash.instrument.periodicpoller.jvm] collector name {:name=>"ConcurrentMarkSweep"}
[2019-11-25T18:00:35,613][DEBUG][org.logstash.execution.PeriodicFlush] Pushing flush onto pipeline.
[2019-11-25T18:00:36,757][DEBUG][logstash.inputs.metrics  ] Metrics input: received a new snapshot {:created_at=>2019-11-25 18:00:36 UTC, :snapshot=>#<LogStash::Instrument::Snapshot:0x23bd684>}

Before this there isn't any error, only Info messages of logstash executing the query and debug output.

Logstash keeps running but the only output is the debug message about periodicflush repeated.

Any suggestion?

2

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