Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lracn-00043y-5x for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Jun 2021 06:26:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lracm-0002ZL-5p for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Jun 2021 06:26:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lracl-0002Ys-VP for pgsql-bugs@lists.postgresql.org; Fri, 11 Jun 2021 06:26:35 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lracj-0006bS-IP for pgsql-bugs@lists.postgresql.org; Fri, 11 Jun 2021 06:26:35 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id C18E95C0064; Fri, 11 Jun 2021 02:26:32 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Fri, 11 Jun 2021 02:26:32 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=MbqShzkidMHlKFJ8MjHOzPHcZ21 U9GYuDygphzuU+RM=; b=bwioyZVdVgj4gTj8oMiAioWpcdSmh8QsXTUYiGzPygP HMtNwDCBdVdYfpXrZZpiJZ6LjnngX9UbN3m7GKXTmh9T/WZayxojfGHMkgPB5teo bk+20MSF+KevyoU9dDYieVVT5frRgrlY7O57Otc+lJiHXzSWjkA3CNhkV/1aK9Fy mJ42prUEMb83w3iIm8DgsRQJXutza5nlBJpLhWixtsXBdPvYyNxcFWyHaNDbYyR5 OPzI2Y5m/L6fMJL1tQqi862a7QKT9SCTNVYk105/BOgF7wNLWZmDCMOEnXwHL1GK 7fQZq3OSuKM5n4zuALfZRp1H0NykrpVBgPDijC6zjbg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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=fm3; bh=MbqShz kidMHlKFJ8MjHOzPHcZ21U9GYuDygphzuU+RM=; b=Ta9mbWr98+CIPtMBY4RWGo +SMMHe1UZ4UH05jWwjAMRyOhjZRfRiSN03WBSBPfV9E8hKocE99xGvb1YIsgmL8S TxQCB3Fu0dVttAF9iL6xp1kVrzxqGJ8pC7UhJ7iB+8IuNJRDYNKPM/kwKUfDNajU witBXkYPOjfxMbDiC7yIxTvISBmZfGA7tOyLzLJCuFci4q8o8EXGMzBVMKkRcN4S CGgb5qssWh5Czqis25qU2iVTPyYQYrhPyyB46raU+VFLLdql6WeCdUrGnS2nuDZ+ 8T8mDN6CkuT5xNGdXWU74pFpZzG1cJCyX5EJqkd/chLWw5CSyFxlyAUNyunENxvA == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrfeduiedguddthecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveej heehieevueeigeelteegleejleeiueeiheegvefhnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 11 Jun 2021 02:26:30 -0400 (EDT) Date: Fri, 11 Jun 2021 15:26:28 +0900 From: Michael Paquier To: Amit Langote Cc: Tom Lane , sbernikov@gmail.com, PostgreSQL mailing lists Subject: Re: BUG #17055: Logical replication worker crashes when applying update of row that dose not exist in target partiti Message-ID: References: <17055-9ba800ec8522668b@postgresql.org> <1828113.1623370641@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tRGr8Ld9IeNP1TOU" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --tRGr8Ld9IeNP1TOU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Jun 11, 2021 at 02:56:58PM +0900, Amit Langote wrote: > Attached fixes the problem for me. Not sure if adding a test case makes sense. It seems to me that it would make sense to have some coverage. We've caught issues in the past in this area, particularly with buildfarm animals running CLOBBER_CACHE_ALWAYS. -- Michael --tRGr8Ld9IeNP1TOU Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmDDAhQACgkQnvQgOdby QH2XZQ//a37RkFiaEQBfsVF9LmhLsdomS7FuJg9cZ5QpsXzOIK9eYcozr38ApaFE jRCQJwT7BbDP51wIJYsJuALgrmbSsMoNA29Ek86n8ib2bVUkXs26OlEWWe4V28xh KbmGWQXl8z2UPSwTU6UnlbDaLXS2AB7P/GsO8ENeuHm+reCXWArYl1BO4Itks6Vx Cyf7gE4J68bGRVGAP3eO3nBMCT3J4jNSTzxGFJlkzMgY1tc0OuoTuSIVngTvwp2g nPwJ+L8O9NA22oMsDr0W+9VADoGYXet1hi6bwEWbgdyRnpv112btKlKgcCND7YjE tjzuA3MkIGP2nDy6KV/OCP8fycnGK+jQ43vVnGz56YTmpg2BG4a03WwNDWWdMcke gytg3uo/RRT+YE/Sx+iHgUOzAI8hpHPS88BDNrJ73sgqvXJbD67AI6j6/DTZYggg TLH8uMVcYg1yBXHIJjl+/FRbMsNQsZnhoOSMvq6l78F3Sjo+FoBhWTg6zVUp1EfD nuCnqJpDqJRnFNFo3DaSLFsBfUt6gI2fKsAMsbTs0HagNld+bGh8UDlfGsXQMKjZ yQmlR1Uf68fMw51PSrCXvHs0upeHKwiQpItAW0kgQ9aDamFeYOCrOD2VOhijV/Vs ZnVu/C8Dx1DzLvb7ZuipTFAOAYxf6MEue+O52ZkNu65EO2IlR4c= =EWrU -----END PGP SIGNATURE----- --tRGr8Ld9IeNP1TOU--