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 1vIPlb-0005T8-1i for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 11:08:58 +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 1vIPUO-00FxOZ-Hf for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 10:51:12 +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.94.2) (envelope-from ) id 1vIPUN-00FxOQ-RM for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 10:51:12 +0000 Received: from smtpbg154.qq.com ([15.184.224.54]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIPUC-006xxV-0Z for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 10:51:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1762771853; bh=0EEOIg47G+qwe+cAAgRB1JPZ4t6NYUdU/9Vce/zSxK8=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=YNP9helqCJgGrZ4K9M/iyloItxA5Jjd7NYE5260dsVgc5vKoMYJm/N1oyPYJCVKw0 JYd5U4cLZecmDLn+wcjmFz0LfAgu7UvyMaIVgWzPjAzmAUz6CPPeBkAHpNWMXnvgrF DDMO6PSzqZi42mj8fvG3C+TfLY2agPtWi1O0VgFI= EX-QQ-RecipientCnt: 2 X-QQ-GoodBg: 2 X-QQ-SSF: 00400000000000F0 X-QQ-FEAT: D4aqtcRDiqSyj8QHdV+zhWHYGKFFEYXoDJIY/5uHgzI= X-QQ-BUSINESS-ORIGIN: 2 X-QQ-Originating-IP: Qar1ArKqiab+a5vHfwVgxx2MZgM7N1puCly25j5MmZo= X-Originating-IP: 39.170.41.101 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1762771852tc546ec9a From: "=?gb18030?B?emVuZ21hbg==?=" To: "=?gb18030?B?1PjC+g==?=" , "=?gb18030?B?cGdzcWwtYnVncw==?=" Subject: Re:BUG #19107: The hold cursor is unexpectedly released during rollback Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_6911C38B_D4EE8DA0_1C3F6C3C" Content-Transfer-Encoding: 8Bit Date: Mon, 10 Nov 2025 18:50:51 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x References: <19107-656a10a7a066f7e9@postgresql.org> In-Reply-To: <19107-656a10a7a066f7e9@postgresql.org> X-QQ-ReplyHash: 3705634517 X-BIZMAIL-ID: 18247546588585704339 X-QQ-SENDSIZE: 520 Received: from qq.com (unknown [127.0.0.1]) by smtp.qq.com (ESMTP) with SMTP id ; Mon, 10 Nov 2025 18:50:52 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz3b-0 X-QQ-XMAILINFO: OSHVuk7uaqqGir78e2OMCRGDzy48XRWzhTx71jK8KQzanJb2whaWNPGt NuXWLpp/Reuwo4ioiyGzqN8WK1nN7rh6DfGymzc/F6SgUbORTxStFWn1HwnkckSBlIFlpHU WQxemQCExX1gyAHyc/u2d4N/BDcgnR+TRIHlA3juRQLmLyKKDevFAvXbajkiem5xa3FZDt0 Nr8vFOUhKLXMbxqxPEym1I7LRMtmLaYoOy+hRg6X3YFTBkRQqBWCq/UCpdkwql/KJT8Aqr0 DarRnUlfDvcaCWJnI4LzSWiygeo2UsbX9U6+kguZ6Anm6PKdqPvblkmeU+JMCBsrgoalfff p3PYT90+7T3hpr3ELal+xNugxSK5aQAFrqBxBzvbjtFoN5XVQxedh7qziA2e5kCjpDbwFIf DmL4o7HN5iUdvC9/oEqNbvJv23q/B0zPn9CqjSjRQCa+4zeZcArtaYl8pVD43TVJte1Wg99 +VqEgJkS03qJpteYcwYV7kBSGtj+wAMQBSbUocOPGbun9G9AqgeBD4/aHupy0aODRm3sx28 +O3GadgL9R6F1wnHfhZDoYo4GNeaFBRaQ3Kh09rBnFzMRnkNtA0yKcKVBfOO9G8HG5Pmm8r s+Z4xjAmVjOFIcUY3yLJ0VOJ9PggUyXgx1toLOemW9goRiw0I5BZXJKFw4MT0JZkrmhsLlw 1QSdY96r08Cbi1xYO1DKw1BflkFRz942Z5iTyifiz5Yb6E2eEVRQ5nHwZgiXgeCDJkMKGJi KrgRzD9H0qNYcTReSdlCv7AQCzSIawruIdDQCLpnlr5icqpMFaVxZYBkiM75kcOm+85QNJy SyAYZnnYkJ1p5q097uOayPXsMO2mZO2NoXH5W0RLOZ1DEtujPu+018ZtJLmf7YCwnGwojqS 8NVykBfb/VEosXejmVlpUm53aqCSPyFovsKC+s2y2AC7DJOKhNOfohR255lGQH7g20Q44k7 I+6E3u4SwB9a5VQw0luiIen8KJiEMD6E9mx9WHVgncgyd16aLJ20U/glXeLJBa3d9ikIKk1 L8LwxzkZHxeCTrsyny X-QQ-XMRINFO: NS+P29fieYNw95Bth2bWPxk= X-QQ-RECHKSPAM: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_6911C38B_D4EE8DA0_1C3F6C3C Content-Type: text/plain; charset="gb18030" Content-Transfer-Encoding: base64 SWYgdGhpcyBpcyBpbmRlZWQgYSBidWcsIGEgc2ltcGxlIHBhdGNoIGlzIGF0dGFjaGVkIHRv IGZpeCB0aGlzIGlzc3VlLg== ------=_NextPart_6911C38B_D4EE8DA0_1C3F6C3C Content-Type: application/octet-stream; charset="gb18030"; name="001_rollback_no_release_holdcursor.patch" Content-Disposition: attachment; filename="001_rollback_no_release_holdcursor.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL21tZ3IvcG9ydGFsbWVtLmMgYi9zcmMv YmFja2VuZC91dGlscy9tbWdyL3BvcnRhbG1lbS5jCmluZGV4IDk0M2RhMDg3YzlmLi4xNWQ1 ZmRmNDQ4ZCAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvbW1nci9wb3J0YWxtZW0u YworKysgYi9zcmMvYmFja2VuZC91dGlscy9tbWdyL3BvcnRhbG1lbS5jCkBAIC0xMjM4LDYg KzEyMzgsMTQgQEAgSG9sZFBpbm5lZFBvcnRhbHModm9pZCkKIAkJCUhvbGRQb3J0YWwocG9y dGFsKTsKIAkJCXBvcnRhbC0+YXV0b0hlbGQgPSB0cnVlOwogCQl9CisJCWVsc2UgaWYgKChw b3J0YWwtPmN1cnNvck9wdGlvbnMgJiBDVVJTT1JfT1BUX0hPTEQpICYmCisJCQkJICBwb3J0 YWwtPmNyZWF0ZVN1YmlkICE9IEludmFsaWRTdWJUcmFuc2FjdGlvbklkICYmCisJCQkJICBw b3J0YWwtPnN0YXR1cyA9PSBQT1JUQUxfUkVBRFkpCisJCXsKKwkJCS8qIElzIGl0IGEgaG9s ZGFibGUgcG9ydGFsIGNyZWF0ZWQgaW4gdGhlIGN1cnJlbnQgeGFjdD8gKi8KKwkJCUhvbGRQ b3J0YWwocG9ydGFsKTsKKwkJCXBvcnRhbC0+YXV0b0hlbGQgPSB0cnVlOworCQl9CiAJfQog fQogCmRpZmYgLS1naXQgYS9zcmMvcGwvcGxwZ3NxbC9zcmMvZXhwZWN0ZWQvcGxwZ3NxbF9z aW1wbGUub3V0IGIvc3JjL3BsL3BscGdzcWwvc3JjL2V4cGVjdGVkL3BscGdzcWxfc2ltcGxl Lm91dAppbmRleCBkYTM1MTg3M2U3NC4uM2E2MzQyYzNhYmQgMTAwNjQ0Ci0tLSBhL3NyYy9w bC9wbHBnc3FsL3NyYy9leHBlY3RlZC9wbHBnc3FsX3NpbXBsZS5vdXQKKysrIGIvc3JjL3Bs L3BscGdzcWwvc3JjL2V4cGVjdGVkL3BscGdzcWxfc2ltcGxlLm91dApAQCAtMTI5LDMgKzEy OSwzOSBAQCBiZWdpbgogIHJhaXNlIG5vdGljZSAndmFsID0gJScsIHZhbDsKIGVuZDsgJCQ7 CiBOT1RJQ0U6ICB2YWwgPSA0MgorLS0gVmVyaWZ5IHdoZXRoZXIgdGhlIGJlaGF2aW9yIG9m IHRoZSBob2xkIGN1cnNvciBpcyBjb25zaXN0ZW50IGR1cmluZyBjb21taXQgYW5kIHJvbGxi YWNrCitkbyAkJAorZGVjbGFyZQorICBwX0N1ckRhdGEgcmVmY3Vyc29yIDo9ICdob2xkX2N1 cnNvcic7CisgIHZhbCBpbnQ7CitiZWdpbgorICBleGVjdXRlICdERUNMQVJFIGhvbGRfY3Vy c29yIENVUlNPUiBXSVRIIEhPTEQgRk9SIFNFTEVDVCA0Mic7CisgIGxvb3AKKyAgICBmZXRj aCBwX0N1ckRhdGEgaW50byB2YWw7CisgICAgZXhpdCB3aGVuIHZhbCBpcyBudWxsOworICAg IHJhaXNlIG5vdGljZSAndmFsID0gJScsIHZhbDsKKyAgICBjb21taXQ7CisgIGVuZCBsb29w OworICBjbG9zZSBwX0N1ckRhdGE7CitlbmQ7ICQkOworTk9USUNFOiAgdmFsID0gNDIKK2Rv ICQkCitkZWNsYXJlCisgIHBfQ3VyRGF0YSByZWZjdXJzb3IgOj0gJ2hvbGRfY3Vyc29yJzsK KyAgdmFsIGludDsKK2JlZ2luCisgIGV4ZWN1dGUgJ0RFQ0xBUkUgaG9sZF9jdXJzb3IgQ1VS U09SIFdJVEggSE9MRCBGT1IgU0VMRUNUIDQyJzsKKyAgbG9vcAorICAgIGZldGNoIHBfQ3Vy RGF0YSBpbnRvIHZhbDsKKyAgICBleGl0IHdoZW4gdmFsIGlzIG51bGw7CisgICAgcmFpc2Ug bm90aWNlICd2YWwgPSAlJywgdmFsOworICAgIHJvbGxiYWNrOworICBlbmQgbG9vcDsKKyAg Y2xvc2UgcF9DdXJEYXRhOworZW5kOyAkJDsKK05PVElDRTogIHZhbCA9IDQyCitzZWxlY3Qg KiBmcm9tIHBnX2N1cnNvcnM7CisgbmFtZSB8IHN0YXRlbWVudCB8IGlzX2hvbGRhYmxlIHwg aXNfYmluYXJ5IHwgaXNfc2Nyb2xsYWJsZSB8IGNyZWF0aW9uX3RpbWUgCistLS0tLS0rLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tCisoMCByb3dzKQorCmRpZmYgLS1naXQgYS9zcmMvcGwvcGxwZ3NxbC9z cmMvc3FsL3BscGdzcWxfc2ltcGxlLnNxbCBiL3NyYy9wbC9wbHBnc3FsL3NyYy9zcWwvcGxw Z3NxbF9zaW1wbGUuc3FsCmluZGV4IDcyZDhhZmU0NTAwLi44OTg3MjFlYTk3YiAxMDA2NDQK LS0tIGEvc3JjL3BsL3BscGdzcWwvc3JjL3NxbC9wbHBnc3FsX3NpbXBsZS5zcWwKKysrIGIv c3JjL3BsL3BscGdzcWwvc3JjL3NxbC9wbHBnc3FsX3NpbXBsZS5zcWwKQEAgLTExNCwzICsx MTQsMzYgQEAgYmVnaW4KICBmZXRjaCBwX0N1ckRhdGEgaW50byB2YWw7CiAgcmFpc2Ugbm90 aWNlICd2YWwgPSAlJywgdmFsOwogZW5kOyAkJDsKKworLS0gVmVyaWZ5IHdoZXRoZXIgdGhl IGJlaGF2aW9yIG9mIHRoZSBob2xkIGN1cnNvciBpcyBjb25zaXN0ZW50IGR1cmluZyBjb21t aXQgYW5kIHJvbGxiYWNrCitkbyAkJAorZGVjbGFyZQorICBwX0N1ckRhdGEgcmVmY3Vyc29y IDo9ICdob2xkX2N1cnNvcic7CisgIHZhbCBpbnQ7CitiZWdpbgorICBleGVjdXRlICdERUNM QVJFIGhvbGRfY3Vyc29yIENVUlNPUiBXSVRIIEhPTEQgRk9SIFNFTEVDVCA0Mic7CisgIGxv b3AKKyAgICBmZXRjaCBwX0N1ckRhdGEgaW50byB2YWw7CisgICAgZXhpdCB3aGVuIHZhbCBp cyBudWxsOworICAgIHJhaXNlIG5vdGljZSAndmFsID0gJScsIHZhbDsKKyAgICBjb21taXQ7 CisgIGVuZCBsb29wOworICBjbG9zZSBwX0N1ckRhdGE7CitlbmQ7ICQkOworCitkbyAkJAor ZGVjbGFyZQorICBwX0N1ckRhdGEgcmVmY3Vyc29yIDo9ICdob2xkX2N1cnNvcic7CisgIHZh bCBpbnQ7CitiZWdpbgorICBleGVjdXRlICdERUNMQVJFIGhvbGRfY3Vyc29yIENVUlNPUiBX SVRIIEhPTEQgRk9SIFNFTEVDVCA0Mic7CisgIGxvb3AKKyAgICBmZXRjaCBwX0N1ckRhdGEg aW50byB2YWw7CisgICAgZXhpdCB3aGVuIHZhbCBpcyBudWxsOworICAgIHJhaXNlIG5vdGlj ZSAndmFsID0gJScsIHZhbDsKKyAgICByb2xsYmFjazsKKyAgZW5kIGxvb3A7CisgIGNsb3Nl IHBfQ3VyRGF0YTsKK2VuZDsgJCQ7CisKK3NlbGVjdCAqIGZyb20gcGdfY3Vyc29yczsK ------=_NextPart_6911C38B_D4EE8DA0_1C3F6C3C--