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

could not send data to client: Connection reset by peer

From
James Pang
Date:
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? 

Thanks,

James 

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

From
Tomas Vondra
Date:
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