Allow altering two_phase parameter of subscriptions

Edit
ID 4867
Title Allow altering two_phase parameter of subscriptions
Topic Replication & Recovery
Created 2024-02-29 17:38:37
Last modified 2024-07-25 03:06:09 (3 months, 3 weeks ago)
Latest email 2024-07-30 10:58:17 (3 months, 3 weeks ago)
Status
2024-07: Committed
2024-03: Moved to next CF
Target version 18
Authors Hayato Kuroda (ha-kun), Ajin Cherian (ajinc)
Reviewers Peter Smith (smithpb)Become reviewer
Committer Amit Kapila (amitkapila)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4867
git checkout commitfest/cf/4867
Emails
Slow catchup of 2PC (twophase) transactions on replica in LR
First at 2024-02-22 13:29:43 by Давыдов Виталий <v.davydov at postgrespro.ru>
Latest at 2024-07-30 10:58:17 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (0001-Fix-random-failure-in-021_twophase.patch) at 2024-07-30 10:32:06 from vignesh C <vignesh21 at gmail.com>
    Attachment (0001-Fix-random-failure-in-021_twophase.patch) at 2024-07-30 10:32:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-23 11:25:07 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (PS_20240722_NITPICKS_2PC.txt) at 2024-07-22 09:17:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Allow-altering-of-two_phase-option-for-a-SUBSCRI.patch) at 2024-07-22 06:57:26 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_2PC_v21.txt) at 2024-07-19 02:36:04 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-18 11:42:46 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-18 02:10:47 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240718_2PC_V190003.txt) at 2024-07-18 00:09:05 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240718_2PC_V190002.txt) at 2024-07-17 23:24:29 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240717_v190001.txt) at 2024-07-17 07:53:28 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-17 05:13:35 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240717_2PC_V180003.txt) at 2024-07-17 04:28:20 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240717_2PC_V180002.txt) at 2024-07-17 03:31:14 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (PS_NITPICKS_20240716_2PC_v180001.txt) at 2024-07-16 10:02:21 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-16 05:17:06 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0001-fix-alter-replication-slot.patch.txt) at 2024-07-13 10:48:55 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v17-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-09 12:52:55 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v17-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-09 11:49:38 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v16-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-08 07:04:40 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v15-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-05 05:39:05 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v14-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-07-04 08:04:47 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v13-0004-Add-force_alter-option-for-ALTER-SUBSCRIPTION-.-.patch) at 2024-06-25 08:06:10 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v12-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-05-17 03:06:34 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v11-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-05-16 05:02:55 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v10-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIP.patch) at 2024-05-14 12:03:49 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v9-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-05-13 12:25:26 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v8-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-05-09 09:15:59 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v7-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-05-08 08:26:42 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v6-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-04-23 12:15:32 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (REL_16_0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPTION.patch) at 2024-04-22 12:54:10 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v5-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-04-22 08:56:42 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v4-0002-Alter-slot-option-two_phase-only-when-altering-tr.patch) at 2024-04-18 06:26:22 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (alter_subscription_patches.zip) at 2024-04-16 02:18:29 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v3-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-04-15 07:57:49 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPT.patch) at 2024-04-05 11:29:29 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-altering-of-two_phase-option-in-subscribers.patch) at 2024-04-04 05:23:15 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Async-commit-support-for-twophase-transactions.patch) at 2024-02-29 17:34:42 from Давыдов Виталий <v.davydov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Add-asynchronous-commit-support-for-2PC.patch) at 2024-02-27 11:19:41 from Давыдов Виталий <v.davydov at postgrespro.ru> (Patch: Yes)
History
When Who What
2024-07-25 03:06:10 Amit Kapila (amitkapila) Closed in commitfest 2024-07 with status: Committed
2024-07-25 03:05:45 Amit Kapila (amitkapila) Changed committer to amitkapila
2024-06-25 06:30:45 Hayato Kuroda (ha-kun) Changed reviewers to Peter Smith (smithpb)
2024-06-25 06:30:45 Hayato Kuroda (ha-kun) Changed authors to Hayato Kuroda (ha-kun), Ajin Cherian (ajinc)
2024-06-25 06:30:45 Hayato Kuroda (ha-kun) Changed targetversion to 18
2024-06-25 06:30:45 Hayato Kuroda (ha-kun) Changed topic to Replication & Recovery
2024-06-25 06:30:45 Hayato Kuroda (ha-kun) Changed name to Allow altering two_phase parameter of subscriptions
2024-04-09 06:35:43 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-29 17:38:37 Vitaly Davydov (vitprof) Attached mail thread 8fab8-65d74c80-1-2f28e880@39088166
2024-02-29 17:38:37 Vitaly Davydov (vitprof) Created patch record
Edit