Skipping logical replication transactions on subscriber side

Log in to edit
ID 3205
Title Skipping logical replication transactions on subscriber side
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags
Created 2021-06-28 04:43:40
Last modified 2022-03-29 05:10:06 (4 years ago)
Latest email 2022-04-07 11:39:58 (4 years ago)
Status
2022-03 (2022-03-01 – 2022-03-31): Committed
2022-01 (2022-01-01 – 2022-01-31): Moved to different CF
2021-11 (2021-11-01 – 2021-11-30): Moved to different CF
2021-09 (2021-09-01 – 2021-09-30): Moved to different CF
2021-07 (2021-07-01 – 2021-07-31): Moved to different CF
Target version
Authors Masahiko Sawada (masahikosawada)
Reviewers vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Mark Dilger (mark.dilger), Zhijie Hou (houzj) Log in to become reviewer
Committer Amit Kapila (amitkapila)
Links
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 Zhijie Hou (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
Log in to edit