ERROR: could not access status of transaction

[andreyryzhkov]

Hi,

OS: Ubuntu
DB: Postgres 14

I try to run pg_timetable and get following errors:

2022-08-02 16:03:20.515 UTC [1203144] timetable_user@postgres ERROR: could not access status of transaction 3862727920
2022-08-02 16:03:20.515 UTC [1203144] timetable_user@postgres DETAIL: Could not open file "pg_xact/0E63": No such file or directory.
2022-08-02 16:03:20.515 UTC [1203144] timetable_user@postgres STATEMENT: LISTEN "worker1"
2022-08-02 16:03:40.551 UTC [1203155] timetable_user@postgres ERROR: could not access status of transaction 3862727920
2022-08-02 16:03:40.551 UTC [1203155] timetable_user@postgres DETAIL: Could not open file "pg_xact/0E63": No such file or directory.
2022-08-02 16:03:40.551 UTC [1203155] timetable_user@postgres STATEMENT: LISTEN "worker1"
2022-08-02 16:04:20.586 UTC [1203177] timetable_user@postgres ERROR: could not access status of transaction 3862727920
2022-08-02 16:04:20.586 UTC [1203177] timetable_user@postgres DETAIL: Could not open file "pg_xact/0E63": No such file or directory.

After reboot DB I can run pg_timetable succesfully.
Q: How can I fix this error WITHOUT reboot database? thanks

[pashagolub]

Hello,

This sounds like a database server problem, not a pg_timetable one. I would suggest you immediately inspect the database for data corruption.

Best regards