Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNUu1-00Cefg-Kb for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Jan 2024 09:29:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rNUu0-001xun-SO for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Jan 2024 09:29:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNUe4-001pgB-Li for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 09:13:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNUe2-000ntY-85 for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 09:13:08 +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=pzRqVH5R+hmQCHVbJ76DlGZHDxDm3fjEZvH+UsV2lYY=; b=3K3UktTxYI5bncaxqyYeeJIqhr XRcg8Ug9oAZWXyctEMCV+YW1s1Sjki4FQvdVfMiv1/PIjhTGRPyvG3v61h/DrQVVcQ8/Ak9hD6gc/ oa2FDfOmTbzwQVuHQ8Smeh7px9P6DOIPY56DYHoIYQsLX8mUZpnsOVLplqa8HlmIY0IVMJmDqYQWH fnVq7L9tV/kUfr2989y2K6Rhe+RFnaBpKQxCss/DL/OL6LCHqZjQUU03Xr3SHWvdzaeECD26uh+qn O6/Z7QfcaaOP74PtqGo27JqXoFc501YaNEoM2YylefvfwezovjCMhjkZNEinc65E8rRU943aIkS7k imzaLoHw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rNUdz-002Rmc-PL for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 09:13:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rNUdy-004yX3-O1 for pgsql-bugs@lists.postgresql.org; Wed, 10 Jan 2024 09:13:02 +0000 Content-Type: multipart/mixed; boundary="===============4020446352917757201==" MIME-Version: 1.0 Subject: BUG #18279: Duplicate key violation and Deadlock when using ON CONFLICT/DO UPDATE with multiple unique indexes To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nye7181@gmail.com Reply-To: nye7181@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 10 Jan 2024 09:12:20 +0000 Message-ID: <18279-9793f12b34aa8366@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4020446352917757201== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODI3OQpMb2dnZWQgYnk6ICAgICAgICAgIFllb25nZXVuIE5vaApFbWFp bCBhZGRyZXNzOiAgICAgIG55ZTcxODFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYu MQpPcGVyYXRpbmcgc3lzdGVtOiAgIE1hY09TIDEzLjEKRGVzY3JpcHRpb246ICAgICAgICAKCkkg aGF2ZSBhIHRhYmxlIHdpdGggYSBwcmltYXJ5IGtleSBhbmQgYSB1bmlxdWUgaW5kZXguDQpGaXJz dCwgSSByYW4gYW4gSU5TRVJUIHF1ZXJ5IGFuZCB0aGVuIHNldmVyYWwgSU5TRVJUIElOVE8gT04g Q09ORkxJQ1QgRE8KVVBEQVRFIHF1ZXJpZXMgaW4gcGFyYWxsZWwuDQpUaGlzIHdpbGwgYWxtb3N0 IGFsd2F5cyByZXN1bHQgaW4gRHVwbGljYXRlIGtleSB2aW9sYXRpb25zLCBhbmQgc29tZXRpbWVz CkRlYWRsb2Nrcy4NCldoZW4gSSByZW1vdmVkIHRoZSB1bmlxdWUgaW5kZXgsIHRoZXJlIHdhcyBu byBEdXBsaWNhdGUga2V5IHZpb2xhdGlvbiBvcgpEZWFkbG9jay4NCg0KSSBoYXZlIHR3byBxdWVz dGlvbnMgcmVnYXJkaW5nIHRoaXMgc2l0dWF0aW9uLg0KDQoxLiBTaW5jZSBJIGhhZCBhbHJlYWR5 IGluc2VydGVkIGEgcm93LCBJIGV4cGVjdGVkIHRoZSBJTlNFUlQgSU5UTyBPTgpDT05GTElDVCBE TyBVUERBVEUgcXVlcmllcyB0byBvbmx5IHVwZGF0ZSBpdC4NCkhvd2V2ZXIsIGlmIHRoZXJlIGlz IGEgdW5pcXVlIGluZGV4LCBpdCBzZWVtcyB0byB0cnkgdG8gaW5zZXJ0IHJhdGhlciB0aGFuCnVw ZGF0ZS4NCjIuIEVhY2ggdHJhbnNhY3Rpb24gZXhlY3V0ZXMgb25seSBvbmUgcXVlcnkgZm9yIG9u ZSByb3cuIEhvdyBkb2VzIGEgZGVhZGxvY2sKb2NjdXI/DQoNCkhlcmUncyB0aGUgcmVwcm9kdWN0 aW9uIGNvZGUuDQpgYGBzcWwNCkNSRUFURSBUQUJMRSBlbWFpbF9zdGF0cyAoDQogIGlkIHZhcmNo YXIgTk9UIE5VTEwgUFJJTUFSWSBLRVksDQogIHVzZXJfaWQgaW50ZWdlciBOT1QgTlVMTCwNCiAg ZGF0ZSBkYXRlIE5PVCBOVUxMLA0KICBjb3VudCBpbnRlZ2VyIE5PVCBOVUxMDQopOw0KQ1JFQVRF IFVOSVFVRSBJTkRFWCB1c2VyX2lkX2RhdGUgT04gZW1haWxfc3RhdHModXNlcl9pZCwgZGF0ZSk7 DQpgYGANCg0KYGBgc2gNCiMhL2Jpbi9iYXNoDQpDT05ORUNUSU9OX0NPVU5UPTUwMA0KUVVFUllf Q09VTlRfUEVSX0NPTk5FQ1RJT049MTANCklOU0VSVF9RVUVSWT0iSU5TRVJUIElOVE8gZW1haWxf c3RhdHMgKGlkLCB1c2VyX2lkLCBkYXRlLCBjb3VudCkgVkFMVUVTCignMjAyNC0wMS0wMV8xJywg MSwgJzIwMjQtMDEtMDEnLCAxKTsiDQpPTl9DT05GTElDVF9RVUVSWT0iSU5TRVJUIElOVE8gZW1h aWxfc3RhdHMgKGlkLCB1c2VyX2lkLCBkYXRlLCBjb3VudCkgVkFMVUVTCignMjAyNC0wMS0wMV8x JywgMSwgJzIwMjQtMDEtMDEnLCAxKSBPTiBDT05GTElDVCAoaWQpIERPIFVQREFURSBTRVQgY291 bnQgPQplbWFpbF9zdGF0cy5jb3VudCArIDE7Ig0KDQpwZXJmb3JtKCkgew0KICBlY2hvICJTdGFy dCINCiAgaW5zZXJ0X2ZpcnN0DQogIGluc2VydF9tdWx0aXBsZQ0KfQ0KaW5zZXJ0X2ZpcnN0KCkg ew0KICBwc3FsIC1oIGxvY2FsaG9zdCAtcCA1NDMyIC1VIGNoYW5uZWwgLWQgY2hhbm5lbCAtYyAi JElOU0VSVF9RVUVSWSINCn0NCmluc2VydF9tdWx0aXBsZSgpIHsNCiAgZWNobyAiY3JlYXRpbmcg Y29ubmVjdGlvbnMuLi4iDQogIGZvciAoKGkgPSAwOyBpIDwgJENPTk5FQ1RJT05fQ09VTlQ7IGkr KykpOyBkbw0KICAgICgNCiAgICAgIGVjaG8gImluc2VydGluZyByZWNvcmRzIGZvciBjb25uZWN0 aW9uICRpLi4uIg0KICAgICAgZm9yICgoaiA9IDA7IGogPCAkUVVFUllfQ09VTlRfUEVSX0NPTk5F Q1RJT047IGorKykpOyBkbw0KICAgICAgICBwc3FsIC1oIGxvY2FsaG9zdCAtcCA1NDMyIC1VIGNo YW5uZWwgLWQgY2hhbm5lbCAtYwoiJE9OX0NPTkZMSUNUX1FVRVJZIiAxPiAvZGV2L251bGwNCiAg ICAgIGRvbmUNCiAgICApICYNCiAgZG9uZQ0KICB3YWl0DQp9DQoNCnBlcmZvcm0NCmBgYA0KDQpI ZXJlJ3MgdGhlIHNlcnZlciBlcnJvciBsb2cuDQpgYGANCjIwMjQtMDEtMTAgMDY6NTY6MDcuNDcz IFVUQyBbNDMzMV0gRVJST1I6IDIzNTA1OiBkdXBsaWNhdGUga2V5IHZhbHVlCnZpb2xhdGVzIHVu aXF1ZSBjb25zdHJhaW50ICJ1c2VyX2lkX2RhdGUiDQoyMDI0LTAxLTEwIDA2OjU2OjA3LjQ3MyBV VEMgWzQzMzFdIERFVEFJTDogS2V5ICh1c2VyX2lkLCBkYXRlKT0oMSwKMjAyNC0wMS0wMSkgYWxy ZWFkeSBleGlzdHMuDQoyMDI0LTAxLTEwIDA2OjU2OjA3LjQ3MyBVVEMgWzQzMzFdIExPQ0FUSU9O OiBfYnRfY2hlY2tfdW5pcXVlLApuYnRpbnNlcnQuYzo2NjYNCjIwMjQtMDEtMTAgMDY6NTY6MDcu NDczIFVUQyBbNDMzMV0gU1RBVEVNRU5UOiBJTlNFUlQgSU5UTyBlbWFpbF9zdGF0cyAoaWQsCnVz ZXJfaWQsIGRhdGUsIGNvdW50KSBWQUxVRVMgKCcyMDI0LTAxLTAxXzEnLCAxLCAnMjAyNC0wMS0w MScsIDEpIE9OCkNPTkZMSUNUIChpZCkgRE8gVVBEQVRFIFNFVCBjb3VudCA9IGVtYWlsX3N0YXRz LmNvdW50ICsgMTsNCjIwMjQtMDEtMTAgMDY6NTY6MDcuNjQ1IFVUQyBbNDU0Ml0gRVJST1I6IDIz NTA1OiBkdXBsaWNhdGUga2V5IHZhbHVlCnZpb2xhdGVzIHVuaXF1ZSBjb25zdHJhaW50ICJ1c2Vy X2lkX2RhdGUiDQoyMDI0LTAxLTEwIDA2OjU2OjA3LjY0NSBVVEMgWzQ1NDJdIERFVEFJTDogS2V5 ICh1c2VyX2lkLCBkYXRlKT0oMSwKMjAyNC0wMS0wMSkgYWxyZWFkeSBleGlzdHMuDQoyMDI0LTAx LTEwIDA2OjU2OjA3LjY0NSBVVEMgWzQ1NDJdIExPQ0FUSU9OOiBfYnRfY2hlY2tfdW5pcXVlLApu YnRpbnNlcnQuYzo2NjYNCjIwMjQtMDEtMTAgMDY6NTY6MDcuNjQ1IFVUQyBbNDU0Ml0gU1RBVEVN RU5UOiBJTlNFUlQgSU5UTyBlbWFpbF9zdGF0cyAoaWQsCnVzZXJfaWQsIGRhdGUsIGNvdW50KSBW QUxVRVMgKCcyMDI0LTAxLTAxXzEnLCAxLCAnMjAyNC0wMS0wMScsIDEpIE9OCkNPTkZMSUNUIChp ZCkgRE8gVVBEQVRFIFNFVCBjb3VudCA9IGVtYWlsX3N0YXRzLmNvdW50ICsgMTsNCjIwMjQtMDEt MTAgMDY6NTY6MTEuMzQ2IFVUQyBbNTA2NF0gRVJST1I6IDQwUDAxOiBkZWFkbG9jayBkZXRlY3Rl ZA0KMjAyNC0wMS0xMCAwNjo1NjoxMS4zNDYgVVRDIFs1MDY0XSBERVRBSUw6IFByb2Nlc3MgNTA2 NCB3YWl0cyBmb3IgU2hhcmVMb2NrCm9uIHRyYW5zYWN0aW9uIDY1MjA7IGJsb2NrZWQgYnkgcHJv Y2VzcyA1Mjc3Lg0KUHJvY2VzcyA1Mjc3IHdhaXRzIGZvciBTaGFyZUxvY2sgb24gc3BlY3VsYXRp dmUgdG9rZW4gMSBvZiB0cmFuc2FjdGlvbiA2Mzg2OwpibG9ja2VkIGJ5IHByb2Nlc3MgNTA2NC4N ClByb2Nlc3MgNTA2NDogSU5TRVJUIElOVE8gZW1haWxfc3RhdHMgKGlkLCB1c2VyX2lkLCBkYXRl LCBjb3VudCkgVkFMVUVTCignMjAyNC0wMS0wMV8xJywgMSwgJzIwMjQtMDEtMDEnLCAxKSBPTiBD T05GTElDVCAoaWQpIERPIFVQREFURSBTRVQgY291bnQgPQplbWFpbF9zdGF0cy5jb3VudCArIDE7 DQpQcm9jZXNzIDUyNzc6IElOU0VSVCBJTlRPIGVtYWlsX3N0YXRzIChpZCwgdXNlcl9pZCwgZGF0 ZSwgY291bnQpIFZBTFVFUwooJzIwMjQtMDEtMDFfMScsIDEsICcyMDI0LTAxLTAxJywgMSkgT04g Q09ORkxJQ1QgKGlkKSBETyBVUERBVEUgU0VUIGNvdW50ID0KZW1haWxfc3RhdHMuY291bnQgKyAx Ow0KMjAyNC0wMS0xMCAwNjo1NjoxMS4zNDYgVVRDIFs1MDY0XSBISU5UOiBTZWUgc2VydmVyIGxv ZyBmb3IgcXVlcnkgZGV0YWlscy4NCjIwMjQtMDEtMTAgMDY6NTY6MTEuMzQ2IFVUQyBbNTA2NF0g Q09OVEVYVDogd2hpbGUgaW5zZXJ0aW5nIGluZGV4IHR1cGxlCigzNCwzKSBpbiByZWxhdGlvbiAi dXNlcl9pZF9kYXRlIg0KMjAyNC0wMS0xMCAwNjo1NjoxMS4zNDYgVVRDIFs1MDY0XSBMT0NBVElP TjogRGVhZExvY2tSZXBvcnQsCmRlYWRsb2NrLmM6MTEzMA0KMjAyNC0wMS0xMCAwNjo1NjoxMS4z NDYgVVRDIFs1MDY0XSBTVEFURU1FTlQ6IElOU0VSVCBJTlRPIGVtYWlsX3N0YXRzIChpZCwKdXNl cl9pZCwgZGF0ZSwgY291bnQpIFZBTFVFUyAoJzIwMjQtMDEtMDFfMScsIDEsICcyMDI0LTAxLTAx JywgMSkgT04KQ09ORkxJQ1QgKGlkKSBETyBVUERBVEUgU0VUIGNvdW50ID0gZW1haWxfc3RhdHMu Y291bnQgKyAxOw0KYGBgCgo= --===============4020446352917757201==--