Re: An I/O error occurred while sending to the backend (PG 13.4) - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: An I/O error occurred while sending to the backend (PG 13.4)
Date
Msg-id 20220303164604.GH27651@telsasoft.com
Whole thread Raw
In response to Re: An I/O error occurred while sending to the backend (PG 13.4)  (Ranier Vilela <ranier.vf@gmail.com>)
Responses Re: An I/O error occurred while sending to the backend (PG 13.4)  (Ranier Vilela <ranier.vf@gmail.com>)
List pgsql-performance
On Thu, Mar 03, 2022 at 01:33:08PM -0300, Ranier Vilela wrote:
> Sorry, but this is much more on the client side.

The client is reporting the problem, as is the server.

> Following the logs, it is understood that the client is dropping the
> connection.

The logs show that the client's connection *was* dropped.
And on the server, the same.

> So most likely the error could be from Pentaho or JDBC.
> 
> https://www.geeksforgeeks.org/java-net-socketexception-in-java-with-examples/
> " This *SocketException* occurs on the server-side when the client closed
> the socket connection before the response could be returned over the
> socket."
> 
> I suggest moving this thread to the Pentaho or JDBC support.

We don't know the source of the problem.  I still doubt it's in postgres, but I
don't think it's helpful to blame the client, just because the client reported
the problem.  If the server were to disconnect abruptly, I'd expect the client
to report that, too.

Laurent would just have to start the conversation over (and probably collect
the same diagnostic information anyway).  The client projects could blame
postgres with as much rationale as there is for us to blame the client.

Please don't add confusion here.  I made suggestions for how to collect more
information to better understand the source of the problem, and there's
probably not much else to say without that.

-- 
Justin



pgsql-performance by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: An I/O error occurred while sending to the backend (PG 13.4)
Next
From: Ranier Vilela
Date:
Subject: Re: An I/O error occurred while sending to the backend (PG 13.4)