Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Enrico Schenone <eschenone(at)cleistech(dot)it>, pgsql-general(at)lists(dot)postgresql(dot)org
Cc: Massimo Catti <mcatti(at)cleistech(dot)it>, Livio Pizzolo <lpizzolo(at)cleistech(dot)it>
Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Date: 2024-12-18 23:11:36
Message-ID: 25d5fb16-9bb2-4ad1-969c-eaca03ccbaaf@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/17/24 08:30, Enrico Schenone 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).

This:

"unexpected EOF on client connection "

makes me believe this is on client side.

To be clear the client is running on Ubuntu Server 22.04, correct?

Have you looked at the OS system log for relevant entries at the time
the error occurs?

If so what are they?

This only happens in production environment, is there anything in it
that is materially different from where you ran the test below?

> Hoping you can help me or address to someone who can do it.
> Thanks in advance.
> Enrico
> --
>
> *Enrico Schenone*
> Software Architect
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Saul Perdomo 2024-12-19 00:00:14 Re: Query about pg_wal directory filled up
Previous Message Adrian Klaver 2024-12-18 21:34:07 Re: Cannot drop column