Re: repeated decoding of prepared transactions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: repeated decoding of prepared transactions
Date
Msg-id CA+Tgmoax+qiNmicwg1ZK_sRM3+RPUvHRS8PJ3TaeR++J-Chn9g@mail.gmail.com
Whole thread Raw
In response to Re: repeated decoding of prepared transactions  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: repeated decoding of prepared transactions
List pgsql-hackers
On Thu, Feb 11, 2021 at 5:37 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> to explain the exact case to you which is not very apparent. The basic
> idea is that we ship/replay all transactions where commit happens
> after the snapshot has a consistent state (SNAPBUILD_CONSISTENT), see
> atop snapbuild.c for details. Now, for transactions where prepare is
> before snapshot state SNAPBUILD_CONSISTENT and commit prepared is
> after SNAPBUILD_CONSISTENT, we need to send the entire transaction
> including prepare at the commit time.

This might be a dumb question, but: why?

Is this because the effects of the prepared transaction might
otherwise be included neither in the initial synchronization of the
data nor in any subsequently decoded transaction, thus leaving the
replica out of sync?

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Darafei "Komяpa" Praliaskouski
Date:
Subject: Re: Tightening up allowed custom GUC names
Next
From: Robert Haas
Date:
Subject: Re: Tightening up allowed custom GUC names