From: Orishich Aleksey <a.orishich@cft.ru>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes
Date: Wed, 14 Jul 2021 03:02:37 +0000
Message-ID: <909f68c697ab4d45a10ea6fc5957d1a5@cft.ru> (raw)
Hello.
While the postgres database was running, we encountered the following error:
ERROR: could not access status of transaction 793754117 Detail: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes.
The pg_act/02 F 4 file on the main database had a different size from other files. At the same time, the pg_xact/02F4 file on the backup database had a standard size of 256Kb. There are no errors writing to the file system. No errors were found in the postgres logs either.
After this error occurred, working with the main database was impossible, and we had to switch to the backup database.
What could have caused this error in postgres? Was it possible to restore the database without switching to a backup? How can I prevent such errors from occurring in the future? How to correctly troubleshooting the cause of this error?
Postgres version: 12.1-2
OS: Oracle Linux Server release 7.6
With Regards,
Aleksey.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: a.orishich@cft.ru, pgsql-bugs@lists.postgresql.org
Subject: Re: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes
In-Reply-To: <909f68c697ab4d45a10ea6fc5957d1a5@cft.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox