Logstash JDBC input plugin: Java::OrgPostgresqlUtil::PSQLException: An I/O error occurred while sending to the backend

Elastic Stack Logstash
1

Hi all,

I have created a Logstash pipeline which aims to sync an Elasticsearch index with a Postgres database. Unfortunately, there is a query that does not perform well and takes quite some time. Once every now and then I receive the following error message:

Exception when executing JDBC query {:exception=>Sequel::DatabaseDisconnectError, :message=>"Java::OrgPostgresqlUtil::PSQLException: An I/O error occurred while sending to the backend.", :cause=>"#<Java::OrgPostgresqlUtil::PSQLException: An I/O error occurred while sending to the backend.>"}

I am not sure what is causing it, how to debug it, and how to resolve it. I was thinking if it may have something to do with timeouts, but I would expect different error messages then.

Could anyone help me? Thanks!

2

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