public inbox for [email protected]help / color / mirror / Atom feed
Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 4+ messages / 2 participants [nested] [flat]
* Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 @ 2025-01-14 17:56 Adrian Klaver <[email protected]> 2025-01-15 07:46 ` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Enrico Schenone <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Adrian Klaver @ 2025-01-14 17:56 UTC (permalink / raw) To: Enrico Schenone <[email protected]>; [email protected]; +Cc: Massimo Catti <[email protected]>; Livio Pizzolo <[email protected]> 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 [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 2025-01-14 17:56 Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Adrian Klaver <[email protected]> @ 2025-01-15 07:46 ` Enrico Schenone <[email protected]> 2025-01-15 16:03 ` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Adrian Klaver <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Enrico Schenone @ 2025-01-15 07:46 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; Enrico Schenone <[email protected]>; [email protected]; +Cc: Massimo Catti <[email protected]>; Livio Pizzolo <[email protected]> Il 14/01/25 18:56, Adrian Klaver ha scritto: > > > 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? The first one: Distinct application server and DB server on distinct subnets. > >> I'll make more investigations on second and third environments by >> increasing the verbosity of both DB and Application logs. >> >> *Enrico Schenone* >> Software Architect >> > *Enrico Schenone* Software Architect ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 2025-01-14 17:56 Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Adrian Klaver <[email protected]> 2025-01-15 07:46 ` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Enrico Schenone <[email protected]> @ 2025-01-15 16:03 ` Adrian Klaver <[email protected]> 2025-01-15 17:10 ` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Enrico Schenone <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Adrian Klaver @ 2025-01-15 16:03 UTC (permalink / raw) To: Enrico Schenone <[email protected]>; [email protected]; +Cc: Massimo Catti <[email protected]>; Livio Pizzolo <[email protected]> On 1/14/25 23:46, Enrico Schenone wrote: >> Which environment did you run the recent prolonged test against? > The first one: Distinct application server and DB server on distinct > subnets. >> Is that the same as where you saw the errors? > *Enrico Schenone* > Software Architect -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 2025-01-14 17:56 Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Adrian Klaver <[email protected]> 2025-01-15 07:46 ` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Enrico Schenone <[email protected]> 2025-01-15 16:03 ` Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Adrian Klaver <[email protected]> @ 2025-01-15 17:10 ` Enrico Schenone <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Enrico Schenone @ 2025-01-15 17:10 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; [email protected]; +Cc: Massimo Catti <[email protected]>; Livio Pizzolo <[email protected]> Il 15/01/25 17:03, Adrian Klaver ha scritto: > On 1/14/25 23:46, Enrico Schenone wrote: > >>> Which environment did you run the recent prolonged test against? >> The first one: Distinct application server and DB server on distinct >> subnets. >>> > > Is that the same as where you saw the errors? Yes. > >> *Enrico Schenone* >> Software Architect > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-01-15 17:10 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-01-14 17:56 Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Adrian Klaver <[email protected]> 2025-01-15 07:46 ` Enrico Schenone <[email protected]> 2025-01-15 16:03 ` Adrian Klaver <[email protected]> 2025-01-15 17:10 ` Enrico Schenone <[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