Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304"

From: Kouber Saparev <kouber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, wangsh(dot)fnst(at)fujitsu(dot)com, osumi(dot)takamichi(at)fujitsu(dot)com
Subject: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304"
Date: 2023-12-22 08:55:24
Message-ID: CAN4RuQuKGmUD4-OcJeC7t-p=yN7Pvwry_pVCigio-_LdsXpkHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are using logical replication in a quite busy environment. On the
publisher side temporary tables are created and dropped all the time (due
to some Zend Entity Framework extension "optimisation"), thus bloating
heavily the system catalogs (among others).

At some point all our logical replication subscribers / replication slots
drop, because of an error:

*"could not receive data from WAL stream: ERROR: unexpected duplicate for
tablespace 0, relfilenode 2774069304"*

The table for this file node is not even included in any of the
publications we have. I've found a similar issue described [1] before, so I
was wondering whether this patch is applied? Our subscriber database is
PostgreSQL 16.1 and the publisher - PostgreSQL 15.4.

What quick solution would fix the replication? Repack of the table? Reload
of the database? Killing some backends?

We rely heavily on this feature in a production environment and cannot just
leave the subscriber side out of sync.

Regards,
--
Kouber Saparev

[1]
https://postgrespro.com/list/thread-id/2597009#TYCPR01MB83731ADE7FD7C7CF5D335BCEEDE99(at)TYCPR01MB8373(dot)jpnprd01(dot)prod(dot)outlook(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2023-12-22 12:10:20 Re: what do you do after pg_walreset ?
Previous Message Johnathan Tiamoh 2023-12-21 23:53:47 what do you do after pg_walreset ?