Re: [HACKERS] logical decoding of two-phase transactions

On Wed, Nov 18, 2020 at 7:37 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Wed, Nov 18, 2020 at 1:18 PM Peter Smith <smithpb2250(at)gmail(dot)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.