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.albe@xxxxxxxxxxx> 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
