From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: rootcause000@gmail.com
Subject: BUG #18088: Table Corruption Issues Arising from Abrupt Server Shutdown During PostgreSQL 10.20 to 14.7 Migratio
Date: Tue, 05 Sep 2023 13:21:36 +0000
Message-ID: <18088-c0b663f3c5efb6e3@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18088
Logged by: Root Cause
Email address: rootcause000@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system: Microsoft Windows Server 2019 Standard
Description:
During the PostgreSQL migration from version 10.21 to 14.7, we encountered
an issue caused by corruption in a specific table. Upon checking the logs,
we noticed numerous instances of the server abruptly shutting down. After
each server restart, when attempting to access the table, we encountered the
following exceptions:
"unrecognized win32 error code: 1392
could not read block 2395 in file ""base/16509/3818424"": Invalid
argument"
On checking the 'relkind' for 'relfilenode,' the type appeared to be an
ordinary table. We were able to regain access to the table by truncating
it.
ProdDB=> select count(*) from prrhtab;
ERROR: could not read block 2394 in file "base/16509/3818424": read only 0
of 8192 bytes
ProdDB=> SELECT relname, relkind FROM pg_Class WHERE relfilenode=3818424;
relname | relkind
-----------------------+---------
prrhtab | r
(1 row)
ProdDB=> truncate table prrhtab;
TRUNCATE TABLE
ProdDB=> select count(*) from prrhtab;
count
-------
0
(1 row)
ProdDB=>
However, since there is no available backup, we are uncertain about the
presence of any data and whether any other recovery options are possible.
Please advise if there are alternative methods to recover the data and if
there are options to prevent this issue from occurring even in the event of
an abrupt server shutdown.
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, rootcause000@gmail.com
Subject: Re: BUG #18088: Table Corruption Issues Arising from Abrupt Server Shutdown During PostgreSQL 10.20 to 14.7 Migratio
In-Reply-To: <18088-c0b663f3c5efb6e3@postgresql.org>
* 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