Feedback-ID: i76984098:Fastmail
Message-ID: <9dab3561-3b45-4dac-9522-c84192f87d52@aklaver.com>
Date: Tue, 14 Jan 2025 09:56:33 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
To: Enrico Schenone <eschenone@cleistech.it>,
 pgsql-general@lists.postgresql.org
Cc: Massimo Catti <mcatti@cleistech.it>, Livio Pizzolo <lpizzolo@cleistech.it>
References: <446423eb-4a4e-4135-bbb8-4d0e5c7aac3b@cleistech.it>
 <25d5fb16-9bb2-4ad1-969c-eaca03ccbaaf@aklaver.com>
 <6ce80aaa-970b-4432-938a-39a07f811599@cleistech.it>
 <9f60eb26-7d34-4228-bd78-74c6deb90e54@aklaver.com>
 <282c2a48-bb12-4486-b03d-563523cac81b@cleistech.it>
 <2645a89e-d661-4f2b-92b3-01154a78d535@aklaver.com>
 <e2332684-8d0f-47ba-a5ef-5b2b9c9f8cf0@cleistech.it>
 <54689a6a-839c-44c4-90b5-b9692e8e7cb0@aklaver.com>
 <4efe42a2-789c-4957-a564-25199869f6ec@cleistech.it>
 <e906a6a1-e97d-4bf7-afe3-21a430b3a944@aklaver.com>
 <ec5ce003-6ad9-4cfd-8186-6ca66f285ad3@cleistech.it>
 <b5e32ab4-2187-45f0-b360-47f82d481ff8@aklaver.com>
 <382a1eec-2069-4010-bbdb-37260a1a53a7@cleistech.it>
 <cdfa3e0c-a5cc-4f29-bcb7-72056ae03f1e@aklaver.com>
 <eca91527-07a8-42d6-b4d6-7cf75b946dd7@cleistech.it>
 <8d65f84d-ddb3-4d0f-be05-44f443500e41@aklaver.com>
 <54b91cf3-1d0c-4134-89c8-8e76ed46415c@cleistech.it>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <54b91cf3-1d0c-4134-89c8-8e76ed46415c@cleistech.it>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/9dab3561-3b45-4dac-9522-c84192f87d52%40aklaver.com>
Precedence: bulk


On 1/13/25 11:56 PM, Enrico Schenone wrote:
> Il 13/01/25 18:26, Adrian Klaver ha scritto:


>> In your OP you stated:
>>
>> "Production environments can be:
>>
>>  * Distinct application server and DB server on distinct subnets (no
>>     dropped packet detected on firewall, no memory/disk/network failure
>>     detected by "nmon" tool)
>>   * Distinct application server and DB server on same subnet (no 
>> firewall)
>>   * Same server for PostgreSQL and applications
>> "
>>
>> In all those cases are the various servers all running completely 
>> within the providers infrastructure?
>>
> No, the second production environment is On Premises at the customer 
> Datacenter under the same vmware hypervisor.en

Which environment did you run the recent prolonged test against?

> I'll make more investigations on second and third environments by 
> increasing the verbosity of both DB and Application logs.
>
> *Enrico Schenone*
> Software Architect
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com