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 1hdMXe-0007i5-8O for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jun 2019 22:25:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hdMXd-00011w-6b for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jun 2019 22:25:25 +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 1hdMWy-0007jP-Oo for pgsql-committers@lists.postgresql.org; Tue, 18 Jun 2019 22:24:44 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hdMWv-0008FB-DI for pgsql-committers@lists.postgresql.org; Tue, 18 Jun 2019 22:24:44 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hdMWt-0007jH-HC for pgsql-committers@lists.postgresql.org; Tue, 18 Jun 2019 22:24:39 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.89) (envelope-from ) id 1hdMWs-0004id-QY for pgsql-committers@lists.postgresql.org; Tue, 18 Jun 2019 22:24:38 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@lists.postgresql.org From: Alvaro Herrera Subject: pgsql: Avoid spurious deadlocks when upgrading a tuple lock Message-Id: Date: Tue, 18 Jun 2019 22:24:38 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk QXZvaWQgc3B1cmlvdXMgZGVhZGxvY2tzIHdoZW4gdXBncmFkaW5nIGEgdHVwbGUgbG9jawoKVGhp cyBwdXRzIGJhY2sgcmV2ZXJ0ZWQgY29tbWl0IGRlODdhMDg0YzBhNSwgd2l0aCBzb21lIGJ1ZyBm aXhlcy4KCldoZW4gdHdvIChvciBtb3JlKSB0cmFuc2FjdGlvbnMgYXJlIHdhaXRpbmcgZm9yIHRy YW5zYWN0aW9uIFQxIHRvIHJlbGVhc2UgYQp0dXBsZS1sZXZlbCBsb2NrLCBhbmQgdHJhbnNhY3Rp b24gVDEgdXBncmFkZXMgaXRzIGxvY2sgdG8gYSBoaWdoZXIgbGV2ZWwsIGEKc3B1cmlvdXMgZGVh ZGxvY2sgY2FuIGJlIHJlcG9ydGVkIGFtb25nIHRoZSB3YWl0aW5nIHRyYW5zYWN0aW9ucyB3aGVu IFQxCmZpbmlzaGVzLiAgVGhlIHNpbXBsZXN0IGV4YW1wbGUgY2FzZSBzZWVtcyB0byBiZToKClQx OiBzZWxlY3QgaWQgZnJvbSBqb2Igd2hlcmUgbmFtZSA9ICdhJyBmb3Iga2V5IHNoYXJlOwpZOiBz ZWxlY3QgaWQgZnJvbSBqb2Igd2hlcmUgbmFtZSA9ICdhJyBmb3IgdXBkYXRlOyAtLSBzdGFydHMg d2FpdGluZyBmb3IgVDEKWjogc2VsZWN0IGlkIGZyb20gam9iIHdoZXJlIG5hbWUgPSAnYScgZm9y IGtleSBzaGFyZTsKVDE6IHVwZGF0ZSBqb2Igc2V0IG5hbWUgPSAnYicgd2hlcmUgaWQgPSAxOwpa OiB1cGRhdGUgam9iIHNldCBuYW1lID0gJ2MnIHdoZXJlIGlkID0gMTsgLS0gc3RhcnRzIHdhaXRp bmcgZm9yIFQxClQxOiByb2xsYmFjazsKCkF0IHRoaXMgcG9pbnQsIHRyYW5zYWN0aW9uIFkgaXMg cm9sbGVkIGJhY2sgb24gYWNjb3VudCBvZiBhIGRlYWRsb2NrOiBZCmhvbGRzIHRoZSBoZWF2eXdl aWdodCB0dXBsZSBsb2NrIGFuZCBpcyB3YWl0aW5nIGZvciB0aGUgWG1heCB0byBiZSByZWxlYXNl ZCwKd2hpbGUgWiBob2xkcyBwYXJ0IG9mIHRoZSBtdWx0aXhhY3QgYW5kIHRyaWVzIHRvIGFjcXVp cmUgdGhlIGhlYXZ5d2VpZ2h0CmxvY2sgKHBlciBwcm90b2NvbCkgYW5kIGdvZXMgdG8gc2xlZXA7 IG9uY2UgVDEgcmVsZWFzZXMgaXRzIHBhcnQgb2YgdGhlCm11bHRpeGFjdCwgWiBpcyBhd2FrZW5l ZCBvbmx5IHRvIGJlIHB1dCBiYWNrIHRvIHNsZWVwIG9uIHRoZSBoZWF2eXdlaWdodApsb2NrIHRo YXQgWSBpcyBob2xkaW5nIHdoaWxlIHNsZWVwaW5nLiAgS2Fib29tLgoKVGhpcyBjYW4gYmUgYXZv aWRlZCBieSBoYXZpbmcgWiBza2lwIHRoZSBoZWF2eXdlaWdodCBsb2NrIGFjcXVpc2l0aW9uLiAg QXMKZmFyIGFzIEkgY2FuIHNlZSwgdGhlIGJpZ2dlc3QgZG93bnNpZGUgaXMgdGhhdCBpZiB0aGVy ZSBhcmUgbXVsdGlwbGUgWgp0cmFuc2FjdGlvbnMsIHRoZSBvcmRlciBpbiB3aGljaCB0aGV5IHJl c3VtZSBhZnRlciBUMSBmaW5pc2hlcyBpcyBub3QKZ3VhcmFudGVlZC4KCkJhY2twYXRjaCB0byA5 LjYuICBUaGUgcGF0Y2ggYXBwbGllcyBjbGVhbmx5IG9uIDkuNSwgYnV0IHRoZSBuZXcgdGVzdHMg ZG9uJ3QKd29yayB0aGVyZSAoYmVjYXVzZSBpc29sYXRpb250ZXN0ZXIgaXMgbm90IHNtYXJ0IGVu b3VnaCksIHNvIEknbSBub3QgZ29pbmcKdG8gcmlzayBpdC4KCkF1dGhvcjogT2xla3NpaSBLbGl1 a2luCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQjlDOUQ3Q0QtRUI5NC00NjM1LTkx QjYtRTU1OEFDRUMwRUMzQGhpbnRiaXRzLmNvbQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tLzI4MTUuMTU2MDUyMTQ1MUBzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tClJFTF8xMF9T VEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21t aXRkaWZmLzA3NzJkOGEwMGViODhiNTBhYzgxZjM3OTk1NWQzMDY2MGNlY2RlZWIKCk1vZGlmaWVk IEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL1JFQURNRS50dXBs b2NrICAgICAgICAgICAgIHwgIDEwICsrCnNyYy9iYWNrZW5kL2FjY2Vzcy9oZWFwL2hlYXBhbS5j ICAgICAgICAgICAgICAgICAgIHwgIDgzICsrKysrKy0tLQouLi4vZXhwZWN0ZWQvdHVwbGVsb2Nr LXVwZ3JhZGUtbm8tZGVhZGxvY2sub3V0ICAgICB8IDE5NSArKysrKysrKysrKysrKysrKysrKysK c3JjL3Rlc3QvaXNvbGF0aW9uL2lzb2xhdGlvbl9zY2hlZHVsZSAgICAgICAgICAgICAgfCAgIDEg KwouLi4vc3BlY3MvdHVwbGVsb2NrLXVwZ3JhZGUtbm8tZGVhZGxvY2suc3BlYyAgICAgICB8ICA3 MiArKysrKysrKwo1IGZpbGVzIGNoYW5nZWQsIDM0MCBpbnNlcnRpb25zKCspLCAyMSBkZWxldGlv bnMoLSkKCg==