From: hubert depesz lubaczewski <depesz@depesz.com>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Amit Kapila <amit.kapila16@gmail.com>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: kuroda.hayato@fujitsu.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: Logical replication is missing block of rows when sending initial sync?
Date: Fri, 10 Nov 2023 14:08:10 +0100
Message-ID: <ZU4rOmvyVSVtVoEk@depesz.com> (raw)
In-Reply-To: <ZU4XkdOPCthiyN7L@depesz.com>
References: <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>
<ZUTmEi8mEoDl93Vm@depesz.com>
<ZUt9FOueePOl2ZUp@depesz.com>
<ZUuU2uKd4fW+8Ctp@depesz.com>
<2a638962-7a62-abd6-d9a4-3c322ec2a06d@enterprisedb.com>
<ZU4XkdOPCthiyN7L@depesz.com>
On Fri, Nov 10, 2023 at 12:44:17PM +0100, hubert depesz lubaczewski wrote:
> > I think it'd be interesting to look at the WAL using pg_waldump, and see
> > how it relates to the LSN used for the tablesync slot.
>
> well, I can try to dump, and show data, but it will most likely be
> a lot. Are you more interested in looking into wal around the second
> where data was inserted, or when table was added to publication?
I tried to find it based on relfilenode of assignments table, and ctid,
but I can't find it in waldump :(
I'm probably doing something wrong, or basing on wrong assumptions, but
I got 33GB of wal, dumped it all, found relfilenode (41441) and grepped
for this, and block number (ctid │ (24192,1), so i assumed block
24191, 24192, or 24193 - nothing like this exists in wal dump.
Best regards,
depesz
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: <ZU4rOmvyVSVtVoEk@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