# Logstash-6.2.4 Pipeline has terminated

**URL:** https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010
**Category:** Logstash
**Created:** [May 23, 2018, 2:44pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010 "2018-05-23T14:44:59Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)
#### Post date: [May 23, 2018, 2:45pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010/1 "2018-05-23T14:45:00Z")

</div>

> vadim@vadim-HP:~/www/FULL/Search/logstash-6.2.4$ bin/logstash -f logstash-simple.conf  
> Sending Logstash's logs to /home/vadim/www/FULL/Search/logstash-6.2.4/logs which is now configured via log4j2.properties  
> [2018-05-23T17:36:54,711][INFO][logstash.modules.scaffold] Initializing module {:module\_name=\>"netflow", :directory=\>"/home/vadim/www/FULL/Search/logstash-6.2.4/modules/netflow/configuration"}  
> [2018-05-23T17:36:54,768][INFO][logstash.modules.scaffold] Initializing module {:module\_name=\>"fb\_apache", :directory=\>"/home/vadim/www/FULL/Search/logstash-6.2.4/modules/fb\_apache/configuration"}  
> [2018-05-23T17:36:55,554][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified  
> [2018-05-23T17:36:56,823][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"6.2.4"}  
> [2018-05-23T17:36:57,597][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600}  
> [2018-05-23T17:37:01,451][WARN][logstash.outputs.elasticsearch] You are using a deprecated config setting "document\_type" set in elasticsearch. Deprecated settings will continue to work, but are scheduled for removal from logstash in the future. Document types are being deprecated in Elasticsearch 6.0, and removed entirely in 7.0. You should avoid this feature If you have any questions about this, please visit the #logstash channel on freenode irc. {:name=\>"document\_type", :plugin=\>\<LogStash::Outputs::Elasticsearch index=\>"products", document\_type=\>"products\_description", document\_id=\>"%{products\_id}", hosts=\>[[//127.0.0.1](https://127.0.0.1)], id=\>"fee76b4ebc3936f44487d37029b879b6a5bcea82e7731c9dddc5438cb7ef717c", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_ce825696-9529-4bac-a8f4-4d07ce9ba113", enable\_metric=\>true, charset=\>"UTF-8"\>, workers=\>1, manage\_template=\>true, template\_name=\>"logstash", template\_overwrite=\>false, doc\_as\_upsert=\>false, script\_type=\>"inline", script\_lang=\>"painless", script\_var\_name=\>"event", scripted\_upsert=\>false, retry\_initial\_interval=\>2, retry\_max\_interval=\>64, retry\_on\_conflict=\>1, action=\>"index", ssl\_certificate\_verification=\>true, sniffing=\>false, sniffing\_delay=\>5, timeout=\>60, pool\_max=\>1000, pool\_max\_per\_route=\>100, resurrect\_delay=\>5, validate\_after\_inactivity=\>10000, http\_compression=\>false\>}  
> [2018-05-23T17:37:01,693][INFO][logstash.pipeline] Starting pipeline {:pipeline\_id=\>"main", "pipeline.workers"=\>4, "pipeline.batch.size"=\>125, "pipeline.batch.delay"=\>50}  
> [2018-05-23T17:37:02,668][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=\>{:removed=\>, :added=\>[[http://127.0.0.1:9200/](http://127.0.0.1:9200/)]}}  
> [2018-05-23T17:37:02,691][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck\_url=\>[http://127.0.0.1:9200/](http://127.0.0.1:9200/), :path=\>"/"}  
> [2018-05-23T17:37:03,010][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=\>"[http://127.0.0.1:9200/](http://127.0.0.1:9200/)"}  
> [2018-05-23T17:37:03,117][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es\_version=\>6}  
> [2018-05-23T17:37:03,123][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document \_type {:es\_version=\>6}  
> [2018-05-23T17:37:03,157][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=\>nil}  
> [2018-05-23T17:37:03,204][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"match"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_float"}}}}}}}}  
> [2018-05-23T17:37:03,299][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::Elasticsearch", :hosts=\>["[//127.0.0.1](https://127.0.0.1)"]}  
> [2018-05-23T17:37:03,791][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x41822b3a run\>"}  
> [2018-05-23T17:37:03,957][INFO][logstash.agent] Pipelines running {:count=\>1, :pipelines=\>["main"]}  
> [2018-05-23T17:37:09,185][INFO][logstash.inputs.jdbc] (3.187628s) SELECT products.products\_id, products\_description.products\_name, categories\_description.categories\_name, products\_description.products\_keywords, products.products\_page\_url FROM products LEFT JOIN products\_description ON products.products\_id = products\_description.products\_id LEFT JOIN products\_to\_categories ON products\_description.products\_id = products\_to\_categories.products\_id LEFT JOIN categories\_description ON products\_to\_categories.categories\_id = categories\_description.categories\_id WHERE products.products\_status = 1;  
> [2018-05-23T17:39:03,383][INFO][logstash.pipeline] Pipeline has terminated {:pipeline\_id=\>"main", :thread=\>"#\<Thread:0x41822b3a run\>"}

 ![Selection_468](https://us1.discourse-cdn.com/elastic/original/3X/e/d/ed1de83485c1ca902f8cabf5add245d7cbd21146.png)

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [May 24, 2018, 6:20am UTC](https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010/2 "2018-05-24T06:20:29Z")

</div>

If you only have one jdbc input and you're not using the schedule feature Logstash _will_ shut down once it has processed the results of a single query.

---

<div class="post-metadata">

### Author: ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)
#### Post date: [May 24, 2018, 8:56am UTC](https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010/3 "2018-05-24T08:56:17Z")

</div>

Could you show me example?

---

<div class="post-metadata">

### Author: ![sm00thindian](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sm00thindian/32/27376_2.png) [@sm00thindian](https://discuss.elastic.co/u/sm00thindian)
#### Post date: [May 24, 2018, 9:15am UTC](https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010/4 "2018-05-24T09:15:41Z")

</div>

input {  
jdbc {  
schedule =\> "\*\*\*\*\*"  
statement =\> "SELECT id, mycolumn1, mycolumn2 FROM my\_table WHERE id \> :sql\_last\_value"  
use\_column\_value =\> true  
tracking\_column =\> "id"  
# ... other configuration bits  
}  
}  
Above schedule will run the statement, in Cron format for example: "\* \* \* \* \*" (execute query every minute, on the minute)

---

<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: [June 21, 2018, 9:15am UTC](https://discuss.elastic.co/t/logstash-6-2-4-pipeline-has-terminated/133010/5 "2018-06-21T09:15:44Z")

</div>

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