# Handle SQL JDBC input errors

**URL:** <https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633>\
**Category:** Logstash\
**Created:** [May 21, 2018, 8:53am UTC](https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633 "2018-05-21T08:53:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![emon1](https://avatars.discourse-cdn.com/v4/letter/e/8c91f0/32.png) [@emon1](https://discuss.elastic.co/u/emon1)\
**Post date:** [May 21, 2018, 8:53am UTC](https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633/1 "2018-05-21T08:53:59Z")

</div>

Is there a way to handle JDBC input failures so that the main Logstash pipeline does not not stop and restart every time an error is thrown by one input ?

---

<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 21, 2018, 7:27pm UTC](https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633/2 "2018-05-21T19:27:16Z")

</div>

Probably not, but what behavior would you prefer? What kind of JDBC failures are you having?

---

<div class="post-metadata">

**Author:** ![emon1](https://avatars.discourse-cdn.com/v4/letter/e/8c91f0/32.png) [@emon1](https://discuss.elastic.co/u/emon1)\
**Post date:** [May 21, 2018, 9:31pm UTC](https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633/3 "2018-05-21T21:31:00Z")

</div>

We have multiple JDBCs pointed at different Databases and occasionally one of those databases may not be available resulting in SQL(e.g tcp/ip connection to the host failed) errors being thrown by the input and crashing the main pipeline. I'd like to be able to handle the error in someway so as the main pipeline continues to run and does its work with the other jdbc inputs.

---

<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 22, 2018, 9:14pm UTC](https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633/4 "2018-05-22T21:14:30Z")

</div>

That's probably not possible today, but I think it sounds like a bug. A transient connection problem should be dealt with in a graceful manner.

---

<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 19, 2018, 9:14pm UTC](https://discuss.elastic.co/t/handle-sql-jdbc-input-errors/132633/5 "2018-06-19T21:14:42Z")

</div>

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