# Logstash stops executing jdbc query

**URL:** <https://discuss.elastic.co/t/logstash-stops-executing-jdbc-query/209460>\
**Category:** Logstash\
**Created:** [November 26, 2019, 9:56am UTC](https://discuss.elastic.co/t/logstash-stops-executing-jdbc-query/209460 "2019-11-26T09:56:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayden](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayden/32/51432_2.png) [@Ayden](https://discuss.elastic.co/u/Ayden)\
**Post date:** [November 26, 2019, 9:56am UTC](https://discuss.elastic.co/t/logstash-stops-executing-jdbc-query/209460/1 "2019-11-26T09:56:24Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 24, 2019, 9:56am UTC](https://discuss.elastic.co/t/logstash-stops-executing-jdbc-query/209460/2 "2019-12-24T09:56:30Z")

</div>

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