Horton

Re: could not send data to client: Connection reset by peer

Tomas Vondra <tomas@vondra.me>

View thread View on postgr.es
From: Tomas Vondra <tomas@vondra.me>
To: James Pang <jamespang886@gmail.com>, pgsql-performance@lists.postgresql.org
Date: 2024-11-23T01:38:13Z
Lists: pgsql-performance 
On 11/21/24 13:13, James Pang wrote:
> experts,
>    Postgresql v14.8,  client app use Postgresql JDBC, it start a single
> query that return 470k rows totally in one time, but sometimes, database
> server side got error "could not send data to client: Connection reset
> by peer". 
>    any idea why it faced this error? 
> 

This means the TCP/IP connection got closed abruptly. It might be
because the client had some issue, or something on the network path
decided to block the connection (like a router or a firewall).


regards

-- 
Tomas Vondra