Date: Fri, 3 Nov 2023 13:22:42 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>,
	Kyotaro Horiguchi <horikyota.ntt@gmail.com>,
	kuroda.hayato@fujitsu.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Logical replication is missing block of rows when sending
 initial sync?
Message-ID: <ZUTmEi8mEoDl93Vm@depesz.com>
Reply-To: depesz@depesz.com
References: <ZTu8GTDajCkZVjMs@depesz.com>
 <TYAPR01MB5866C2BE11AD4FBDC0AB46F0F5A1A@TYAPR01MB5866.jpnprd01.prod.outlook.com>
 <20231102.101713.170587046871054404.horikyota.ntt@gmail.com>
 <ZUOGohG9DArmXNvV@depesz.com>
 <CAA4eK1KDMp_hCFZo=KsbRUOn+JX70Te5BJcTKwfRrt2x++aXXA@mail.gmail.com>
 <ZUTh6bnNFHo35/Go@depesz.com>
 <a266b461-e340-10c6-d511-40f9edb37d28@enterprisedb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <a266b461-e340-10c6-d511-40f9edb37d28@enterprisedb.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZUTmEi8mEoDl93Vm%40depesz.com>
Precedence: bulk

On Fri, Nov 03, 2023 at 01:20:22PM +0100, Tomas Vondra wrote:
> I think it'd be interesting to know:
> 
> 1) Commit LSN for the missing rows (for the xmin).
> 
> 2) Are the other changes for these transactions that *got* replicated
> correctly?

How would I know?

> 3) LSNs used for the tablesync slot, catchup etc. I believe those are in
> the server log.

I will provide more logs on the next problem.

Best regards,

depesz