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

From vignesh C
Subject Re: [HACKERS] logical decoding of two-phase transactions
Date
Msg-id CALDaNm0ymZ9_KV4N35=nqti6CkrMFCxCc9cyS_CmmjD0=vmrLg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] logical decoding of two-phase transactions  (Peter Smith <smithpb2250@gmail.com>)
List pgsql-hackers
On Tue, Mar 30, 2021 at 5:34 AM Peter Smith <smithpb2250@gmail.com> wrote:
>
> Please find attached the latest patch set v68*
>
> Differences from v67* are:
>
> * Rebased to HEAD @ today.
>
> * v68 fixes an issue reported by Vignesh [1] where a scenario was
> found which still was able to cause a generated GID clash. Using
> Vignesh's test script I could reproduce the problem exactly as
> described. The fix makes the GID unique by including the subid. Now
> the same script runs to normal completion and produces good/expected
> output:
>
>  transaction |       gid        |           prepared            |
> owner   | database
> -------------+------------------+-------------------------------+----------+----------
>          547 | pg_gid_16389_543 | 2021-03-30 10:32:36.87207+11  |
> postgres | postgres
>          555 | pg_gid_16390_543 | 2021-03-30 10:32:48.087771+11 |
> postgres | postgres
> (2 rows)
>

Thanks for the patch with the fix, the fix solves the issue reported.

Regards,
Vignesh



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: making update/delete of inheritance trees scale better
Next
From: Andres Freund
Date:
Subject: Re: Replication slot stats misgivings