Could not open file pg_xact/0E97

From: Radoslav Nedyalkov <rnedyalkov(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Could not open file pg_xact/0E97
Date: 2020-07-18 21:01:14
Message-ID: CANhtRiaEMdAWwCnA0wztkPF5cwd1Rf-KswLTYDYcJe=hRfEj-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 centos 7.8, aws ec2 instance)

This pops up upon select from the table on the standby server.
However on the master server, we can dump the table without problem.

What is interesting, when listing the pg_xact folder, according to the
filename , it is from already recycled files. I.e. it is older than the
oldest file there.

For resolving the error , we created commit file on the standby like
dd if=/dev/zero of=0E97 bs=256k count=1
and the full dump of the database went successfully.

Perhaps this is not quite the correct approach, so we're gonna to run
vacuum full on the master
to recreate the table.

Has anyone encountered this issue? Any advice?
Thank you

Rado

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Radoslav Nedyalkov 2020-07-18 21:18:00 Re: Could not open file pg_xact/0E97
Previous Message Tom Lane 2020-07-18 04:57:30 Re: Errors after cloning OS to new disk under Hyper-V