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!