Re: [HACKERS] logical decoding of two-phase transactions - Mailing list pgsql-hackers

From Peter Smith
Subject Re: [HACKERS] logical decoding of two-phase transactions
Date
Msg-id CAHut+PuBGcb_75oUP+zPvD0NGLFnn1GHfU0UVhZ1NBoqfzkedw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] logical decoding of two-phase transactions  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Wed, Nov 18, 2020 at 7:37 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Wed, Nov 18, 2020 at 1:18 PM Peter Smith <smithpb2250@gmail.com> wrote:
> >
> > Hi.
> >
> > Using a tablesync debugging technique as described in another mail
> > thread [1][2] I have caused the tablesync worker to handle (e.g.
> > apply_dispatch) a 2PC PREPARE
> >
> > This exposes a problem with the current 2PC logic because if/when the
> > PREPARE is processed by the tablesync worker then the txn will end up
> > being COMMITTED, even though the 2PC PREPARE has not yet been COMMIT
> > PREPARED by the publisher.
> >
>
> IIUC, this is the problem with the patch being discussed here, right?
> Because before this we won't decode at Prepare time.

Correct. This is new.

Kind Regards,
Peter Smith.
Fujitsu Australia.



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: ResourceOwner refactoring
Next
From: Michael Paquier
Date:
Subject: Re: Move OpenSSL random under USE_OPENSSL_RANDOM