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 1tS2O4-00DTkW-MQ for pgsql-committers@arkaria.postgresql.org; Sun, 29 Dec 2024 23:07:57 +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 1tS2O3-008Nav-Gp for pgsql-committers@arkaria.postgresql.org; Sun, 29 Dec 2024 23:07:55 +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 1tS2O3-008Nab-9H for pgsql-committers@lists.postgresql.org; Sun, 29 Dec 2024 23:07:55 +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.96) (envelope-from ) id 1tS2O0-001AFg-1L for pgsql-committers@lists.postgresql.org; Sun, 29 Dec 2024 23:07:53 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::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 1tS2Ny-006ZyA-Uy for pgsql-committers@lists.postgresql.org; Sun, 29 Dec 2024 23:07:51 +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 1tS2Ny-002139-8t for pgsql-committers@lists.postgresql.org; Sun, 29 Dec 2024 23:07:50 +0000 Content-Type: multipart/mixed; boundary="===============0536500160635520191==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix handling of orphaned 2PC files in the future at recovery X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 29 Dec 2024 23:07:50 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0536500160635520191== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGhhbmRsaW5nIG9mIG9ycGhhbmVkIDJQQyBmaWxlcyBpbiB0aGUgZnV0dXJlIGF0IHJlY292 ZXJ5CgpCZWZvcmUgNzI4YmQ5OTFjM2M0LCB0aGF0IGhhcyBpbXByb3ZlZCB0aGUgc3VwcG9ydCBm b3IgMlBDIGZpbGVzIGR1cmluZwpyZWNvdmVyeSwgdGhlIGluaXRpYWwgbG9naWMgc2Nhbm5pbmcg ZmlsZXMgaW4gcGdfdHdvcGhhc2Ugd2FzIGRvbmUgc28gYXMKZmlsZXMgaW4gdGhlIGZ1dHVyZSBv ZiB0aGUgdHJhbnNhY3Rpb24gSUQgaG9yaXpvbiB3ZXJlIGNoZWNrZWQgZmlyc3QsCmZvbGxvd2Vk IGJ5IGEgY2hlY2sgaWYgYSB0cmFuc2FjdGlvbiBJRCBpcyBhYm9ydGVkIG9yIGNvbW1pdHRlZCB3 aGljaApjb3VsZCBpbnZvbHZlIGEgcGdfeGFjdCBsb29rdXAuICBBZnRlciB0aGlzIGNvbW1pdCwg dGhlc2UgY2hlY2tzIGhhdmUKYmVlbiBkb25lIGluIHJldmVyc2Ugb3JkZXIuCgpGaWxlcyBkZXRl Y3RlZCBhcyBpbiB0aGUgZnV0dXJlIGRvIG5vdCBoYXZlIGEgc3RhdGUgdGhhdCBjYW4gYmUgY2hl Y2tlZAppbiBwZ194YWN0LCBoZW5jZSB0aGlzIGNhdXNlZCByZWNvdmVyeSB0byBmYWlsIGFicnVw dGx5IHNob3VsZCBhbgpvcnBoYW5lZCAyUEMgZmlsZSBpbiB0aGUgZnV0dXJlIG9mIHRoZSB0cmFu c2FjdGlvbiBJRCBob3Jpem9uIGV4aXN0IGluCnBnX3R3b3BoYXNlIGF0IHRoZSBiZWdpbm5pbmcg b2YgcmVjb3ZlcnkuCgpBIHRlc3QgaXMgYWRkZWQgdG8gY2hlY2sgZm9yIHRoaXMgc2NlbmFyaW8s IHVzaW5nIGFuIGVtcHR5IDJQQyB3aXRoIGEKdHJhbnNhY3Rpb24gSUQgbGFyZ2UgZW5vdWdoIHRv IGJlIGluIHRoZSBmdXR1cmUgd2hlbiBydW5uaW5nIHRoZSB0ZXN0LgpUaGlzIHRlc3QgaXMgYWRk ZWQgaW4gMTYgYW5kIG9sZGVyIHZlcnNpb25zIGZvciBub3cuICAxNyBhbmQgbmV3ZXIKdmVyc2lv bnMgYXJlIGltcGFjdGVkIGJ5IGEgc2Vjb25kIGJ1ZyBjYXVzZWQgYnkgdGhlIGFkZGl0aW9uIG9m IHRoZQplcG9jaCBpbiB0aGUgMlBDIGZpbGUgbmFtZXMuICBBbiBlcXVpdmFsZW50IHRlc3Qgd2ls bCBiZSBhZGRlZCBpbiB0aGVzZQpicmFuY2hlcyBpbiBhIGZvbGxvdy11cCBjb21taXQsIG9uY2Ug dGhlIHNlY29uZCBzZXQgb2YgaXNzdWVzIHJlcG9ydGVkCmFyZSBmaXhlZC4KCkF1dGhvcjogVml0 YWx5IERhdnlkb3YsIE1pY2hhZWwgUGFxdWllcgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tLzExZTU5Ny02NzZhYjY4MC04ZC0zNzRmMjNjMEAxNDU0NjYxMjkKQmFja3BhdGNoLXRocm91 Z2g6IDEzCgpCcmFuY2gKLS0tLS0tClJFTF8xM19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRw czovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzhmNjdmOTk0ZThlYTZlZjEzNjE5 ZjFlYzQ5YjE1MWY4YWViZjYzMTYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9i YWNrZW5kL2FjY2Vzcy90cmFuc2FtL3R3b3BoYXNlLmMgfCAxNiArKysrKysrKy0tLS0tLS0tCjEg ZmlsZSBjaGFuZ2VkLCA4IGluc2VydGlvbnMoKyksIDggZGVsZXRpb25zKC0pCgo= --===============0536500160635520191==--