Re: Fix logical decoding not track transaction duringSNAPBUILD_BUILDING_SNAPSHOT

From: cca5507 <cca5507(at)qq(dot)com>
To: ocean_li_996 <ocean_li_996(at)163(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix logical decoding not track transaction duringSNAPBUILD_BUILDING_SNAPSHOT
Date: 2025-11-22 10:34:23
Message-ID: tencent_AFF4B0D0A1F63DC5452606EFE740DB4E3705@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Haiyang,

Thank you for your summary.

One important thing is that we must not skip any call to ReorderBufferXidSetCatalogChanges() (direct or indirect) during fast-forwarding or building snapshot, because the historic snapshot only tracks txns with catalog changes, the v6-0004 seems to skip it in xact_decode().

Here is a related bug:

https://www.postgresql.org/message-id/flat/tencent_3A071B760AA1A38540B57F297332B7781C08%40qq.com

--
Regards,
ChangAo Chen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Boris Mironov 2025-11-22 11:02:12 Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)
Previous Message Pavel Stehule 2025-11-22 10:05:53 Re: proposal: plpgsql, new check for extra_errors - strict_expr_check