Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opsVk-0004mk-MK for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Nov 2022 14:45:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1opsVj-0002Oq-Kq for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Nov 2022 14:45:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opqpN-0001q4-KH for pgsql-hackers@lists.postgresql.org; Tue, 01 Nov 2022 12:57:13 +0000 Received: from mailgate01.hundsun.com ([60.191.25.163] helo=spam03.hundsun.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opqpG-0004Ch-J2 for pgsql-hackers@lists.postgresql.org; Tue, 01 Nov 2022 12:57:12 +0000 Received: from spam03.hundsun.com (localhost.localdomain [127.0.0.1]) by localhost (Email Security Appliance) with SMTP id A6AA5331AEDD_361179CB; Tue, 1 Nov 2022 12:57:00 +0000 (GMT) Received: from HSMAILSVR01.hs.handsome.com.cn (unknown [192.168.67.31]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (Client CN "HSMAILSVR01", Issuer "HSMAILSVR01" (not verified)) by spam03.hundsun.com (Sophos Email Appliance) with ESMTPS id 9FF0033193FE_361179CF; Tue, 1 Nov 2022 12:57:00 +0000 (GMT) Received: from HSMailSvr03.hs.handsome.com.cn (192.168.67.33) by HSMAILSVR01.hs.handsome.com.cn (192.168.67.51) with Microsoft SMTP Server (TLS) id 15.0.1497.38; Tue, 1 Nov 2022 20:57:00 +0800 Received: from HSMailSvr03.hs.handsome.com.cn ([fe80::39b5:424d:81d9:103c]) by HSMAILSVR03.hs.handsome.com.cn ([fe80::39b5:424d:81d9:103c%13]) with mapi id 15.00.1497.040; Tue, 1 Nov 2022 20:57:00 +0800 From: =?gb2312?B?1dTG5Lnw?= To: "pgsql-hackers@lists.postgresql.org" CC: "402142054@qq.com" <402142054@qq.com> Subject: BUG #17663:Connect to the database through jdbc, call the stored procedure containing the rollback statement,the database triggers an assertion, and the database is in recovery mode. Thread-Topic: BUG #17663:Connect to the database through jdbc, call the stored procedure containing the rollback statement,the database triggers an assertion, and the database is in recovery mode. Thread-Index: AQHY7e0YOmir78DL+UurtjNdbQfxig== Date: Tue, 1 Nov 2022 12:57:00 +0000 Message-ID: <1667307420050.56657@hundsun.com> Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.188.25.205] Content-Type: multipart/mixed; boundary="_002_166730742005056657hundsuncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_002_166730742005056657hundsuncom_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 RGVhciBkZXZlbG9wZXI6DQpUaGUgcGF0Y2ggc3VibWl0dGVkIGFkZHJlc3NlcyAjMTc2NjMgaW4g dGhlIHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmcgbGlzdC4NClByb2JsZW06IEFkZCB0 aGUgcGFyYW1ldGVycyAtLWVuYWJsZS1kZWJ1ZyBhbmQgLS1lbmFibGUtY2Fzc2VydCB3aGVuIHRo ZSBkYXRhYmFzZSBpcyBjb21waWxlZC4gRHJpdmVuIGJ5IGpkYmMsIHRoZSBzdG9yZWQgcHJvY2Vk dXJlIGNvbnRhaW5pbmcgcm9sbGJjayBpcyBjYWxsZWQsIGFuZCBhbiBhc3NlcnRpb24gb2NjdXJz Lg0KQ2F1c2Ugb2YgdGhlIHByb2JsZW06IERyaXZlbiBieSBqZGJjLCBpbiB0aGUgZnVuY3Rpb24g QnVpbGRDYWNoZWRQbGFuLCB0aGUgQ2FjaGVkUGxhbiBtZW1vcnkgY29udGV4dCBpcyBnZW5lcmF0 ZWQgdG8gc2F2ZSB0aGUgZXhlY3V0aW9uIHBsYW4gKHBsYW4pIG9mIHRoZSBpbnB1dCBTUUwuIElm IHRoZSBzdG9yZWQgcHJvY2VkdXJlIGNvbnRhaW5zIHJvbGxiYWNrLCBjYWxsIHRoZSBmdW5jdGlv biBSZWxlYXNlQ2FjaGVkUGxhbiB0byByZWxlYXNlIHRoZSBDYWNoZWRQbGFuIG1lbW9yeSBjb250 ZXh0LiBUaGVyZWZvcmUsIGJlZm9yZSB0aGUgZnVuY3Rpb24gcGdzc19zdG9yZSBjb2xsZWN0cyBz dGF0aXN0aWNhbCBpbmZvcm1hdGlvbiwgaXQgaXMgbmVjZXNzYXJ5IHRvIHJldGFpbiB0aGUgc3Rt dF9sb2NhdGlvbiBhbmQgc3RtdF9sZW4gZGF0YSByZXF1aXJlZCBpbiBwc3RtdCwgd2hpY2ggd2ls bCBub3QgYmUgcmVsZWFzZWQgYnkgdGhlIGNDYWNoZWRQbGFuIG1lbW9yeSBjb250ZXh0LCByZXN1 bHRpbmcgaW4gcmFuZG9tIHZhbHVlcyBmb3IgdGhlIHBhcmFtZXRlcnMgcmVxdWlyZWQgYnkgdGhl IGZ1bmN0aW9uIHBnc3Nfc3RvcmUuPw0K --_002_166730742005056657hundsuncom_ Content-Type: text/plain; name="0001-fix-BUG-17663-Connect-to-the-database-through-jdbc-c.patch" Content-Description: 0001-fix-BUG-17663-Connect-to-the-database-through-jdbc-c.patch Content-Disposition: attachment; filename="0001-fix-BUG-17663-Connect-to-the-database-through-jdbc-c.patch"; size=1390; creation-date="Tue, 01 Nov 2022 12:30:23 GMT"; modification-date="Tue, 01 Nov 2022 12:30:23 GMT" Content-Transfer-Encoding: base64 RnJvbSA0ZDAyNDA2YjkyMzM5YzU2MWFhM2I1ZGVjYTk2Y2E4NzU0NzM2NTVhIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBvcmFjbGUgPG9yYWNsZUBsb2NhbGhvc3QubG9jYWxkb21haW4+ CkRhdGU6IFR1ZSwgMSBOb3YgMjAyMiAyMDoxNDoxNCArMDgwMApTdWJqZWN0OiBbUEFUQ0hdIGZp eCBCVUcgIzE3NjYzOiBDb25uZWN0IHRvIHRoZSBkYXRhYmFzZSB0aHJvdWdoIGpkYmMsIGNhbGwK IHRoZSBzdG9yZWQgcHJvY2VkdXJlIGNvbnRhaW5pbmcgdGhlIHJvbGxiYWNrIHN0YXRlbWVudCwg dGhlIGRhdGFiYXNlIHRyaWdnZXJzCiBhbiBhc3NlcnRpb24sIGFuZCB0aGUgZGF0YWJhc2UgaXMg aW4gcmVjb3ZlcnkgbW9kZQoKLS0tCiBjb250cmliL3BnX3N0YXRfc3RhdGVtZW50cy9wZ19zdGF0 X3N0YXRlbWVudHMuYyB8IDYgKysrKy0tCiAxIGZpbGUgY2hhbmdlZCwgNCBpbnNlcnRpb25zKCsp LCAyIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2NvbnRyaWIvcGdfc3RhdF9zdGF0ZW1lbnRz L3BnX3N0YXRfc3RhdGVtZW50cy5jIGIvY29udHJpYi9wZ19zdGF0X3N0YXRlbWVudHMvcGdfc3Rh dF9zdGF0ZW1lbnRzLmMKaW5kZXggMGJlYjU2YS4uMzMzMGYzNSAxMDA2NDQKLS0tIGEvY29udHJp Yi9wZ19zdGF0X3N0YXRlbWVudHMvcGdfc3RhdF9zdGF0ZW1lbnRzLmMKKysrIGIvY29udHJpYi9w Z19zdGF0X3N0YXRlbWVudHMvcGdfc3RhdF9zdGF0ZW1lbnRzLmMKQEAgLTEwODMsNiArMTA4Myw4 IEBAIHBnc3NfUHJvY2Vzc1V0aWxpdHkoUGxhbm5lZFN0bXQgKnBzdG10LCBjb25zdCBjaGFyICpx dWVyeVN0cmluZywKIHsKIAlOb2RlCSAgICpwYXJzZXRyZWUgPSBwc3RtdC0+dXRpbGl0eVN0bXQ7 CiAJdWludDY0CQlzYXZlZF9xdWVyeUlkID0gcHN0bXQtPnF1ZXJ5SWQ7CisJaW50CSAgIHN0bXRf bG9jYXRpb24gPSBwc3RtdC0+c3RtdF9sb2NhdGlvbjsKKwlpbnQJICAgc3RtdF9sZW4gPSBwc3Rt dC0+c3RtdF9sZW47CiAKIAkvKgogCSAqIEZvcmNlIHV0aWxpdHkgc3RhdGVtZW50cyB0byBnZXQg cXVlcnlJZCB6ZXJvLiAgV2UgZG8gdGhpcyBldmVuIGluIGNhc2VzCkBAIC0xMTcyLDggKzExNzQs OCBAQCBwZ3NzX1Byb2Nlc3NVdGlsaXR5KFBsYW5uZWRTdG10ICpwc3RtdCwgY29uc3QgY2hhciAq cXVlcnlTdHJpbmcsCiAKIAkJcGdzc19zdG9yZShxdWVyeVN0cmluZywKIAkJCQkgICBzYXZlZF9x dWVyeUlkLAotCQkJCSAgIHBzdG10LT5zdG10X2xvY2F0aW9uLAotCQkJCSAgIHBzdG10LT5zdG10 X2xlbiwKKwkJCQkgICBzdG10X2xvY2F0aW9uLAorCQkJCSAgIHN0bXRfbGVuLAogCQkJCSAgIFBH U1NfRVhFQywKIAkJCQkgICBJTlNUUl9USU1FX0dFVF9NSUxMSVNFQyhkdXJhdGlvbiksCiAJCQkJ ICAgcm93cywKLS0gCjEuOC4zLjEKCg== --_002_166730742005056657hundsuncom_--