Hello Laurenz
How is this possible?
Because I know pg_xact cannot be cleaned while a transaction is still
active
On Wed, Jan 29, 2025 at 12:40 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> On Tue, 2025-01-28 at 16:46 -0500, tiamoh m wrote:
> > I have been having this bizarre error in most of my postgresql clusters.
> >
> > I don't know if anyone has experienced this or has a solution ?
>
> That happens when you are using LISTEN and NOTIFY, but your transactions
> are so long that by the time the signal is delivered, the information
> about the transaction is already gone.
>
> Use shorter database transactions.
>
> Yours,
> Laurenz Albe
>