"unexpected duplicate for tablespace" problem in logical replication

Edit
ID 4720
Title "unexpected duplicate for tablespace" problem in logical replication
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +58−20, All patches: +58−20
Topic Bug Fixes
Tags
Created 2023-12-24 01:33:18
Last modified 2025-08-22 00:15:28 (2 months ago)
Latest email 2025-09-18 15:30:34 (1 month ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Committed
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
Target version stable
Authors Shenhao Wang (wangshenhao)
Reviewers Masahiko Sawada (masahikosawada)Become reviewer
Committer Michael Paquier (michael-kun)
Links
Emails
"unexpected duplicate for tablespace" problem in logical replication
First at 2022-04-06 02:14:26 by "wangsh.fnst at fujitsu.com" <wangsh.fnst at fujitsu.com>
Latest at 2025-09-18 15:30:34 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (0001-Negative-RelfilenumberMap-cache-entries-fro-20250918.patch) at 2025-09-18 12:07:10 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
    Attachment (0001-Negative-RelfilenumberMap-cache-entries-fro-20250918.patch) at 2025-09-18 12:07:10 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Avoid-bloating-RelfilenumberMap-cache-by-ne-20250813.patch) at 2025-08-13 09:48:31 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Ignore-temporary-relations-in-RelidByRelfil-20250619.patch) at 2025-06-19 08:47:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v3_RelidByRelfilenumber_prefer_perm_rels_master.patch) at 2025-03-25 10:01:01 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v2_RelidByRelfilenumber_prefer_perm_rels_master.patch) at 2024-01-16 01:58:04 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (RelidByRelfilenumber_prefer_perm_rels_master.patch) at 2024-01-12 08:37:46 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (generate_same_relfilenode.txt) at 2022-04-12 02:45:39 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Check-the-duplicated-relfilenode-when-create-tabl.patch) at 2022-04-11 10:24:26 from "wangsh.fnst at fujitsu.com" <wangsh.fnst at fujitsu.com> (Patch: Yes)
    Attachment (run.sh) at 2022-04-06 02:14:26 from "wangsh.fnst at fujitsu.com" <wangsh.fnst at fujitsu.com> (Patch: No)
History
When Who What
2025-08-22 00:15:28 Michael Paquier (michael-kun) Closed in commitfest PG19-1 with status: Committed
2025-08-22 00:15:28 Michael Paquier (michael-kun) Changed committer to michael-kun
2025-06-19 08:11:24 Ashutosh Bapat (ashutoshbapat) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-25 10:01:19 vigneshwaran C (vignesh.postgres) New status: Needs review
2025-02-12 16:03:51 Álvaro Herrera (alvherre) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-10 06:42:45 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 04:24:38 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 06:08:12 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-08 08:21:04 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 18:24:27 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-08 05:01:54 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2023-12-24 01:33:38 Michael Paquier (michael-kun) Changed reviewers to Masahiko Sawada (masahikosawada)
2023-12-24 01:33:38 Michael Paquier (michael-kun) Changed authors to Shenhao Wang (wangshenhao)
2023-12-24 01:33:38 Michael Paquier (michael-kun) Changed targetversion to stable
2023-12-24 01:33:18 Michael Paquier (michael-kun) Attached mail thread bbaaf9f9-ebb2-645f-54bb-34d6efc7ac42@fujitsu.com
2023-12-24 01:33:18 Michael Paquier (michael-kun) Created patch record
Edit