| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, kuroda(dot)hayato(at)fujitsu(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Logical replication is missing block of rows when sending initial sync? |
| Date: | 2023-11-10 13:08:10 |
| Message-ID: | ZU4rOmvyVSVtVoEk@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-11-10 15:10:25 | Re: BUG #18188: wrong varnullingrels |
| Previous Message | hubert depesz lubaczewski | 2023-11-10 11:44:17 | Re: Logical replication is missing block of rows when sending initial sync? |