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 1kzcxt-0002GW-Cf for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Jan 2021 10:01:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kzcxs-0007Y0-DL for pgsql-bugs@arkaria.postgresql.org; Wed, 13 Jan 2021 10:01:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kzapA-0003uL-O9 for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 07:44:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kzap6-00043Q-OE for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 07:44:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ZeAt1KrklQRwHZQF0B7SzeoxBUiZ3lAWWt7xU8GN4Uk=; b=Or07GKKvyf54t+bgKcVxXrk5LM majTJ2oz9A9sOuahSBumNWY9TARn1hSkPUOQa9Xv3sTXY0UIqhAZiJhL46x7EbAuWBcXFUJB+t8WP Ouy1MaEUvPaNqaRc3JP/9gdFEfn/8upcH2LtfkuwSOF8G0bmVgoLOHupoAgyhCz7gkXwQZEzvS5t+ fGc79oaLWzsiioDF2dfQ4vog+3oaxD1UV7KfE0bzdytasRZNxCPRF8luHyPMtgsEFplEJzd0asjkp wQwoLkL9yiwlToIlVaMZmMi0Jt9bFAQgZR+3H1sfdu4AunCuTCU/Z6y8c1I6ZI/IdDSx5nk0FHNbt BPjE+s+Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kzap3-0005Kq-4X for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 07:44:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kzap0-000065-Mk for pgsql-bugs@lists.postgresql.org; Wed, 13 Jan 2021 07:44:02 +0000 Content-Type: multipart/mixed; boundary="===============2033335607340823387==" MIME-Version: 1.0 Subject: BUG #16820: PG will have a deadlock when multiple rows are updated concurrently To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: abcxiaod@126.com Reply-To: abcxiaod@126.com, pgsql-bugs@lists.postgresql.org Date: Wed, 13 Jan 2021 07:43:43 +0000 Message-ID: <16820-2f08e0bd1687ee34@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2033335607340823387== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjgyMApMb2dnZWQgYnk6ICAgICAgICAgIHlpIERpbmcKRW1haWwgYWRk cmVzczogICAgICBhYmN4aWFvZEAxMjYuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTAuMTMKT3Bl cmF0aW5nIHN5c3RlbTogICBsaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKVGhlIHRlc3QgaXMg YXMgZm9sbG93c++8mg0KMeOAgXRoZSB0ZXN0IHRhYmxl77yaDQpwb3N0Z3Jlcz0jIHNlbGV0ICpm cm9tIHp4aW5fY2FyZGNhcGFjaXR5Ow0KYSAgICB8ICAgIGIgICB8ICAgIHVzZWNhcGFjaXR5DQot LS0tKy0tLS0tKy0tLS0tLS0tLS0tLS0tLQ0KMSAgIHwgICAgMSAgIHwgIDk5OTk4OTMzODYzDQoy ICAgfCAgICAxICAgfCAgOTk5NjAyODExOTANCjMgICB8ICAgIDEgICB8ICA5OTk2MDgwODU2Nw0K NCAgIHwgICAgMSAgIHwgICAgOTk5OTgzNjQ1Nw0KNSAgIHwgICAgMSAgIHwgICAgOTk5OTgzNjQ1 Nw0KNiAgIHwgICAgMSAgIHwgICAgOTk5OTgzNjQ1Nw0KNyAgIHwgICAgMSAgIHwgICAgOTk5OTgz NjQ1Nw0KOCAgIHwgICAgMSAgIHwgICAgOTk5OTgzNjQ1Nw0KOSAgIHwgICAgMSAgIHwgICAgOTk5 OTgzNjQ1Nw0KMTAgIHwgICAgMSAgIHwgICAgOTk5OTgzNjQ1Nw0KMTEgIHwgICAgMSAgIHwgICAg OTk5OTgzNjQ1Nw0KMTIgIHwgICAgMSAgIHwgICAgOTk5OTgzNjQ1Nw0KMTMgfCAgICAxICAgfCAg ICA5OTk5ODM2NDU3DQoxNCB8ICAgIDEgICB8ICAgIDk5OTk4MzY0NTcNCjE1IHwgICAgMSAgIHwg ICAgOTk5OTgzNjQ1Nw0KDQoy44CBUHJlc3N1cmUgbWVhc3VyZW1lbnQgdG9vbHM6DQpVc2UgcGdi ZW5jaCB0byBpbml0aWF0ZSAxMDAgY29uY3VycmVudDoNCiRwZ2JlbmNoIC1jIDEwMCAtVCAxODAw MDAgLXJmIHVwZGF0ZS5zcWwgcG9zdGdyZXMNCg0KMy4gVGVzdCByZXN1bHRzOg0KKDEpIEFzIGxv bmcgYXMgdGhlIGRhdGEgb2YgYSBzaW5nbGUgdXBkYXRlIGV4Y2VlZHMgMSByb3csIGEgZGVhZGxv Y2sgd2lsbApvY2N1cjoNCnVwZGF0ZSB6eGluX2NhcmRjYXBhY2l0eSBzZXQgdXNlY2FwYWNpdHkg PSB1c2VjYXBhY2l0eSAtIDIgd2hlcmUgYSA+MjsNClBnX2xvY2tzIHJlbGF0ZWQgcmVjb3JkcyBk dXJpbmcgZGVhZGxvY2s6DQpsb2NrdHlwZSAgfCBkYXRhYmFzZSB8cmVsYXRpbyB8cGFnZXx0dXBs ZXx2aXJ0dWFseGlkfHRyYW5zYWN0aW9uaWR8Y2xhc3NpZCB8Cm9iamlkIHwgb2Jqc3ViaWQgfCB2 aXJ0dWFsdHJhbnNhY3Rpb24gfCAgcGlkICAgfCAgICAgIG1vZGUgICAgICAgfCBncmFudGVkIHwK ZmFzdHBhdGgNCnRyYW5zYWN0aW9uaWQgfCAgICAgICAgICB8ICAgICAgICAgICB8ICAgICAgfCAg ICAgICB8ICAgICAgICAgICAgfCAgICAgICAKNTQ2ODcyIHwgICAgICAgICB8ICAgICAgIHwgICAg ICAgICAgfCAgICAgICAgMjMvMTQ4MCAgICAgICAgICAgICAgICAgfAoxNjYxOTcgfCBFeGNsdXNp dmVMb2NrICAgIHwgdCAgICAgICB8IGYNCiB0cmFuc2FjdGlvbmlkIHwgICAgICAgICAgfCAgICAg ICAgICB8ICAgICAgfCAgICAgICB8ICAgICAgICAgICAgfCAgICAgICAKNTQ2ODc1IHwgICAgICAg ICB8ICAgICAgIHwgICAgICAgICAgfCAgICAgICAgMjMvMTQ4MCAgICAgICAgICAgICAgICAgfAox NjYxOTcgfCBTaGFyZUxvY2sgICAgICAgIHwgZiAgICAgICB8IGYNCiB0cmFuc2FjdGlvbmlkIHwg ICAgICAgICAgfCAgICAgICAgICB8ICAgICAgfCAgICAgICB8ICAgICAgICAgICAgfCAgICAgICAK NTQ2ODcyIHwgICAgICAgICB8ICAgICAgIHwgICAgICAgICAgfCAgICAgICAgMjAvMTU5NiAgICAg ICAgICAgICAgICAgfAoxNjYxODkgfCBTaGFyZUxvY2sgICAgICAgIHwgZiAgICAgICB8IGYNCiB0 cmFuc2FjdGlvbmlkIHwgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgfCAgICAgICB8ICAgICAg ICAgICAgfCAgICAgICAKNTQ2ODc1IHwgICAgICAgICB8ICAgICAgIHwgICAgICAgICAgfCAgICAg ICAgMjAvMTU5NiAgICAgICAgICAgICAgICAgfAoxNjYxODkgfCBFeGNsdXNpdmVMb2NrICAgIHwg dCAgICAgICB8IGYNCg0KRGVhZGxvY2sgZGF0YToNCnBvc3RncmVzPSMgc2VsZWN0IHhtYXgseG1p biwqIGZyb20genhpbl9jYXJkY2FwYWNpdHkgOw0KICB4bWF4ICB8ICB4bWluICB8IGEgfCBiIHwg dXNlY2FwYWNpdHkNCi0tLS0tLS0tKy0tLS0tLS0tKy0tLSstLS0rLS0tLS0tLS0tLS0tLQ0KIDU0 Njg3NSB8IDU0Njg2NyB8IDMgfCAxIHwgOTk5OTk2MDI3NzUNCiA1NDY4NzIgfCA1NDY4NjcgfCAy IHwgMSB8IDk5OTk5MDc1Mzk4DQoNCigyKSBVcGRhdGUgb25lIHJvdyBmaXJzdCwgdGhlbiB1cGRh dGUgbXVsdGlwbGUgcm93cywgdGhlcmUgd2lsbCBiZSBubwpkZWFkbG9jazoNCmRvICQkDQpiZWdp bg0KdXBkYXRlIHp4aW5fY2FyZGNhcGFjaXR5IHNldCB1c2VjYXBhY2l0eSA9IHVzZWNhcGFjaXR5 IC0gMiB3aGVyZSBhID0gMTsNCnVwZGF0ZSB6eGluX2NhcmRjYXBhY2l0eSBzZXQgdXNlY2FwYWNp dHkgPSB1c2VjYXBhY2l0eSAtIDIgd2hlcmUgYSA+PTI7DQplbmQgJCQ7DQoNCigzKSBJZiB0aGUg ZW50aXJlIHRhYmxlIGlzIHVwZGF0ZWQgd2l0aG91dCBzb3J0aW5nLCBhIGRlYWRsb2NrIHdpbGwg b2NjdXI6DQpkbyAkJA0KZGVjbGFyZQ0Kdl8xIHJlY29yZDsNCmJlZ2luDQpmb3Igdl8xIGluIHNl bGVjdCBhIGZyb20genhpbl9jYXJkY2FwYWNpdHkNCmxvb3ANCnVwZGF0ZSB6eGluX2NhcmRjYXBh Y2l0eSBzZXQgdXNlY2FwYWNpdHkgPSB1c2VjYXBhY2l0eSAtIDIgd2hlcmUgYSA9CnZfMS5hOw0K ZW5kIGxvb3A7DQplbmQgJCQ7DQoNCig0KSBBZnRlciBzb3J0aW5nLCB0aGUgZW50aXJlIHRhYmxl IGlzIHVwZGF0ZWQgY3ljbGljYWxseSB3aXRob3V0CmRlYWRsb2NrOg0KZG8gJCQNCmRlY2xhcmUN CnZfMSByZWNvcmQ7DQpiZWdpbg0KZm9yIHZfMSBpbiBzZWxlY3QgYSBmcm9tIHp4aW5fY2FyZGNh cGFjaXR5IG9yZGVyIGJ5IGENCmxvb3ANCnVwZGF0ZSB6eGluX2NhcmRjYXBhY2l0eSBzZXQgdXNl Y2FwYWNpdHkgPSB1c2VjYXBhY2l0eSAtIDIgd2hlcmUgYSA9CnZfMS5hOw0KZW5kIGxvb3A7DQpl bmQgJCQ7DQoNCg0KQWZ0ZXIgYW5hbHlzaXMsIHdlIGJlbGlldmUgdGhhdCB0aGUgZGVhZGxvY2sg cHJvYmxlbSBpcyBjYXVzZWQgYnkgUEcncwp1bmlxdWUgTVZDQyBhbmQgbG9ja2luZyBtZWNoYW5p c20uDQoxLiBXaGVuZXZlciBhIGRhdGEgcm93IGlzIHVwZGF0ZWQgaW4gUEcsIHRoZSBwaHlzaWNh bCBsb2NhdGlvbiBvZiB0aGUgcm93CmNoYW5nZXMsIHJlc3VsdGluZyBpbiBoaWdoIGNvbmN1cnJl bmN5IHNjZW5hcmlvcywgZWFjaCBxdWVyeSBvciB1cGRhdGUKb3BlcmF0aW9uLCB0aGUgb3JkZXIg b2YgdGhlIHJldHVybmVkIGRhdGEgcm93cyBpcyBkaWZmZXJlbnQuDQoyLiBXaGVuIFBHIGlzIHVw ZGF0aW5nIGRhdGEsIGluIG9yZGVyIHRvIGluY3JlYXNlIGVmZmljaWVuY3kgYW5kIHJlYWxpemUK bXVsdGktc2Vzc2lvbiBwYXJhbGxlbCB1cGRhdGUsIHRoZSBkYXRhIHJvd3MgaW4gdGhlIHRhYmxl IGFyZSBsb2NrZWQgcm93IGJ5CnJvdy4NClRoZSBjb21iaW5hdGlvbiBvZiB0aGUgYWJvdmUgdHdv IHJlYXNvbnMgbGVhZHMgdG8gYSBkZWFkbG9jayB3aGVuIG11bHRpcGxlCnJvd3Mgb2YgZGF0YSBh cmUgdXBkYXRlZCBjb25jdXJyZW50bHkuCgo= --===============2033335607340823387==--