public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: vignesh C <[email protected]>
Cc: Xuneng Zhou <[email protected]>
Cc: Amit Kapila <[email protected]>
Cc: Dilip Kumar <[email protected]>
Cc: [email protected]
Subject: Re: Add an option to skip loading missing publication to avoid logical replication failure
Date: Fri, 02 May 2025 12:54:01 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CALDaNm2Pmbc-7KM3nRgZcq1EBhbdvWJSTie-st57oGuKP4O44w@mail.gmail.com>
References: <CALDaNm0-n8FGAorM+bTxkzn+AOUyx5=L_XmnvOP6T24+-NcBKg@mail.gmail.com>
<CAA4eK1+gaEyYJpsGZktfXptU4gbLcwbzFTC0TBZc1UY2SBPydw@mail.gmail.com>
<CALDaNm2VTjKe8mQsTXFvrbgzcSO4OiuyOdw4VDBK_Ntn=ay-bQ@mail.gmail.com>
<CAA4eK1+37NhZg+q_UdX6Bfm1ikfoZPZaS0nqPY6xtMNs4BPQnw@mail.gmail.com>
<CALDaNm13A+KyNu47YMyu+tL4XeombTHzZt3fpD1QLxh_Mtw+WQ@mail.gmail.com>
<CALDaNm1Lg1YOtY+Sy2his=ikHsQYYQ1pWN620QiBZDBdbsjMHw@mail.gmail.com>
<CAA4eK1LSOUXoH+gY1OikbHajxpgbZJqs=jfYGDmckuWWXzcLMQ@mail.gmail.com>
<CALDaNm2Xkm1M-ik2RLJZ9rMhW2zW2GRLL6ePyZJbXcAjOVwzXg@mail.gmail.com>
<CALDaNm3Ub=T1c78kDF3y5Wcna3WrzoiEeVL8_atbSFSiVhj8FQ@mail.gmail.com>
<CAA4eK1JF1VQftiLVwt9QbCeR956Xg8fTsfdm4tnhw=J2_jUWRg@mail.gmail.com>
<CALDaNm0T4uP0BTQHAzsmw3EtCoq=-y4Ryww9PZTrqiZeyA80XQ@mail.gmail.com>
<CAFiTN-sAbD1G09bn1EPh4EgEjtqxBdGaSxKYhVCBEQZwgXgdmg@mail.gmail.com>
<CALDaNm3HYP5WJLV9cKWEXuGgWYSLFOs-=u0qf5OD4Zyb87=6gw@mail.gmail.com>
<CAFiTN-tnDOhVdKvDR9z3+z3B+dNQFs10e48OgAdRsC9sJXqs0g@mail.gmail.com>
<CAFiTN-u1g! [email protected]>
<CAA4eK1L-4c2+v7NZB4jWDwtN-VT+UKAm9Vp2dzO2Tyg0HTJvbQ@mail.gmail.com>
<CAFiTN-v56-ad_OdrMCqgjZbAdUop9syt+J9KiHBsX5QJxPUuHA@mail.gmail.com>
<CAA4eK1KQk=m_qiXTXV6jVKQNXps4QiCkaioPw7yKvZbGfzSmhQ@mail.gmail.com>
<[email protected]>
<CAA4eK1Jz20hnPRDtPDo2BbSt0Xf8u2zY4Tc84R0OAQN8M=9iCQ@mail.gmail.com>
<CALDaNm3TH3J8fwj+NcdjdN8DZCdrnmm1kzBsHBW2nkN+h6up3A@mail.gmail.com>
<CABPTF7WjggBzCWy9BBWRen9H-Anq4Y9jsqCg=i=x+W_XFSR6wQ@mail.gmail.com>
<CALDaNm2Pmbc-7KM3nRgZcq1EBhbdvWJSTie-st57oGuKP4O44w@mail.gmail.com>
vignesh C <[email protected]> writes:
> Due to the asynchronous nature of these processes, the ALTER
> SUBSCRIPTION command may not be immediately observed by the apply
> worker. Meanwhile, the walsender may process and decode an INSERT
> statement.
> If the insert targets a table (e.g., tab_3) that does not belong to
> the current publication (pub1), the walsender silently skips
> replicating the record and advances its decoding position. This
> position is sent in a keepalive message to the subscriber, and since
> there are no pending transactions to flush, the apply worker reports
> it as the latest received LSN.
So this theory presumes that the apply worker receives and reacts to
the keepalive message, yet it has not observed a relevant
subscriber-side catalog update that surely committed before the
keepalive was generated. It's fairly hard to see how that is okay,
because it's at least adjacent to something that must be considered a
bug: applying transmitted data without having observed DDL updates to
the target table. Why is the processing of keepalives laxer than the
processing of data messages?
regards, tom lane
view thread (42+ messages) latest in thread
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Add an option to skip loading missing publication to avoid logical replication failure
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox