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 1oVAG1-0002lX-B7 for pgsql-bugs@arkaria.postgresql.org; Mon, 05 Sep 2022 11:27:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oVAG0-0007Jx-72 for pgsql-bugs@arkaria.postgresql.org; Mon, 05 Sep 2022 11:27:12 +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 1oV9zU-0005jR-Rs for pgsql-bugs@lists.postgresql.org; Mon, 05 Sep 2022 11:10:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oV9zS-0000jY-Q5 for pgsql-bugs@lists.postgresql.org; Mon, 05 Sep 2022 11:10:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=lkehqyOA/GRGd4lxgIpRv6Fv1LEdv2We00K14acvYcE=; b=KrM//+xQuuryyIUYry9zgfit80 BUT+s2/LMckGH99tqjFKtSyGgMkhgZ4KD57c76fN16WthrWwOIGgDtCxMlUXq9XZKftiJWS9Qwsfk WxxK/eHLM8ViXdz0jk6tgaEi2R0/VHAwNGtWj6suHs0GX4HE7wIn33jotoWF1Ilah8V+6ySCHgAvO Bc+zV7zdL/YQV9rla7L6dWuCEBffLn+GLpD7D3159FRnkuOt6gbysR0jAo5veakuzTmqf3ATeclkU osSxh+GjHuoEfadkWzIdiJHcf8DWrVEKz1NKEhrC9zdwLfmt4YGdyabqSxvmI9FNolRp4EmnKyrPc sDMpnoaQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oV9zQ-00049D-Ai for pgsql-bugs@lists.postgresql.org; Mon, 05 Sep 2022 11:10:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oV9zO-0001oW-CL for pgsql-bugs@lists.postgresql.org; Mon, 05 Sep 2022 11:10:02 +0000 Content-Type: multipart/mixed; boundary="===============2493859880724244223==" MIME-Version: 1.0 Subject: BUG #17607: Server process crashes when PLpgSQL function raises error in subtransaction To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: thomas.d.mckay@gmail.com Reply-To: thomas.d.mckay@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 05 Sep 2022 11:09:27 +0000 Message-ID: <17607-bd8ccc81226f7f80@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2493859880724244223== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzYwNwpMb2dnZWQgYnk6ICAgICAgICAgIFRob21hcyBNYyBLYXkKRW1h aWwgYWRkcmVzczogICAgICB0aG9tYXMuZC5tY2theUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMy44Ck9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIGluIGRvY2tlcgpEZXNjcmlwdGlv bjogICAgICAgIAoKSGVsbG8sDQoNCkkndmUgZW5jb3VudGVyZWQgYSBidWcgd2hpbGUgZG9pbmcg c29tZSBTUUwgbWlncmF0aW9ucyBvbiBhIFBvc3RncmVTUUwgMTMuOApzZXJ2ZXIuIE15IGluaXRp YWwgdXNlLWNhc2UgaXMgYSBEamFuZ28gYXBwIHJ1bm5pbmcgbWlncmF0aW9ucywgYSB0ZXN0IHNl dHVwCmFuZCBhIHRlc3QsIGJ1dCB0aGF0IGNvZGUgd2FzIG1vcmUgdGhhbiAxMEsgbGluZXMgb2Yg RERMLCBzbyBJJ3ZlIHJlZHVjZWQKdGhlIGNvZGUgdG8gYSBtaW5pbWFsIHJlcHJvZHVjaWJsZSBl eGFtcGxlIChhcyBiZXN0IEkgY291bGQpLg0KDQpJIGFsc28gdGVzdGVkIHRoZSBzYW1lIHNjcmlw dCBpbiAxNC4wIGFuZCAxNC41IGFuZCBpbiBib3RoLCB0aGUgYnVnIGlzCmZpeGVkLiBJIGhhdmVu J3Qgc2VlbiBhbnl0aGluZyByZWxhdGVkIHRvIGl0IGluIHRoZSBjaGFuZ2Vsb2cgZm9yIDE0LjAs IHNvIEkKZG9uJ3Qga25vdyB3aGV0aGVyIHRoZSBidWcgd2FzIGZpeGVkIHB1cnBvc2VmdWxseSBh bmQgZm9yZ290dGVuIGluIHRoZQpjaGFuZ2Vsb2cgb3IgaWYgaXQgd2FzIGZpeGVkIGJ5IGFjY2lk ZW50LCBtYXliZSBhcyBhIGNvcm9sbGFyeSBvZiBhbm90aGVyCmJ1Z2ZpeC9mZWF0dXJlLiBJIGFs c28gZG9uJ3Qga25vdyBpZiB0aGlzIGlzIHNvbWV0aGluZyB0aGUgZGV2cyB3b3VsZCB3YW50CnRv IGZpeCBpbiB0aGUgMTMueCBsaW5lLiBFaXRoZXIgd2F5LCBJIGZpZ3VyZWQgaXQgbWlnaHQgbWFr ZSBhIGdvb2QKcmVncmVzc2lvbiB0ZXN0IGNhc2UgZm9yIDE0LnguDQoNCkVudmlyb25tZW50IChE b2NrZXIpOg0KLSBQb3N0Z3JlU1FMIDEzLjggKERlYmlhbiAxMy44LTEucGdkZzExMCsxKSBvbiB4 ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZApieSBnY2MgKERlYmlhbiAxMC4yLjEtNikgMTAu Mi4xIDIwMjEwMTEwLCA2NC1iaXQNCg0KDQpUZXN0IGNvZGU6DQoNCmBgYA0KLS0gTWlncmF0aW9u IDENCkNSRUFURSBUQUJMRSAidGJsIiAoImlkIiBzZXJpYWwgTk9UIE5VTEwgUFJJTUFSWSBLRVkp Ow0KDQotLSBNaWdyYXRpb24gMg0KQUxURVIgVEFCTEUgInRibCIgQUREIENPTFVNTiAidmFsdWUi IGludCBERUZBVUxUIDAgTk9UIE5VTEw7DQoNCkNSRUFURSBGVU5DVElPTiBvbl90YmxfcGFyZW50 X2lkX2NoYW5nZV9mbigpIFJFVFVSTlMgVFJJR0dFUiBBUwokb25fdGJsX3BhcmVudF9pZF9jaGFu Z2UkDQogICAgQkVHSU4NCiAgICAgICAgUkFJU0UgRVhDRVBUSU9OICdCT09NICEnOw0KICAgIEVO RA0KJG9uX3RibF9wYXJlbnRfaWRfY2hhbmdlJCBMQU5HVUFHRSBQTHBnU1FMIFZPTEFUSUxFOw0K DQpDUkVBVEUgVFJJR0dFUiBvbl90YmxfcGFyZW50X2lkX3VwZGF0ZQ0KICAgIEFGVEVSIFVQREFU RSBPTiB0YmwNCiAgICBSRUZFUkVOQ0lORyBPTEQgVEFCTEUgQVMgb2xkX3Jvd3MgTkVXIFRBQkxF IEFTIG5ld19yb3dzDQogICAgRk9SIEVBQ0ggU1RBVEVNRU5UDQogICAgRVhFQ1VURSBQUk9DRURV UkUgb25fdGJsX3BhcmVudF9pZF9jaGFuZ2VfZm4oKTsNCg0KLS0gVGVzdCBzZXR1cA0KSU5TRVJU IElOVE8gInRibCIgKCJ2YWx1ZSIpIFZBTFVFUyAoMik7DQoNCi0tIFRlc3QNCkJFR0lOOw0KU0FW RVBPSU5UIHN2cDsNClVQREFURSB0YmwgU0VUIHZhbHVlPTE7ICAtLSBGYWlscyBoZXJlDQpST0xM QkFDSyBUTyBTQVZFUE9JTlQgc3ZwOw0KUk9MTEJBQ0s7DQpgYGANCg0KT3V0cHV0ICh2ZXJib3Nl KToNCg0KYGBgDQotLSBDUkVBVEUgVEFCTEUNCi0tIEFMVEVSIFRBQkxFDQotLSBDUkVBVEUgRlVO Q1RJT04NCi0tIENSRUFURSBUUklHR0VSDQotLSBJTlNFUlQgMCAxDQotLSBCRUdJTg0KLS0gU0FW RVBPSU5UDQotLSBXQVJOSU5HOiAgMDEwMDA6IEFib3J0U3ViVHJhbnNhY3Rpb24gd2hpbGUgaW4g QUJPUlQgc3RhdGUNCi0tIExPQ0FUSU9OOiAgQWJvcnRTdWJUcmFuc2FjdGlvbiwgeGFjdC5jOjQ5 OTkNCi0tIFdBUk5JTkc6ICAwMTAwMDogQWJvcnRTdWJUcmFuc2FjdGlvbiB3aGlsZSBpbiBBQk9S VCBzdGF0ZQ0KLS0gTE9DQVRJT046ICBBYm9ydFN1YlRyYW5zYWN0aW9uLCB4YWN0LmM6NDk5OQ0K LS0gV0FSTklORzogIDAxMDAwOiBBYm9ydFN1YlRyYW5zYWN0aW9uIHdoaWxlIGluIEFCT1JUIHN0 YXRlDQotLSBMT0NBVElPTjogIEFib3J0U3ViVHJhbnNhY3Rpb24sIHhhY3QuYzo0OTk5DQotLSBF UlJPUjogIFAwMDAxOiBCT09NICENCi0tIENPTlRFWFQ6ICBQTC9wZ1NRTCBmdW5jdGlvbiBvbl90 YmxfcGFyZW50X2lkX2NoYW5nZV9mbigpIGxpbmUgMyBhdApSQUlTRQ0KLS0gTE9DQVRJT046ICBl eGVjX3N0bXRfcmFpc2UsIHBsX2V4ZWMuYzozODU0DQotLSBFUlJPUjogIFhYMDAwOiB0dXBkZXNj IHJlZmVyZW5jZSAweDdmYzAyODczZmJjOCBpcyBub3Qgb3duZWQgYnkgcmVzb3VyY2UKb3duZXIg U3ViVHJhbnNhY3Rpb24NCi0tIExPQ0FUSU9OOiAgUmVzb3VyY2VPd25lckZvcmdldFR1cGxlRGVz YywgcmVzb3duZXIuYzoxMTg4DQotLSBFUlJPUjogIFhYMDAwOiB0dXBkZXNjIHJlZmVyZW5jZSAw eDdmYzAyODczZmJjOCBpcyBub3Qgb3duZWQgYnkgcmVzb3VyY2UKb3duZXIgU3ViVHJhbnNhY3Rp b24NCi0tIExPQ0FUSU9OOiAgUmVzb3VyY2VPd25lckZvcmdldFR1cGxlRGVzYywgcmVzb3duZXIu YzoxMTg4DQotLSBFUlJPUjogIFhYMDAwOiB0dXBkZXNjIHJlZmVyZW5jZSAweDdmYzAyODczZmJj OCBpcyBub3Qgb3duZWQgYnkgcmVzb3VyY2UKb3duZXIgU3ViVHJhbnNhY3Rpb24NCi0tIExPQ0FU SU9OOiAgUmVzb3VyY2VPd25lckZvcmdldFR1cGxlRGVzYywgcmVzb3duZXIuYzoxMTg4DQotLSBF UlJPUjogIFhYMDAwOiB0dXBkZXNjIHJlZmVyZW5jZSAweDdmYzAyODczZmJjOCBpcyBub3Qgb3du ZWQgYnkgcmVzb3VyY2UKb3duZXIgU3ViVHJhbnNhY3Rpb24NCi0tIExPQ0FUSU9OOiAgUmVzb3Vy Y2VPd25lckZvcmdldFR1cGxlRGVzYywgcmVzb3duZXIuYzoxMTg4DQotLSBQQU5JQzogIFhYMDAw OiBFUlJPUkRBVEFfU1RBQ0tfU0laRSBleGNlZWRlZA0KLS0gTE9DQVRJT046ICBlcnJzdGFydCwg ZWxvZy5jOjM1OQ0KLS0gc2VydmVyIGNsb3NlZCB0aGUgY29ubmVjdGlvbiB1bmV4cGVjdGVkbHkN Ci0tICAgICAgICAgVGhpcyBwcm9iYWJseSBtZWFucyB0aGUgc2VydmVyIHRlcm1pbmF0ZWQgYWJu b3JtYWxseQ0KLS0gICAgICAgICBiZWZvcmUgb3Igd2hpbGUgcHJvY2Vzc2luZyB0aGUgcmVxdWVz dC4NCi0tIFRoZSBjb25uZWN0aW9uIHRvIHRoZSBzZXJ2ZXIgd2FzIGxvc3QuIEF0dGVtcHRpbmcg cmVzZXQ6IEZhaWxlZC4NCi0tIFlvdSBhcmUgY3VycmVudGx5IG5vdCBjb25uZWN0ZWQgdG8gYSBk YXRhYmFzZS4NCi0tIFlvdSBhcmUgY3VycmVudGx5IG5vdCBjb25uZWN0ZWQgdG8gYSBkYXRhYmFz ZS4NCmBgYA0KDQpFeHBlY3RlZCBvdXRwdXQ6DQpgYGANCkNSRUFURSBUQUJMRQ0KQUxURVIgVEFC TEUNCkNSRUFURSBGVU5DVElPTg0KQ1JFQVRFIFRSSUdHRVINCklOU0VSVCAwIDENCkJFR0lODQpT QVZFUE9JTlQNCkVSUk9SOiAgQk9PTSAhDQpDT05URVhUOiAgUEwvcGdTUUwgZnVuY3Rpb24gb25f dGJsX3BhcmVudF9pZF9jaGFuZ2VfZm4oKSBsaW5lIDMgYXQgUkFJU0UNClJPTExCQUNLDQpST0xM QkFDSw0KYGBgDQoNClRoZSBidWcgZGlzYXBwZWFycyBpZiBhbnkgb2YgdGhlIGZvbGxvd2luZyBp cyB0cnVlOg0KLSB2YWx1ZSBpcyBhZGRlZCB0byB0aGUgdGFibGUgZGVmaW5pdGlvbiBhbmQgbm90 IHdpdGggQUxURVIgVEFCTEUuDQotIHZhbHVlIGlzIGRlY2xhcmVkIHdpdGhvdXQgYSBkZWZhdWx0 Lg0KLSBgUkVGRVJFTkNJTkcgT0xEIFRBQkxFIEFTIG9sZF9yb3dzIE5FVyBUQUJMRSBBUyBuZXdf cm93c2AgaXMgcmVtb3ZlZCBmcm9tCnRoZSB0cmlnZ2VyLg0KLSBhIGBWQUNVVU0gRlVMTCB0Ymxg IGlzIGRvbmUgYmV0d2VlbiB0aGUgdHJpZ2dlciBjcmVhdGlvbiBhbmQgdGhlIGluc2VydC4NCg0K SSBkb24ndCBrbm93IHdoYXQgdG8gbWFrZSBvZiBpdCwgdGhvdWdoLg0KDQpDaGVlcnMsDQoNClRo b21hcwoK --===============2493859880724244223==--