Re: BUG #18099: ERROR: could not access status of transaction 4007513275

Em 08/09/2023 03:36, PG Bug reporting form escreveu:

> The following bug has been logged on the website:
>
> Bug reference: 18099
> Logged by: Dogukan Yuzen
> Email address: dyuzenn98(at)gmail(dot)com
> PostgreSQL version: 14.8
> Operating system: Red Hat Enterprise Linux Server release 7.9 (Maipo
> Description:
>
> A few days ago , we had some problems in our production database.
> We can't read the table.
>
> We can't solve this problem.
> ERROR: could not access status of transaction 4007513275
> DETAIL: Could not open file "pg_xact/0EED": No such file or directory.
>
> Please, help us.

Try to remove all files stored in pg_twophase directory and than restart
the service. I had similar situation and doing that, solved the problem.

Somethimes, old prepared transactios can cause this problem and removing
the files of pg_twophase should fix.

best regards,

---

Carlos Alves
Especialista

Sia Trecho 08, lotes 245 / 255 / 265 || +55 (61) 3039-9700
71205-080 || Guará || Brasília, DF 0800-6020097

www.tecnisys.com.br [1]

Links:
------
[1] http://www.tecnisys.com.br