| From: | Tomas Vondra <tomas(at)vondra(dot)me> |
|---|---|
| To: | James Pang <jamespang886(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: could not send data to client: Connection reset by peer |
| Date: | 2024-11-23 01:38:13 |
| Message-ID: | 41089e4c-6959-4698-a49c-2f6d9231b330@vondra.me |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Lepikhov | 2024-11-23 02:07:17 | Re: Cardinality estimate of the inner relation |
| Previous Message | Frédéric Yhuel | 2024-11-22 15:53:39 | Cardinality estimate of the inner relation |