Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1irYte-000193-2o for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Jan 2020 02:59:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1irYtc-0004WB-Pv for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Jan 2020 02:59:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1irYtc-0004W4-Hy for pgsql-bugs@lists.postgresql.org; Wed, 15 Jan 2020 02:59:04 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1irYtZ-000433-U6 for pgsql-bugs@lists.postgresql.org; Wed, 15 Jan 2020 02:59:04 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 8A0D42213D; Tue, 14 Jan 2020 21:59:00 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 14 Jan 2020 21:59:00 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=1VziPuauPTRsjN2nQpLJmcqwuDb B28I8x9j0uxS6DFI=; b=ZDg2iec6qCz8ZT86QbVwyQFWBkIOkd9cej6et7sxDjm JbdXjifcD6eGV+05N+xY3zMEsA0YzvcyuTggSpLgh4Olc9ExQOo6+R5QCAc10tlx CuRCvWNYuQDEWQrWI4zeLe2VRob6Km/JVvpwbO6iwmBWAb5t5NaEkbSQuMqdLEJf ejufqPD9kt3WWH0TO8yOormRwj5eQmjb23KGXGsNcoGxBBbKyOSa/w4sVZwO1J7Q rCKg3NaZ0iQDXjN6kbKoNaCLlgO7fjvr+E3WkbiV5zZRdwYPktruvn7I43fPEqcZ wfAy5xp1XINeTSowwdUylkqBsbq5HOsEdzSfowaWQeQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=1VziPu auPTRsjN2nQpLJmcqwuDbB28I8x9j0uxS6DFI=; b=RMLhb3l0mJVVs1exnJTjYI k1yC7VaDIANHpFs/15boVutxTp93JT4REyWfPLsAFHXztBQTOkIE/iwdC+KC2+az Qwv2ITyII3EzCdlArVa9wxUBNDwr6fZMNJAJshbEa/q5NQOVcS0UlyLTDgy1Xzqy wP2eQSjnIbwlpmhH5ZGj8/AbTTuHcfG/Y0lXnc5DcY+HDvLijBw8L922bJODGQZT GeYly/UY+JM9vBMuQzPrNoFKW3ACsWtA5PncT9GIyMnCwjWuz8cynZv/ABB4spXi az6s1vkhXOcFwDKbC4fPjmOr+rSAP4STUEEoZAxFjh4cRSgzcfTEqJ6y5cqnI2JA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrtddvgdehvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuffhomhgrihhnpehpoh hsthhgrhgvshhqlhdrohhrghenucfkphepudduuddruddtvddrudektddrudekheenucfr rghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienuc evlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id AC4B380062; Tue, 14 Jan 2020 21:58:55 -0500 (EST) Date: Wed, 15 Jan 2020 11:58:41 +0900 From: Michael Paquier To: pendekar.senja@outlook.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16205: background worker "logical replication worker" (PID 25218) was terminated by signal 11: Segmentation Message-ID: <20200115025841.GF2243@paquier.xyz> References: <16205-5f93551b36ff4f34@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="qD3brAgIG4LbUq6d" Content-Disposition: inline In-Reply-To: <16205-5f93551b36ff4f34@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --qD3brAgIG4LbUq6d Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Jan 15, 2020 at 02:00:48AM +0000, PG Bug reporting form wrote: > I got error when replicate with native logical method from PostgreSQL 11.6 > to PostgreSQL 12.1, I will connecting table partition to table partition > from Version 11.6 to Version 12.1, but after all tables already replicated > around more than 2 hours, server can't access and recovery mode. please help > to advice, below log. Could you provide a backtrace? Looking at the recent commit history, we had one fix which could be relevant to you after 12.1 was released: https://www.postgresql.org/message-id//16129-a0c0f48e71741e5f@postgresql.org And here is the commit: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=a2aa224e The problem may be different though, so a backtrace would be good to check anyway. -- Michael --qD3brAgIG4LbUq6d Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4ef+EACgkQnvQgOdby QH0I2A//UthziA/Hs/1p3I5PKig1737Jf6j54YvHyNq/JwR5ttz9y91YR5nH/4Zt s4/BTAqu3C5A6RmK2kMeAFQ299eDa54cCsAkq5tM+Am/IcgIkekY7i/VTN76m8oQ +VAoe27q3pOefhM41bk+y691mq16CV19srFVUh4+R7tuXO/BlA/wZbXP2tpAU/P8 Qv0lJQ056rGvxG+Zx2QlCK3mJi2A5jqsWwAf82u4p5WiSsvQS3zBYMMSqEHt5DDn GO0AvVqEfZb1VeUdg36k4WBzil06HBzOvNGdBTUEKeKzuHtvXwgF9ADvAQEX3yiw fy7IGksMX9DgBpdMnL4Kzn5kaQXhvsWdwVJDq33s9BCsGIl2D3v3r8iHSaa0gnqY ovUkbnztbh8VznbKq7LAJhsAbyLY6Qs3luyDfzVF5cXlzi0AJodO8nYMJ3SOfigd pNEC8eho3vgiOlbgy10K8giXODSbBt+IGhKh3wXqVJ7Of/M8hulxv4aYykZZsAQs lACjRh8SSP6lUGoOZHu7Dp00ABiyVKHdkareABgqDV4oZBNcLa+O/c2kodrWBNvU qrOroviK3Oi25Y/HQAtk7LMqQ9x9VX26U70Bxg6t6wdNzOqt+zxsb2wrtZxN59tJ c1o7HJGB/QGGmnogauum/IJKoNTWhj9keLXHc7LBi1SN8NwP+a4= =AWSF -----END PGP SIGNATURE----- --qD3brAgIG4LbUq6d--