Skipping logical replication transactions on subscriber side

Edit
ID 3205
Title Skipping logical replication transactions on subscriber side
Topic Replication & Recovery
Created 2021-06-28 04:43:40
Last modified 2022-03-29 05:10:06 (2 years, 8 months ago)
Latest email 2022-04-07 11:39:58 (2 years, 8 months ago)
Status
2022-03: Committed
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
Target version
Authors Masahiko Sawada (masahikosawada)
Reviewers Hou Zhijie (houzj), Mark Dilger (mark.dilger), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234)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/3205
git checkout commitfest/cf/3205
Emails
Skipping logical replication transactions on subscriber side
First at 2021-05-24 08:01:34 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest at 2022-04-07 11:39:58 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest attachment (make_subskiplsn_aligned_v4.patch) at 2022-04-06 03:54:42 from Masahiko Sawada <sawada.mshk at gmail.com>
    Attachment (make_subskiplsn_aligned_v4.patch) at 2022-04-06 03:54:42 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (make_subskiplsn_aligned_v3.patch) at 2022-04-05 07:41:28 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (make_subskiplsn_aligned_v2.patch) at 2022-04-05 06:05:10 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (make_subskiplsn_aligned.patch) at 2022-04-04 01:28:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (log-subscription-20220401c.tar.xz) at 2022-04-02 08:13:46 from Noah Misch <noah at leadboat.com> (Patch: No)
    Attachment (add_logs_v2.patch) at 2022-04-02 07:33:44 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (log-subscription-20220401b.tar.xz) at 2022-04-02 01:59:43 from Noah Misch <noah at leadboat.com> (Patch: No)
    Attachment (datum_to_lsn_skiplsn_1.patch) at 2022-04-02 01:19:20 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (log-subscription-20220401.tar.xz) at 2022-04-02 00:11:53 from Noah Misch <noah at leadboat.com> (Patch: No)
    Attachment (add_logs.patch) at 2022-04-01 12:25:52 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-ALTER-SUBSCRIPTION-.-SKIP.patch) at 2022-03-21 03:25:51 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-ALTER-SUBSCRIPTION-.-SKIP.patch) at 2022-03-17 06:03:42 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transa.patch) at 2022-03-16 08:22:35 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transa.patch) at 2022-03-15 06:13:17 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (backtrace.txt) at 2022-03-14 09:50:41 from "shiy.fnst at fujitsu.com" <shiy.fnst at fujitsu.com> (Patch: No)
    Attachment (v13-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transa.patch) at 2022-03-11 08:19:41 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v12-0003-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transa.patch) at 2022-03-01 15:00:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Report-error-transaction-s-commit-LSN-instead-of.patch) at 2022-02-11 02:09:38 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transa.patch) at 2022-01-21 11:55:22 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-21 03:08:28 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-fixup-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-tran.patch) at 2022-01-20 16:18:51 from Peter Eisentraut <peter.eisentraut at enterprisedb.com> (Patch: Yes)
    Attachment (v8-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-18 06:05:10 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-18 04:39:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-17 06:18:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-17 04:18:49 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-14 02:19:10 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-12 06:02:19 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (doc_update.patch) at 2022-01-11 03:22:08 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transac.patch) at 2022-01-07 05:52:52 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Add-ALTER-SUBSCRIPTION-.-SKIP-to-skip-the-transactio.patch) at 2021-12-10 05:44:16 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-regression-test-failure-caused-by-commit-8d74.patch) at 2021-12-01 05:23:29 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-regression-test-failure-caused-by-commit-8d74fc9.patch) at 2021-11-30 13:38:40 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Add-a-view-to-show-the-stats-of-subscription-wor.patch) at 2021-11-29 03:43:34 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Add-a-view-to-show-the-stats-of-subscription-wor.patch) at 2021-11-27 10:56:40 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-26 00:29:39 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-25 12:29:12 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-24 11:43:35 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-16 06:31:18 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-15 09:17:34 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-15 02:48:34 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-11-07 14:19:48 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Add-a-subscription-worker-statistics-view-pg_sta.patch) at 2021-10-29 05:24:11 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v18-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-10-21 04:59:17 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v17-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-10-18 01:34:22 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v16-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-10-12 04:59:23 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v15-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-09-30 05:45:20 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Add-RESET-command-to-ALTER-SUBSCRIPTION-command.patch) at 2021-09-21 04:53:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v13-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-09-09 14:32:54 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Adding-tests-of-subscription-errors.patch) at 2021-09-02 19:33:52 from Mark Dilger <mark.dilger at enterprisedb.com> (Patch: Yes)
    Attachment (0001-diff-for-0002_patch) at 2021-09-02 11:37:04 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v12-0001-Add-pg_stat_subscription_errors-statistics-view.patch) at 2021-08-30 07:06:55 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-logical-change-details-to-logical-replicatio.patch) at 2021-08-26 12:10:55 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-logical-change-details-to-logical-replicatio.patch) at 2021-08-25 04:22:11 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v10-0005-Move-shared-fileset-cleanup-to-before_shmem_exit.patch) at 2021-08-23 03:09:21 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v9-0005-Move-shared-fileset-cleanup-to-before_shmem_exit.patch) at 2021-08-19 01:47:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Rename-LOGICAL_REP_MSG_STREAM_END-to-LOGICAL_REP_MSG.patch) at 2021-08-18 04:29:54 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v8-0005-Move-shared-fileset-cleanup-to-before_shmem_exit.patch) at 2021-08-12 05:53:15 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v7-0004-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-08-11 05:48:48 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v6-0003-Add-RESET-command-to-ALTER-SUBSCRIPTION-command.patch) at 2021-08-10 05:07:00 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v5-0004-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-08-03 06:49:23 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v4-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-07-29 05:47:35 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v4-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-07-29 05:04:50 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Remove-unused-function-argument-in-apply_handle_comm.patch) at 2021-07-26 02:58:42 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v2-0003-Add-skip_xid-option-to-ALTER-SUBSCRIPTION.patch) at 2021-07-19 06:39:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Add-pg_stat_logical_replication_error-statistics-.patch) at 2021-06-28 04:42:05 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
History
When Who What
2022-03-29 05:10:06 Amit Kapila (amitkapila) Closed in commitfest 2022-03 with status: Committed
2022-03-29 05:10:06 Amit Kapila (amitkapila) Changed committer to amitkapila
2022-02-02 16:37:59 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-03 07:41:38 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-12-02 02:25:20 Greg Nancarrow (gregn1234) Added gregn1234 as reviewer
2021-11-08 13:11:56 vigneshwaran C (vignesh.postgres) Added vignesh.postgres as reviewer
2021-10-04 16:33:03 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-09-02 20:45:54 Mark Dilger (mark.dilger) Added mark.dilger as reviewer
2021-08-03 02:29:44 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-19 11:41:18 Hou Zhijie (houzj) Added houzj as reviewer
2021-06-28 04:43:48 Masahiko Sawada (masahikosawada) Changed authors to Masahiko Sawada (masahikosawada)
2021-06-28 04:43:40 Masahiko Sawada (masahikosawada) Attached mail thread CAD21AoDeScrsHhLyEPYqN3sydg6PxAPVBboK=30xJfUVihNZDA@mail.gmail.com
2021-06-28 04:43:40 Masahiko Sawada (masahikosawada) Created patch record
Edit