Re: LIsten Errror

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: tiamoh m <tiamohm25(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: LIsten Errror
Date: 2024-08-27 04:17:39
Message-ID: 1f386f506f89e04420715a25d7f7d46f763de1e4.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-08-27 04:37:01 Re: Function problem
Previous Message Keith Fiske 2024-08-26 19:47:31 Re: Pg partman