"unexpected duplicate for tablespace" problem in logical replication

4720

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 1, First patch: +58−20, All patches: +58−20

Tags

Bugfix

Created

2023-12-24 01:33:18

Last modified

2025-08-22 00:15:28 (1 year ago)

Latest email

2025-09-18 15:30:34 (1 year 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) Log in to 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