Date: Fri, 10 Nov 2023 14:08:10 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Tomas Vondra <tomas.vondra@enterprisedb.com>,
	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: <ZU4rOmvyVSVtVoEk@depesz.com>
Reply-To: depesz@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>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ZU4XkdOPCthiyN7L@depesz.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZU4rOmvyVSVtVoEk%40depesz.com>
Precedence: bulk

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