Thread

1. could not send data to client: Connection reset by peer

   James Pang <jamespang886@gmail.com> — 2024-11-21T12:13:10Z

   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
   

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

   Tomas Vondra <tomas@vondra.me> — 2024-11-23T01:38:13Z

   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