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)
In-reply-to: 
 <CAK-MWwT1wt=zK+pu52qEZnSieYXvx8St6wwwWtOb81eQh6zH7Q@mail.gmail.com>
References: <17478-c422e68d010b951d@postgresql.org>
 <CAK-MWwT1wt=zK+pu52qEZnSieYXvx8St6wwwWtOb81eQh6zH7Q@mail.gmail.com>
Comments: In-reply-to Maxim Boguk <maxim.boguk@gmail.com>
	message dated "Mon, 09 May 2022 18:24:22 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3816954.1652113943.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 09 May 2022 12:32:23 -0400
Message-ID: <3816955.1652113943@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3816955.1652113943%40sss.pgh.pa.us>
Precedence: bulk

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=E2=80=99re observing a strange bug, according to me. We=E2=80=99ve g=
ot 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 heavil=
y
>> 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 (a=
t
> 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