Re: LIsten Errror - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: LIsten Errror
Date
Msg-id 1f386f506f89e04420715a25d7f7d46f763de1e4.camel@cybertec.at
Whole thread Raw
In response to LIsten Errror  (tiamoh m <tiamohm25@gmail.com>)
List pgsql-admin
On Wed, 2024-08-14 at 13:00 -0400, tiamoh m wrote:
> We keep having these errors  below in our different clusters.
>
> LISTEN| PGE-58P01: ERROR:  could not access status of transaction 4543382428
>
> When it starts occurring, so far the only way to stop it has been to restart.  
>
> Is there any permanent fix for this issue?

This can happen if you have transactions that are open for a very long time.
Avoid such transactions.

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Keith Fiske
Date:
Subject: Re: Pg partman
Next
From: Laurenz Albe
Date:
Subject: Re: Function problem