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

Hi

On Saturday, March 13, 2021 5:01 PM osumi(dot)takamichi(at)fujitsu(dot)com <osumi(dot)takamichi(at)fujitsu(dot)com> wrote:
> On Friday, March 12, 2021 5:40 PM Peter Smith <smithpb2250(at)gmail(dot)com>
> > Please find attached the latest patch set v58*
> Thank you for updating those. I'm testing the patchset and I think it's
> preferable that you add simple two types of more tests in 020_twophase.pl
> because those aren't checked by v58.
>
> (1) execute single PREPARE TRANSACTION
> which affects several tables (connected to corresponding
> publications)
> at the same time and confirm they are synced correctly.
>
> (2) execute single PREPARE TRANSACTION which affects multiple
> subscribers
> and confirm they are synced correctly.
> This doesn't mean cascading standbys like
> 022_twophase_cascade.pl.
> Imagine that there is one publisher and two subscribers to it.
Attached a patch for those two tests. The patch works with v62.
I tested this in a loop more than 100 times and showed no failure.

Best Regards,
Takamichi Osumi