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.96) (envelope-from ) id 1x5UQZ-0006SL-1O for pgsql-committers@arkaria.postgresql.org; Sat, 12 Sep 2026 20:34:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x5UQY-003NNt-2S for pgsql-committers@arkaria.postgresql.org; Sat, 12 Sep 2026 20:34:22 +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.96) (envelope-from ) id 1x5UNC-003K7V-0N for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:54 +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.98.2) (envelope-from ) id 1x5UN8-000000005co-31Pg for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=VB2HCgHm0MHxY26VmAeOprMdheptiKyRb6Yb5vLLK2Y=; b=RhnNVUOSk5B8P/o+Ob2vTuSvEN 3XijH8DKZ49VNhHkcK41SVBTBjiO5aohe6wvJs5ogNvtZ59Y7QrcdTOYaTXjlYyPxiz0Z03s4z1W/ sgOiioLuDnx0Fl/skD3ZYvviFzLXbJ+LOD9pBs30iX2L1zsMAK94dgi1C4wqaEkWtgi50bU5PYMT/ s7t98ILWXNuoi79T96n76fa32SepQZB8pqLIqN++49OLmnccPP9cjqAVn2/+pln26mv4f0S3wDCRH gBRAdc95a5iKzyvs6luZ3rTbQWDW2PM4HIiqyZk7+784+2wsmTJfBZprSTdjUxVDDeheyUmFW/nP0 DGpRQpBg==; 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.96) (envelope-from ) id 1x5UN8-000Cl2-0h for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:50 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x5UN8-000000003rY-0U6w for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:50 +0000 Content-Type: multipart/mixed; boundary="===============4541248978589964294==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Prevent WAIT FOR LSN from deadlocking recovery on held locks X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 12 Sep 2026 20:30:50 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4541248978589964294== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UHJldmVudCBXQUlUIEZPUiBMU04gZnJvbSBkZWFkbG9ja2luZyByZWNvdmVyeSBvbiBoZWxkIGxv Y2tzCgpBIGJhY2tlbmQgd2FpdGluZyBmb3IgV0FMIHJlcGxheSBjYW4gcmV0YWluIGxvY2tzIGFj cXVpcmVkIGJ5IGVhcmxpZXIKc3RhdGVtZW50cy4gIElmIHRoZSBzdGFydHVwIHByb2Nlc3MgbmVl ZHMgb25lIG9mIHRob3NlIGxvY2tzLCBkaXJlY3RseSBvcgp0aHJvdWdoIGFub3RoZXIgYmFja2Vu ZCwgYmVmb3JlIHJlYWNoaW5nIHRoZSB0YXJnZXQgTFNOLCBhIGRlYWRsb2NrIGNhbgphcmlzZTog c3RhcnR1cCB3YWl0cyBmb3IgdGhlIGJhY2tlbmQgdG8gcmVsZWFzZSB0aGUgbG9jaywgd2hpbGUg dGhlIGJhY2tlbmQKd2FpdHMgZm9yIHN0YXJ0dXAgdG8gYWR2YW5jZSByZXBsYXkuICBUaGUgbG9j ayBtYW5hZ2VyIHJlY29yZHMgdGhlCmJhY2tlbmQncyBoZWxkIGxvY2tzLCBidXQgV0FJVCBGT1Ig TFNOIGRvZXMgbm90IHJlZ2lzdGVyIGl0cyBkZXBlbmRlbmN5IG9uCnJlcGxheSBhcyBhIGxvY2sg d2FpdC4gIFRoZSBkZWFkbG9jayBkZXRlY3RvciB0aGVyZWZvcmUgY2Fubm90IHNlZSB0aGUKY29t cGxldGUgY3ljbGUuICBXaXRoIHVubGltaXRlZCBzdGFuZGJ5IGNvbmZsaWN0IGRlbGF5cyBhbmQg bm8gb3RoZXIKdGltZW91dCBvciBjYW5jZWxsYXRpb24sIHRoaXMgZGVhZGxvY2sgY2FuIHBlcnNp c3QgaW5kZWZpbml0ZWx5LgoKV3JpdGUgYW5kIGZsdXNoIHdhaXRzIGFyZSByZXN0cmljdGVkIGFz IHdlbGwuICBUaGVpciBwb3NpdGlvbnMgYXJlIGZsb29yZWQKYnkgdGhlIHJlcGxheSBwb3NpdGlv biwgc28gd2l0aG91dCBhbiBhY3RpdmUgd2FscmVjZWl2ZXIgdGhlIHN0YXJ0dXAKcHJvY2VzcyBj YW4gYmUgdGhlaXIgb25seSBzb3VyY2Ugb2YgcHJvZ3Jlc3MuICBJZiBhIGhlbGQgbG9jayBibG9j a3MKcmVwbGF5LCB0aGVzZSB3YWl0cyBjYW4gZm9ybSB0aGUgc2FtZSBjeWNsZTogdGhlIGJhY2tl bmQgd2FpdHMgZm9yIHJlcGxheQp0byBhZHZhbmNlLCB3aGlsZSByZXBsYXkgd2FpdHMgZm9yIHRo ZSBiYWNrZW5kIHRvIHJlbGVhc2UgdGhlIGxvY2suCgpTdHJlYW1pbmcgZG9lcyBhZHZhbmNlIHRo ZW0gaW5kZXBlbmRlbnRseSwgYnV0IG9ubHkgd2hpbGUgV0FMIGtlZXBzCmFycml2aW5nLiAgSWYg cmVjZXB0aW9uIHN0b3BzIGJlZm9yZSB0aGUgdGFyZ2V0IGlzIHJlYWNoZWQsIGEgYmxvY2tlZApz dGFydHVwIHByb2Nlc3MgY2Fubm90IHJlc3RhcnQgdGhlIHdhbHJlY2VpdmVyLiAgSXQgYWxzbyBj YW5ub3QgcmVwbGF5Cm5ld2VyIGNoZWNrcG9pbnQgcmVjb3JkcyBuZWVkZWQgdG8gYWR2YW5jZSBy ZXN0YXJ0cG9pbnRzIGFuZCByZWN5Y2xlIFdBTCwKc28gY29udGludWVkIHJlY2VwdGlvbiBjYW4g ZXhoYXVzdCBhdmFpbGFibGUgc3BhY2UgaW4gcGdfd2FsIGJlZm9yZSB0aGUKdGFyZ2V0IGlzIHJl YWNoZWQuICBBbiBhY3RpdmUgcmVjZWl2ZXIgYXQgdGhlIHN0YXJ0IG9mIHRoZSB3YWl0IHRoZXJl Zm9yZQpkb2VzIG5vdCBndWFyYW50ZWUgdGhhdCB0aGUgd2FpdCBjYW4gZmluaXNoIHdoaWxlIHJl cGxheSByZW1haW5zIGJsb2NrZWQuCgpSZWplY3QgYW4gdW5zYXRpc2ZpZWQgc3RhbmRieV9yZXBs YXksIHN0YW5kYnlfd3JpdGUsIG9yIHN0YW5kYnlfZmx1c2ggd2FpdAp3aGlsZSByZWNvdmVyeSBp cyBhY3RpdmUgd2hlbiB0aGUgYmFja2VuZCBhbHJlYWR5IGhvbGRzIGEgZ3JhbnRlZApoZWF2eXdl aWdodCBsb2NrLiAgVGhpcyBjb25zZXJ2YXRpdmUgcmVzdHJpY3Rpb24gY292ZXJzIGRpcmVjdApy ZWxhdGlvbi1sb2NrIGN5Y2xlcyBhbmQgaW5kaXJlY3QgY3ljbGVzIGludm9sdmluZyBhZHZpc29y eSBsb2Nrcy4gIEl0CmFsc28gcmVqZWN0cyBzb21lIHdyaXRlIGFuZCBmbHVzaCB3YWl0cyB0aGF0 IGFuIGFjdGl2ZSByZWNlaXZlciBjb3VsZApzYXRpc2Z5LiAgUmVxdWVzdHMgd2hvc2UgdGFyZ2V0 IGlzIG9ic2VydmVkIGFzIGFscmVhZHkgcmVhY2hlZCBhcmUgZXhlbXB0CmZyb20gdGhpcyBjaGVj aywgYXMgYXJlIHByaW1hcnlfZmx1c2ggcmVxdWVzdHMgYW5kIHJlcXVlc3RzIGlzc3VlZCBhZnRl cgpyZWNvdmVyeSBoYXMgZW5kZWQuICBFeGlzdGluZyBzbmFwc2hvdCBhbmQgcmVjb3Zlcnktc3Rh dGUgY2hlY2tzIHN0aWxsCmFwcGx5LgoKUmVwb3J0IG9uZSBvZiB0aGUgaGVsZCBsb2NrcyBzbyB0 aGUgdXNlciBjYW4gZmluZCBpdCwgdXNpbmcgdGhlIHNhbWUKZGVzY3JpcHRpb24gdGhlIGRlYWRs b2NrIHJlcG9ydCB1c2VzLgoKQWRkIHJlcGxheS1tb2RlIHRlc3RzIGZvciByZWxhdGlvbiBhbmQg YWR2aXNvcnkgbG9ja3MgYW5kIGZvciB0aGUKYWxyZWFkeS1yZWFjaGVkIGNhc2UsIGFuZCBkb2N1 bWVudCB0aGUgcmVzdHJpY3Rpb24gYWxvbmcgd2l0aCB0aGUKcmVjb21tZW5kZWQgdXNhZ2UgcGF0 dGVybi4KCkF1dGhvcjogWHVuZW5nIFpob3UgPHh1bmVuZ3pob3VAZ21haWwuY29tPgpEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQlBURjdVMGdXNSUyQi00b0w3LXFkTUwteWVyWnhV YjdrdTRRWHA3SnhDWW8wcXlKX1R3JTQwbWFpbC5nbWFpbC5jb20KUmV2aWV3ZWQtYnk6IEFsZXhh bmRlciBLb3JvdGtvdiA8YWVrb3JvdGtvdkBnbWFpbC5jb20+CkJhY2twYXRjaC10aHJvdWdoOiAx OQoKQnJhbmNoCi0tLS0tLQpSRUxfMTlfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9n aXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mN2MwOTI5MTcwYTM3MGY4MjI5ZTY2ZjU0 ZWE3Mzk2NDQxZWZhYWYxCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3Nn bWwvcmVmL3dhaXRfZm9yLnNnbWwgICAgICAgICAgfCA0MCArKysrKysrKysrKysrKysrKysrKysr KysKc3JjL2JhY2tlbmQvY29tbWFuZHMvd2FpdC5jICAgICAgICAgICAgIHwgNTUgKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrKysrCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1nci9sb2NrLmMg ICAgICAgICB8IDMyICsrKysrKysrKysrKysrKysrKysKc3JjL2luY2x1ZGUvc3RvcmFnZS9sb2Nr LmggICAgICAgICAgICAgIHwgIDEgKwpzcmMvdGVzdC9yZWNvdmVyeS90LzA0OV93YWl0X2Zvcl9s c24ucGwgfCAzNiArKysrKysrKysrKysrKysrKysrKysKNSBmaWxlcyBjaGFuZ2VkLCAxNjQgaW5z ZXJ0aW9ucygrKQoK --===============4541248978589964294==--