Postgres Pro
Downloads
Home   >   mailing lists

Re: PID=2299350| 19| LISTEN| PGE-58P01:ERROR:  could not access status of transaction 432906091 - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: PID=2299350| 19| LISTEN| PGE-58P01:ERROR:  could not access status of transaction 432906091
Date
Msg-id 9397b80e7a5258eaf4e68f3b93a7a921f7ca194c.camel@cybertec.at
Whole thread Raw
In response to PID=2299350| 19| LISTEN| PGE-58P01:ERROR:  could not access status of transaction 432906091  (tiamoh m <tiamohm25@gmail.com>)
List pgsql-admin
Tree view 
On Wed, 2025-01-29 at 13:42 -0500, tiamoh m wrote:
> How is this possible? 
> Because I know pg_xact cannot be cleaned while a transaction is still active

Perhaps this thread can explain it:

https://www.postgresql.org/message-id/flat/VE1PR03MB531295B1BDCFE422441B15FD92499%40VE1PR03MB5312.eurprd03.prod.outlook.com#7e36d1fdca921b5292e92c7017984ffa

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: tiamoh m
Date:
Subject: Re: PID=2299350| 19| LISTEN| PGE-58P01:ERROR:  could not access status of transaction 432906091
Next
From: srinivasan s
Date:
Subject: Partition management - best practices and avoid long access exclusive lock during partition creation