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 1hcheR-0002Mw-0B for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Jun 2019 02:45:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hcheP-0006fm-UV for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Jun 2019 02:45:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hcheO-0006ec-Av for pgsql-hackers@lists.postgresql.org; Mon, 17 Jun 2019 02:45:41 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hchdq-0005Jn-L1 for pgsql-hackers@lists.postgresql.org; Mon, 17 Jun 2019 02:45:39 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 2C339420; Sun, 16 Jun 2019 22:45:05 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sun, 16 Jun 2019 22:45:05 -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=AYgDq6Jt+DBZ5vTO3TgPUF+XKfi 5ghbg90ZbUM1XvH8=; b=XLzB7vSl2c1XBQWhdRcEfX3hz/qaS9JtX8KJTEyAJKB 16QKrKNXgipVSZZT9p+5GBCYXBMAerOAJqJkwvTA9f/HiK6Hm7HwtgQ+7kXCrM60 sq6GpC3F/0GK0Sp9hMu9QHgw4yJWoEkkkj71lIWh/v1HHMsvcB9oyQyp8wA1TK+P YTMdINZWub8iZ9TzGXzzpOQTbbp8fN89yW6hc/qW4snPK5MSnlTMtTQFOrzdEQrl ZV8B6/jftQMUJXkAO3ZSosMwi3CXDip/K1m/avDhZehnspkPUXTAt14BNFVxQpGR uRNDeWnF46bfxJXxGF7OG8tUn243YgqCnqsOJJt/JKw== 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=AYgDq6 Jt+DBZ5vTO3TgPUF+XKfi5ghbg90ZbUM1XvH8=; b=1PPuLsSzQXvzvLrF8KGAgw I/6OX4+vCK5W8j2gBCqJS36noYXX4NCitCUUEZjytVpte9bkdfYajr5tr1pPWAJI CMF+O8DeWaqMmjkB4xHS09mUDqkZU5BIIO7131k4P2oVEWBVJCqCAPOarOTIX7ID oSSVEJN/v61j1wvmjs+AS8Penz5ilHHXDsjxdrdn3a89nvs/N/ELgS1aLqCB2BOm ri358MnWaRDpyLlBlPtRE2TuVvJnWWh6huKD3asgCYp585JOib3+ACiy9rn4tqbJ GEH4sXoyJHPMFwYJIc4MKdAXdJNUlOeisnljEVcWBge9BwQdEDCLu/XneHo/mu3Q == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrudeiiedgheejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt 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 4A8FC380086; Sun, 16 Jun 2019 22:44:53 -0400 (EDT) Date: Mon, 17 Jun 2019 11:44:20 +0900 From: Michael Paquier To: Tom Lane Cc: Alvaro Herrera , Oleksii Kliukin , pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Message-ID: <20190617024420.GA18917@paquier.xyz> References: <20190617022555.GA20544@alvherre.pgsql> <7785.1560738445@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="DocE+STaALJfprDB" Content-Disposition: inline In-Reply-To: <7785.1560738445@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --DocE+STaALJfprDB Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Jun 16, 2019 at 10:27:25PM -0400, Tom Lane wrote: > Alvaro Herrera writes: >> On 2019-Jun-17, Michael Paquier wrote: >>> Could you revert asap please then? >=20 >> Done. >=20 > Thanks. Thanks, Alvaro. -- Michael --DocE+STaALJfprDB Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl0G/oQACgkQnvQgOdby QH1unA//cIwupYCQ7skPENR7wO217jqBWQDssBmi+UuVMM1oXKfPazk5k7ogY+a7 nSiryhKJ6/OiSV4wvzRod8yWf4c/Hmk3zYsHQIQh464OgMTLuOWC5/JDfLuLIHFl S0Xi2f03OEtCUNoMcAc0QgOITDcJ/Ynmkj2eJdRAuVKtMzCUplNkUhF3u5WU7dkW 0V+77KDxZxgINCQm+L62GynkiR7jm+0glKUfc7Rm1f31ftZWf022nUGkQn+h6O6z bUam/mfmcu9/ih7uRlQ4jkdRA43ggyX+HpH/QWmamsb22MNP97SL5Hr1WCicftGX f4+GR95lxbWSmzAk9jXfhVnRAL7rQHSccwL2kmsjNEy7vLdnY44AZLQj7XtmnliJ fDtEZhAOmnAPtW84OEgq402Usmq6K/HAppJOqDPkXnwFW6iml+OI0W57h92A6vGo YGYqB4FX4q1QszLfq/uri7g73jivXwfR4IvGRX0iZ8d6piKBtIFtaZgR8ukhh7F2 JD5MgAxGdpRC+mfybRtgNBGzLIHgzdosC5MoGzu9yJS01m+RVDd20DM5Nyun5+cf TJJR6xNTdarLLR971n1mK51vVifBLK2YZQ5qicOvbBp+XnAvG+ObqK8A0p68y0D/ M8th8fnDXTHGRtuFme6AFZh1MEEwQnA4EhhyGdGbHdOyAydXJXw= =G/Hj -----END PGP SIGNATURE----- --DocE+STaALJfprDB--