Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rHDQd-001VCD-Dk for pgsql-general@arkaria.postgresql.org; Sun, 24 Dec 2023 01:37:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rHDQZ-006adr-WB for pgsql-general@arkaria.postgresql.org; Sun, 24 Dec 2023 01:37:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rHDQY-006adj-D1 for pgsql-general@lists.postgresql.org; Sun, 24 Dec 2023 01:37:15 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rHDQS-00Bu06-L2 for pgsql-general@postgresql.org; Sun, 24 Dec 2023 01:37:12 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 5B6133200A0D; Sat, 23 Dec 2023 20:37:05 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sat, 23 Dec 2023 20:37:05 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1703381824; x=1703468224; bh=5SW+UVmGnl 5LR9n0D78OMM1OjJHwFcsS9uaP1rQTgU4=; b=XEIp6pRPpffspOeU+ZdL7ZdgaW wdFbrlcus2lNZw0rzco2GcA0IS/6pDqqZi6/aZzSiOGYZTGS1HlZi7fqj8ZorEDF qJgN42ZsFAyAkZ8h9sG9UgoCVRiRiraFbrHsSYENG4BzFn+/94brnK0SH1ngzkS8 WfDFJ1MNGJEInZ71c0lS+qyE/JP9Bfnr/065sZM391VinY7ZshucLocxAxpf+9br 818FOIscBhEaFEtsB7BZBb+LhaLjqmZrI7S66e61mmbYP0rANEoK1z8kjipJSVIK l1HtqZKpse3aFhAHBAR6S3Pf3p6ELdCu3EyAGonvkNdsuh1dYjMXstBSv0cg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1703381824; x=1703468224; bh=5SW+UVmGnl5LR9n0D78OMM1OjJHw FcsS9uaP1rQTgU4=; b=ccc+ouInkknVUlcDuxG1GcoCY494u0PB0RMoXOZ6PvHz Lc5WASkJGSmFoDAeS2RItpM+GDauzTRFD1/QIaYdXWnMMYUYKsDGsPEyXLNQQux8 Q4LzMt4+60bscT7OX60n2p0xZxC8QCJOluT8Zq5cPdbu4O495OW2/uLCjiJobKjK SbN122GJvVh2wjJzoHx3TxndIT4syv4KiD5YKCFZ63qL5OoB1h5hnukMU1mXp3up zTeHJbz3fXNSo8V3gu5tr9IOvgNVaocs4Yc1T3nc8jBjlQgGEVeZMZheDDdKCQy8 7jbVMC0hSGzjwC/GDzlt1PNhOtoA0glLtRTj3thy8Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvddvtddgfeehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepgeffjeevgfevuddvjedtvddt ieejheduueelvddufedtgfefjedvkeevkeeivddvnecuffhomhgrihhnpehpohhsthhgrh gvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 23 Dec 2023 20:37:00 -0500 (EST) Date: Sun, 24 Dec 2023 10:36:56 +0900 From: Michael Paquier To: Kouber Saparev Cc: pgsql-general@postgresql.org, wangsh.fnst@fujitsu.com, osumi.takamichi@fujitsu.com, Masahiko Sawada Subject: Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4LxUVkQC4Ayi5n5o" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4LxUVkQC4Ayi5n5o Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Dec 22, 2023 at 10:55:24AM +0200, Kouber Saparev wrote: > 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. Or just this link using the community archives based on the message-ID: https://www.postgresql.org/message-id/TYCPR01MB83731ADE7FD7C7CF5D335BCEEDE99@TYCPR01MB8373.jpnprd01.prod.outlook.com > What quick solution would fix the replication? Repack of the table? Reload > of the database? Killing some backends? There may be something you could do as a short-term solution, but it does not solve the actual root of the problem, because the error you are seeing is not something users should be able to face. The first problem that we have here is that we've lost track of the patch proposed, so I have added a CF entry for now: https://commitfest.postgresql.org/46/4720/ -- Michael --4LxUVkQC4Ayi5n5o Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmWHizgACgkQnvQgOdby QH3nLBAAniodiV6cP1CMfKXkbMUoN3iTfbHUHVDYtvYXnmPfY7SPdV08C9Dz6lU+ Iyyym+vOk9u+/I+fTtAkB5kP3KlVe+MlQmxsbpa9D/zj7sr8u0RVlneqLgi+j2p9 svrAb1cPR1FpsNf1oECPcT63GAaRWV2XoI8/KP8j2Camt0JuT4XkGWtqxS+ta933 +tUp60K6PPyLWcHJnhqEde/PRzafpVbzlYI9UPSsFFXYKYtxBoGjfDyJt7N9g697 YiQcSEzUplOPMXpJf04AHXu+PN3wumMvIHtxNv+X51I2U1XBVjybycq6XlT0re0r 69L604PtwklexA9YOAM+7N1GT/Lzoiu7kpOUXwd0lDruoTINF4AjZuWE72SxuErw Vz3PGoy37TOaOkeMEy9S3nrC6WpaLnUPd2QRB17WSdFsd2+yQoJUoDnZcbKPEaZz wNp/vKguaFkMji2JzVDzM+dF9/kMUMQM3buxEkeGLJDdU56aphk9iFSimWoSxOQz r5GHbYL78xUsvDaQ3A2X8H4+W+pe9N+HPNWvSjnnOxtpSyCew6Ajf6TBahcG3ywy AGBxhR2s4gtH8Zb6BpkLatoOmZ6MStsvf4dQFEWuiU/NQXPy9dljDgJQM1mi0hZi EYi3HO8G+s4jPxe5v+sVG0wwls+vOlOqt+HMPJs+JhE/WQmLW1s= =JokD -----END PGP SIGNATURE----- --4LxUVkQC4Ayi5n5o--