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