public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Date: Wed, 18 Dec 2024 10:11:54 -0500
Message-ID: <CANzqJaB3yq0dBVeRqP7bN+3uEDM8grWPJ+=f2wYEs7-Mq_36Eg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Wed, Dec 18, 2024 at 5:01 AM Enrico Schenone <[email protected]>
wrote:
> Good day.
> My name is Enrico Schenone, from Genoa, Italy.
> I'm a software achitect working at Cleis Tech - Genoa - Italy -
> http://gruppocleis.it
> Me and my team are using PostgreSQL v12 to v16 on Debian 10-12 and Ubuntu
> Server 22.04 LTS with no-cluster configuration.
> Our applications are developed with 4Js Genero platform (classified as
> LCAP) - https://4js.com
>
> I whish to report an issue where I can't say if it happens at server or
> client side (or both as well).
> The problem occurs occasionally and only when fetching rows from a
> server-side cursor. The related query may be complex with joins or very
> easy (just one static table with 86 rows without WHERE conditions).
> I have set the "debug5" verbosity level of PostgreSQL log and I have
> extracted from millions of log line those who are belonging to separate
> failing sessions/connections.
> At the same time I have extracted the related application log.
> For each failure reported into the client-side application log, I have a
> distinct PostgreSQL detailed log.
>
> Then I have merged client-side end server-side logs along the timeline and
> I have observed what client and server does.
> For example (S: means PostgreSQL Server log, while C: means Client log):
>
Can you replicate the error in Prod using psql and cursors?
See
https://www.postgresql.org/docs/current/plpgsql-cursors.html#PLPGSQL-CURSOR-USING
Section 41.7.3.5.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
In-Reply-To: <CANzqJaB3yq0dBVeRqP7bN+3uEDM8grWPJ+=f2wYEs7-Mq_36Eg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox