pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: kuroda.hayato@fujitsu.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Logical replication is missing block of rows when sending initial sync?
Date: Fri, 3 Nov 2023 13:22:42 +0100
Message-ID: <ZUTmEi8mEoDl93Vm@depesz.com> (raw)
In-Reply-To: <a266b461-e340-10c6-d511-40f9edb37d28@enterprisedb.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>

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






view thread (19+ messages)  latest in thread

Message-ID: <ZUTmEi8mEoDl93Vm@depesz.com>
Permalink:  ../ZUTmEi8mEoDl93Vm@depesz.com/
Also on:    postgresql.org/message-id/ZUTmEi8mEoDl93Vm@depesz.com

 · 

reply
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: depesz@depesz.com, tomas.vondra@enterprisedb.com, amit.kapila16@gmail.com, 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?
  In-Reply-To: <ZUTmEi8mEoDl93Vm@depesz.com>

* 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