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 1x5UN9-0006Py-0z for pgsql-committers@arkaria.postgresql.org; Sat, 12 Sep 2026 20:30:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x5UN7-003JnQ-1m for pgsql-committers@arkaria.postgresql.org; Sat, 12 Sep 2026 20:30:49 +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 1x5UN7-003Jmy-17 for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:49 +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 1x5UN3-000000005cT-3Wkv for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:49 +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=igCugg2Y2JdCyuKnT2PY/GGoEvjqN88ZahDKNvTjZk0=; b=zOeITpMq/zhr6tNfqRhwNZg+pP jZfGq/rBsMLvepY3bbmC6b+9/zltRv9PfPu/2qMn5Sfa9bjA5G/YX6jFYPLNJLkPIl3Vv51sDMhlU lteidk0/M1vbRpwmhQXum0BO2lUTpBFDslBM/7UGqHEUzK11U//H/lmZyzQWNV/VPeldCfbindHS4 jmTiQyZear9loeaZG5yvPUDU9ut4gMCr6Q1rlBXdaOkhVNy6awoOanoKvdR7UcHZSdrotYozvJ2kH lai4FO3ueTeqoSmz6RL2A87hSn9XJ2n8dcMKBT4uay2/Cwuw7rKgxIIVFyxWcgZf71LGGV7kxBPNA CfVLZV4g==; 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 1x5UN3-000Ckf-0X for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:45 +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 1x5UN2-000000003qo-44wf for pgsql-committers@lists.postgresql.org; Sat, 12 Sep 2026 20:30:44 +0000 Content-Type: multipart/mixed; boundary="===============1942082790616617995==" 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:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1942082790616617995== 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 OQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2UwYzE2MGMzMDcyNjQ2NTRhMmU5MWQ1ODJjYzA5MzUy NDNiYzkyNTMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9yZWYv d2FpdF9mb3Iuc2dtbCAgICAgICAgICB8IDQwICsrKysrKysrKysrKysrKysrKysrKysrKwpzcmMv YmFja2VuZC9jb21tYW5kcy93YWl0LmMgICAgICAgICAgICAgfCA1NSArKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvc3RvcmFnZS9sbWdyL2xvY2suYyAgICAgICAg IHwgMzIgKysrKysrKysrKysrKysrKysrKwpzcmMvaW5jbHVkZS9zdG9yYWdlL2xvY2suaCAgICAg ICAgICAgICAgfCAgMSArCnNyYy90ZXN0L3JlY292ZXJ5L3QvMDQ5X3dhaXRfZm9yX2xzbi5wbCB8 IDM2ICsrKysrKysrKysrKysrKysrKysrKwo1IGZpbGVzIGNoYW5nZWQsIDE2NCBpbnNlcnRpb25z KCspCgo= --===============1942082790616617995==--