# JDBC can't connect anymore for no apparent reason

**URL:** <https://discuss.elastic.co/t/jdbc-cant-connect-anymore-for-no-apparent-reason/114379>\
**Category:** Logstash\
**Created:** [January 6, 2018, 2:55pm UTC](https://discuss.elastic.co/t/jdbc-cant-connect-anymore-for-no-apparent-reason/114379 "2018-01-06T14:55:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![arisbanach](https://avatars.discourse-cdn.com/v4/letter/a/f07891/32.png) [@arisbanach](https://discuss.elastic.co/u/arisbanach)\
**Post date:** [January 6, 2018, 2:55pm UTC](https://discuss.elastic.co/t/jdbc-cant-connect-anymore-for-no-apparent-reason/114379/1 "2018-01-06T14:55:59Z")

</div>

I keep getting this error:

> [2018-01-06T14:53:40,534][ERROR][logstash.inputs.jdbc] Java::OrgPostgresqlUtil::PSQLException: An I/O error occurred while sending to the backend.: SELECT count(\*) AS "count" FROM (SELECT \* from tracking WHERE id \> 159000000 ORDER BY id) AS "t1" LIMIT 1  
> [2018-01-06T14:53:40,537][WARN][logstash.inputs.jdbc] Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseDisconnectError: Java::OrgPostgresqlUtil::PSQLException: An I/O error occurred while sending to the backend.\>}

I didn't change any credentials for the database, and when I check the status on AWS it says it's fine and up and running.

Edit: I stopped Logstash and restarted it but it still gave me this error right away. I evidently had to wait for a bit and restarting worked. Shouldn't Logstash see this connection and just restart it or something automatically?

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [January 8, 2018, 12:14pm UTC](https://discuss.elastic.co/t/jdbc-cant-connect-anymore-for-no-apparent-reason/114379/2 "2018-01-08T12:14:13Z")

</div>

Moved discussion to here [Why does Logstash not restart from JDBC I/O errors?](https://discuss.elastic.co/t/why-does-logstash-not-restart-from-jdbc-i-o-errors/114422/2?u=guyboertje)

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [January 8, 2018, 12:14pm UTC](https://discuss.elastic.co/t/jdbc-cant-connect-anymore-for-no-apparent-reason/114379/3 "2018-01-08T12:14:21Z")

</div>