Date: Fri, 17 Nov 2023 17:22:58 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>,
	Amit Kapila <amit.kapila16@gmail.com>,
	Kyotaro Horiguchi <horikyota.ntt@gmail.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: Logical replication is missing block of rows when sending
 initial sync?
Message-ID: <ZVeTYo5_OVqOE9UQ@depesz.com>
Reply-To: depesz@depesz.com
References: 
 <CAA4eK1KDMp_hCFZo=KsbRUOn+JX70Te5BJcTKwfRrt2x++aXXA@mail.gmail.com>
 <ZUTh6bnNFHo35/Go@depesz.com>
 <a266b461-e340-10c6-d511-40f9edb37d28@enterprisedb.com>
 <ZUTmEi8mEoDl93Vm@depesz.com>
 <ZUt9FOueePOl2ZUp@depesz.com>
 <ZUuU2uKd4fW+8Ctp@depesz.com>
 <2a638962-7a62-abd6-d9a4-3c322ec2a06d@enterprisedb.com>
 <ZU4XkdOPCthiyN7L@depesz.com>
 <TYAPR01MB5866C96DDABDB0D7F2850972F5B1A@TYAPR01MB5866.jpnprd01.prod.outlook.com>
 <dd5c48d4-8962-d1c9-e71a-6bda23b86401@enterprisedb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <dd5c48d4-8962-d1c9-e71a-6bda23b86401@enterprisedb.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZVeTYo5_OVqOE9UQ%40depesz.com>
Precedence: bulk

On Fri, Nov 17, 2023 at 03:40:35PM +0100, Tomas Vondra wrote:
> On 11/15/23 02:41, Hayato Kuroda (Fujitsu) wrote:
> > Dear Tomas, Depesz,
> > 
> >>
> >>> I'll try reproducing this locally over the weekend. Should I use the
> >>> test_1030.sh script that you shared a week ago, or do I need to do
> >>> something more?
> >>
> >> That question is probably not to me, but to Hayato Kuroda
> > 
> > Just FYI - As I posted, this script could not reproduce the issue. We may use the same table definition
> > but I have not tried yet. I will let you know if I succeeded to reproduce.
> > 
> 
> FYI I think I've reproduced the issue (with a different script), I've
> started a thread on pgsql-hackers:
> 
> https://www.postgresql.org/message-id/de52b282-1166-1180-45a2-8d8917ca74c6%40enterprisedb.com
> 
> Obviously, I can't be sure it's exactly the same issue, but the symptoms
> seem to match what Depesz reported (gaps in data etc.). I don't know
> what the root cause is, or fix. But there's more info (and scripts) in
> the hackers thread.

Thanks a lot. Much appreciated. It will be over for us with the upgrade
soon, but it's good to know that there might be one less bug in pg
thanks to this :)

Best regards,

depesz