Horton

Re: clog segment truncation

Matheus Alcantara <matheusssilv97@gmail.com>

View thread
From: "Matheus Alcantara" <matheusssilv97@gmail.com>
To: "Smolkin Grigory" <smallkeen@gmail.com>, <pgsql-bugs@lists.postgresql.org>
Date: 2025-11-10T13:05:26Z
Lists: pgsql-bugs 
On Mon Nov 10, 2025 at 9:29 AM -03, Smolkin Grigory wrote:
> Hello, hackers!
>
> I`m currently investigating the case of one of our PostgreSQL instance
> having started issuing error messages about missing clog segment:
> ERROR:  could not access status of transaction 1550558894
> DETAIL:  Could not open file "pg_xact/05C6": No such file or directory.
>
Is this error happening with the LISTEN/NOTIFY? There is a discussion
going on [1] that aims to fix this issue for the LISTEN/NOTIFY.

[1] https://www.postgresql.org/message-id/CAK98qZ3wZLE-RZJN_Y%2BTFjiTRPPFPBwNBpBi5K5CU8hUHkzDpw%40mail.gmail.com

-- 
Matheus Alcantara
EDB: http://www.enterprisedb.com