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 1svWd4-00FhUs-OB for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2024 06:45:03 +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 1svWd2-00Bdza-3C for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2024 06:45:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svWd1-00BdzR-OT for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2024 06:44:59 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svWcz-001usq-0D for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2024 06:44:58 +0000 Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1svWcx-0061lI-SU for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2024 06:44:56 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1svWcw-001gQv-Q9 for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2024 06:44:55 +0000 Content-Type: multipart/mixed; boundary="===============2686693635550333820==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix race condition in COMMIT PREPARED causing orphaned 2PC files X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 01 Oct 2024 06:44:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2686693635550333820== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJhY2UgY29uZGl0aW9uIGluIENPTU1JVCBQUkVQQVJFRCBjYXVzaW5nIG9ycGhhbmVkIDJQ QyBmaWxlcwoKQ09NTUlUIFBSRVBBUkVEIHJlbW92ZXMgb24tZGlzayAyUEMgZmlsZXMgbmVhciBp dHMgZW5kLCBidXQgdGhlIHN0YXRlCmNoZWNrZWQgaWYgYSBmaWxlIGlzIG9uLWRpc2sgb3Igbm90 IGdldHMgcmVhZCBmcm9tIHNoYXJlZCBtZW1vcnkgd2hpbGUKbm90IGhvbGRpbmcgdGhlIHR3by1w aGFzZSBzdGF0ZSBsb2NrLgoKQmVjYXVzZSBvZiB0aGF0LCB0aGVyZSB3YXMgYSBzbWFsbCB3aW5k b3cgd2hlcmUgYSBzZWNvbmQgYmFja2VuZCBkb2luZyBhClBSRVBBUkUgVFJBTlNBQ1RJT04gY291 bGQgcmV1c2UgdGhlIEdsb2JhbFRyYW5zYWN0aW9uIHB1dCBiYWNrIGludG8gdGhlCjJQQyBmcmVl IGxpc3QgYnkgdGhlIENPTU1JVCBQUkVQQVJFRCwgb3ZlcndyaXRpbmcgdGhlICJvbmRpc2siIGZs YWcgcmVhZAphZnRlcndhcmRzIGJ5IHRoZSBDT01NSVQgUFJFUEFSRUQgdG8gZGVjaWRlIGlmIGl0 cyBvbi1kaXNrIHR3by1waGFzZQpzdGF0ZSBmaWxlIHNob3VsZCBiZSByZW1vdmVkLCBwcmV2ZW50 aW5nIHRoZSBmaWxlIGRlbGV0aW9uLgoKVGhpcyBjb21taXQgZml4ZXMgdGhpcyBpc3N1ZSBzbyBh cyB0aGUgIm9uZGlzayIgZmxhZyBpbiB0aGUKR2xvYmFsVHJhbnNhY3Rpb24gaXMgcmVhZCB3aGls ZSBob2xkaW5nIHRoZSB0d28tcGhhc2Ugc3RhdGUgbG9jaywgbm90CmZyb20gc2hhcmVkIG1lbW9y eSBhZnRlciBpdHMgZW50cnkgaGFzIGJlZW4gYWRkZWQgdG8gdGhlIGZyZWUgbGlzdC4KCk9ycGhh bmVkIHR3by1waGFzZSBzdGF0ZSBmaWxlcyBmbHVzaGVkIHRvIGRpc2sgYWZ0ZXIgYSBjaGVja3Bv aW50IGFyZQpkaXNjYXJkZWQgYXQgdGhlIGJlZ2lubmluZyBvZiByZWNvdmVyeS4gIEhvd2V2ZXIs IGEgdHJ1bmNhdGlvbiBvZgpwZ194YWN0LyB3b3VsZCBtYWtlIHRoZSBzdGFydHVwIHByb2Nlc3Mg aXNzdWUgYSBGQVRBTCB3aGVuIGl0IGNhbm5vdApyZWFkIHRoZSBTTFJVIHBhZ2UgaG9sZGluZyB0 aGUgc3RhdGUgb2YgdGhlIHRyYW5zYWN0aW9uIHdob3NlIDJQQyBmaWxlCndhcyBvcnBoYW5lZCwg d2hpY2ggaXMgYSBuZWNlc3Nhcnkgc3RlcCB0byBkZWNpZGUgaWYgdGhlIDJQQyBmaWxlIHNob3Vs ZApiZSByZW1vdmVkIG9yIG5vdC4gIFJlbW92aW5nIG1hbnVhbGx5IHRoZSBmaWxlIHdvdWxkIGJl IG5lY2Vzc2FyeSBpbgp0aGlzIGNhc2UuCgpJc3N1ZSBpbnRyb2R1Y2VkIGJ5IGVmZmU3ZDk1NTJk ZCwgc28gYmFja3BhdGNoIGFsbCB0aGUgd2F5IGRvd24uCgpNZWEgY3VscGEuCgpBdXRob3I6IHd1 Y2hlbmd3ZW4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS90ZW5jZW50X0E3RjA1OUI1 MTM2QTM1OTYyNUM3QjJFNEEzODZCM0MzRjAwN0BxcS5jb20KQmFja3BhdGNoLXRocm91Z2g6IDEy CgpCcmFuY2gKLS0tLS0tClJFTF8xM19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzdiZmFhNDY3MTkzY2NiOWVmMTdiYTQxMjc3 ZGM4OTg1YzNjOTAxNmQKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5k L2FjY2Vzcy90cmFuc2FtL3R3b3BoYXNlLmMgfCA5ICsrKysrKysrLQoxIGZpbGUgY2hhbmdlZCwg OCBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgo= --===============2686693635550333820==--