public inbox for [email protected]  
help / color / mirror / Atom feed
could not send data to client: Connection reset by peer
2+ messages / 2 participants
[nested] [flat]

* could not send data to client: Connection reset by peer
@ 2024-11-21 12:13  James Pang <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: James Pang @ 2024-11-21 12:13 UTC (permalink / raw)
  To: [email protected]

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: could not send data to client: Connection reset by peer
@ 2024-11-23 01:38  Tomas Vondra <[email protected]>
  parent: James Pang <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tomas Vondra @ 2024-11-23 01:38 UTC (permalink / raw)
  To: James Pang <[email protected]>; [email protected]

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-11-23 01:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-21 12:13 could not send data to client: Connection reset by peer James Pang <[email protected]>
2024-11-23 01:38 ` Tomas Vondra <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox