Re: Could not open file pg_xact/0E97

2020-07-18 Thread Radoslav Nedyalkov
Well. the vacuum full failed with vacuumdb: vacuuming of table "olap.transactions_and_fees_2020_01" in database "db" failed: ERROR: found xmin 3916900817 from before relfrozenxid 80319533 On Sun, Jul 19, 2020 at 12:01 AM Radoslav Nedyalkov wrote: > Hi Forum, > We see > pg_dump: Dumping the con

Could not open file pg_xact/0E97

2020-07-18 Thread Radoslav Nedyalkov
Hi Forum, We see pg_dump: Dumping the contents of table "transactions_and_fees_2020_01" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: could not access status of transaction 3916900817 DETAIL: Could not open file "pg_xact/0E97": No such file or directory. (pg11.8 on cent