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 1o57eg-00069g-BW for pgsql-bugs@arkaria.postgresql.org; Sat, 25 Jun 2022 15:25:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o57ee-0001At-FP for pgsql-bugs@arkaria.postgresql.org; Sat, 25 Jun 2022 15:25:00 +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 1o57MT-0002xl-Uw for pgsql-bugs@lists.postgresql.org; Sat, 25 Jun 2022 15:06:14 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o57MM-0000My-EQ for pgsql-bugs@lists.postgresql.org; Sat, 25 Jun 2022 15:06: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=bCwT/2SgtphLD+QQgx6K+/+YWfNF1Nle7RXu5TsRLTs=; b=HmNMhdoauY876Uvp0q29qFNw39 ahy4hOR/WFo2YT7zvvLBd68lZMnx+3HT66uT4HfQmmJAo0p+OaizaYW/VMfRzPZyfEOEjGTC8f/YT ReuM1vN4RwUH7xVRKEV0dS7iMx+3JGMEZ1T+EPCP124yCwecBrNUEFlE+h3WBRcdP3S0R5a1PkPP9 FHXamI0Jjsv35kg+MdseoI0mKfFTQ91rD4i0fREZTsW98APAC2wLvkzSCpxBYqi4gSJl/SvsURPbS S3+HUfPohGFRCIEe4G17U5fH44VNpbPKk2BO91E3mjB8AyfajzH5AHzErgR/5srnX1lPsAC3hxHp9 qItJOwHQ==; 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 1o57ML-0008G0-H2 for pgsql-bugs@lists.postgresql.org; Sat, 25 Jun 2022 15:06:05 +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 1o57MJ-006jYa-D4 for pgsql-bugs@lists.postgresql.org; Sat, 25 Jun 2022 15:06:02 +0000 Content-Type: multipart/mixed; boundary="===============6616600952176134071==" MIME-Version: 1.0 Subject: BUG #17532: Prepared statements and insert on conflict can fail on the 6th execution To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jack@jackchristensen.com Reply-To: jack@jackchristensen.com, pgsql-bugs@lists.postgresql.org Date: Sat, 25 Jun 2022 15:05:17 +0000 Message-ID: <17532-ac78c042223fcdbf@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 --===============6616600952176134071== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzUzMgpMb2dnZWQgYnk6ICAgICAgICAgIEphY2sgQ2hyaXN0ZW5zZW4K RW1haWwgYWRkcmVzczogICAgICBqYWNrQGphY2tjaHJpc3RlbnNlbi5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxNC40Ck9wZXJhdGluZyBzeXN0ZW06ICAgTWFjT1MKRGVzY3JpcHRpb246ICAgICAg ICAKCkEgdXNlciBvZiB0aGUgR28gZHJpdmVyIHBneCByZXBvcnRlZCBhIHN0cmFuZ2UgYnVnCiho dHRwczovL2dpdGh1Yi5jb20vamFja2MvcGd4L2lzc3Vlcy8xMjM0KS4gQWZ0ZXIgaW52ZXN0aWdh dGluZyB0aGUgaXNzdWUgSQp3YXMgYWJsZSB0byBkdXBsaWNhdGUgaXQgaW4gZGlyZWN0bHkgaW4g cHNxbC4gVGhlIHByb2JsZW0gb2NjdXJzIHdoZW4gYQpwcmVwYXJlZCBzdGF0ZW1lbnQgaGFzIGFu IElOU0VSVCAuLi4gT04gQ09ORkxJQ1QuIFRoZSBzdGF0ZW1lbnQgd29ya3MgdGhlCmZpcnN0IDUg dGltZXMgYW5kIGZhaWxzIG9uIHRoZSA2dGggdGltZSB3aXRoIEVSUk9SOiAgdGhlcmUgaXMgbm8g dW5pcXVlIG9yCmV4Y2x1c2lvbiBjb25zdHJhaW50IG1hdGNoaW5nIHRoZSBPTiBDT05GTElDVCBz cGVjaWZpY2F0aW9uLiBJIHdvdWxkIGd1ZXNzCnRoaXMgaGFzIHRvIGRvIHdpdGggdGhlIHBsYW5u ZXIgY2hvb3NpbmcgYSBnZW5lcmljIG9yIGN1c3RvbSBwbGFuLg0KDQpIZXJlIGlzIHRoZSByZXBy b2R1Y3Rpb24gY2FzZToNCg0KQ1JFQVRFIFRZUEUgcHJvbW9fcmVhc29uIEFTIEVOVU0gKCdwcm9t b19yZWFzb24nKTsNCkNSRUFURSBUWVBFIHByb21vX3R5cGUgQVMgRU5VTSAoJ3Byb21vX3R5cGUn KTsNCg0KQ1JFQVRFIFRBQkxFIHByb21vcw0KKA0KcHJvbW9faWQgICAgVVVJRCAgICAgICAgIE5P VCBOVUxMIFBSSU1BUlkgS0VZLA0KdXNlcl9pZCAgICAgVVVJRCAgICAgICAgIE5PVCBOVUxMLA0K cmVhc29uICAgICAgcHJvbW9fcmVhc29uIE5PVCBOVUxMLA0KdHlwZSAgICAgICAgcHJvbW9fdHlw ZSAgIE5PVCBOVUxMDQopOw0KDQpDUkVBVEUgVU5JUVVFIElOREVYIHByb21vdGlvbnNfdXNlcl9p ZF9maXJzdF90cmFuc2Zlcl9rZXkgT04gcHJvbW9zCih1c2VyX2lkKQ0KV0hFUkUgdHlwZSA9ICdw cm9tb190eXBlJyBBTkQgcmVhc29uID0gJ3Byb21vX3JlYXNvbic7DQoNClBSRVBBUkUgcyBBUyBJ TlNFUlQgSU5UTyBwcm9tb3MNCiAgICAocHJvbW9faWQsIHVzZXJfaWQsIHJlYXNvbiwgdHlwZSkN ClZBTFVFUw0KICAgICgkMSwgJDIsICQzLCAkNCkNCk9OIENPTkZMSUNUICh1c2VyX2lkKSBXSEVS RSB0eXBlID0gJDQgQU5EIHJlYXNvbiA9ICQzDQpETyBOT1RISU5HOw0KDQpFWEVDVVRFIHMgKCcw MGViZDg5MC1mNWFjLTQ3YzctOTM2NS00Y2U5ODc1YzA0YTEnLAonMTMyYjY0ZTYtMWRjOS00NmNi LTkzNDktNWEwZDc0Njk2MjJiJywgJ3Byb21vX3JlYXNvbicsICdwcm9tb190eXBlJyk7DQpFWEVD VVRFIHMgKCc4ZTM3NzVkOS1hZjkwLTQ3MmYtOTcyMC1kMDM0MWZmN2JiYTcnLAonMTMyYjY0ZTYt MWRjOS00NmNiLTkzNDktNWEwZDc0Njk2MjJiJywgJ3Byb21vX3JlYXNvbicsICdwcm9tb190eXBl Jyk7DQpFWEVDVVRFIHMgKCdmOTgzZGIyNy02MmQ5LTRlZjEtYmM2Ny1lMWU0OTJlZWU0OGUnLAon MTMyYjY0ZTYtMWRjOS00NmNiLTkzNDktNWEwZDc0Njk2MjJiJywgJ3Byb21vX3JlYXNvbicsICdw cm9tb190eXBlJyk7DQpFWEVDVVRFIHMgKCcxMDUzMjA4MS04NTFjLTRkYzQtOWQ4My04NzUwYmQ0 Y2Y3OGQnLAonMTMyYjY0ZTYtMWRjOS00NmNiLTkzNDktNWEwZDc0Njk2MjJiJywgJ3Byb21vX3Jl YXNvbicsICdwcm9tb190eXBlJyk7DQpFWEVDVVRFIHMgKCc5OGUwNDllNC04NzYyLTRjOTUtYmU2 Yy0zMWY0ZDhmOWIwNGUnLAonMTMyYjY0ZTYtMWRjOS00NmNiLTkzNDktNWEwZDc0Njk2MjJiJywg J3Byb21vX3JlYXNvbicsICdwcm9tb190eXBlJyk7DQpFWEVDVVRFIHMgKCczNTU5NzJhYy0yMGE0 LTRjMTctYjI4ZC03MGQ4Y2IyZGQ1YjgnLAonMTMyYjY0ZTYtMWRjOS00NmNiLTkzNDktNWEwZDc0 Njk2MjJiJywgJ3Byb21vX3JlYXNvbicsICdwcm9tb190eXBlJyk7DQoNCkFuZCBoZXJlIGlzIHRo ZSBvdXRwdXQgSSBnZXQgd2hlbiBydW5uaW5nIGl0Og0KDQpDUkVBVEUgVFlQRQ0KQ1JFQVRFIFRZ UEUNCkNSRUFURSBUQUJMRQ0KQ1JFQVRFIElOREVYDQpQUkVQQVJFDQpJTlNFUlQgMCAxDQpJTlNF UlQgMCAwDQpJTlNFUlQgMCAwDQpJTlNFUlQgMCAwDQpJTlNFUlQgMCAwDQpwc3FsOnByZXBhcmVk X3N0YXRlbWVudF92c19vbl9jb25mbGljdF9idWcuc3FsOjI3OiBFUlJPUjogIHRoZXJlIGlzIG5v CnVuaXF1ZSBvciBleGNsdXNpb24gY29uc3RyYWludCBtYXRjaGluZyB0aGUgT04gQ09ORkxJQ1Qg c3BlY2lmaWNhdGlvbgoK --===============6616600952176134071==--