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

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Peter Smith <smithpb2250(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] logical decoding of two-phase transactions
Date: 2020-11-18 08:38:21
Message-ID: CAA4eK1L9OAu8qAAuQrYfoULd0t_WHMjwakb8sGdBRbwJ3MqUYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2020-11-18 08:50:08 Re: ResourceOwner refactoring
Previous Message Heikki Linnakangas 2020-11-18 08:32:03 Re: [patch] [doc] Clarify that signal functions have no feedback