From: Tom Lane <tgl@sss.pgh.pa.us>
To: Maxim Boguk <maxim.boguk@gmail.com>
Cc: spastrilov@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table)
Date: Mon, 09 May 2022 12:32:23 -0400
Message-ID: <3816955.1652113943@sss.pgh.pa.us> (raw)
In-Reply-To: <CAK-MWwT1wt=zK+pu52qEZnSieYXvx8St6wwwWtOb81eQh6zH7Q@mail.gmail.com>
References: <17478-c422e68d010b951d@postgresql.org>
<CAK-MWwT1wt=zK+pu52qEZnSieYXvx8St6wwwWtOb81eQh6zH7Q@mail.gmail.com>
Maxim Boguk <maxim.boguk@gmail.com> writes:
> On Mon, May 9, 2022 at 5:58 PM PG Bug reporting form <noreply@postgresql.org>
> wrote:
>> We’re observing a strange bug, according to me. We’ve got native logical
>> replication where the master host is running on PostgreSQL 13.3 and the
>> logical replica host is running on PostgreSQL 14.1. And the problem is:
>> when we start to reindex concurrently the primary key of an 800M heavily
>> inserted/updated(on the master)table on the logical replica database,
>> several documents that have been inserted and existing in the master
>> database during the index rebuild on the replica, are missing from the
>> index
>> structure on the replica host.
> Please try to upgrade your slave to 14.2 where this problem was fixed (at
> least it fixed the same issue for me).
13.6 might do as well, and would be a lot closer to a drop-in upgrade.
The 13.5 and 13.6 release notes both mention problems with REINDEX
CONCURRENTLY. Given the existence of those fixed bugs, nobody is
likely to look too closely at this report unless you can still reproduce
it on a current minor release.
regards, tom lane
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: tgl@sss.pgh.pa.us, maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17478: Missing documents in the index after CREATE INDEX CONCURRENTLY (but existing in the table)
In-Reply-To: <3816955.1652113943@sss.pgh.pa.us>
* 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