From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: marc.morad@gmail.com
Subject: BUG #17937: Corrupt Indexes after reusing DRBD Device on new VM
Date: Wed, 17 May 2023 09:42:26 +0000
Message-ID: <17937-c93266adaef384ff@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17937
Logged by: Marc Morad
Email address: marc.morad@gmail.com
PostgreSQL version: 13.8
Operating system: Alma 8
Description:
This problem occured on PostgreSQL version 13.8 and 14.7.
After we migrated the VM from CentOS 7 to AlmaLinux 8, we had a few issues
with broken/corrupt indexes. This problem occured a total of 3 times. Each
time the procedure of the migration was exactly the same.
We are using a DRBD device to store our database redundantly, which we
reused when we migrated to AlmaLinux 8.
The error messages all looked very similar to the following:
Database error: [S]ERROR#012[V]ERROR#012[C]XX002#012[M]table tid from new
index tuple (3346213,70) cannot find insert offset between offsets 2 and 4
of block 5485 in index
Have you ever heard of a similiar problem ?
Any leads what might cause these problems would be very helpful.
Thank you and kind regards,
Marc
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, marc.morad@gmail.com
Subject: Re: BUG #17937: Corrupt Indexes after reusing DRBD Device on new VM
In-Reply-To: <17937-c93266adaef384ff@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