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: | Whole Thread | Raw Message | 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
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 ? |