Message-ID: <41089e4c-6959-4698-a49c-2f6d9231b330@vondra.me>
Date: Sat, 23 Nov 2024 02:38:13 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: could not send data to client: Connection reset by peer
To: James Pang <jamespang886@gmail.com>,
 pgsql-performance@lists.postgresql.org
References: 
 <CAHgTRffh9=2Uy_vHsw0=sXiZxY5RfhEQBHyZuyHGhLUcw=KRtA@mail.gmail.com>
Content-Language: en-US
From: Tomas Vondra <tomas@vondra.me>
In-Reply-To: 
 <CAHgTRffh9=2Uy_vHsw0=sXiZxY5RfhEQBHyZuyHGhLUcw=KRtA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/41089e4c-6959-4698-a49c-2f6d9231b330%40vondra.me>
Precedence: bulk

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