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 1paFWJ-0005SC-O9 for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Mar 2023 12:37:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paFWI-0008Io-DS for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Mar 2023 12:37:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paEwN-0002eF-BJ for pgsql-bugs@lists.postgresql.org; Thu, 09 Mar 2023 12:00:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paEwJ-0004zj-Pa for pgsql-bugs@lists.postgresql.org; Thu, 09 Mar 2023 12:00:10 +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=P2ix61dD4Gsd5L2O4OLEynwJLSBDR5c6PLKeINWwxy0=; b=qSqhKU1Uc6xA7cvu9upp7Oy8Yv enDRXnT5ck1YJ2p4oPfPUqGg8bC+mNApnAhM+IxjfWjHo7Y9lMSX+lcTdGt/ldTBF29OHJnRnGO2D PQByf3MEE8wAYPfkru5rt1KN7J2FCJIzy0fxXiL2u3BcqTAwTTZW9/fd7pHWj79L2QGvHy8HHgBhd vQO4Mzex0iqRmi/RqDhxy4kHWitLeW/EKLBj353g3G3NhaSRvQpiIHAVGjcF0iVa9bDLwkiaAatsL SScw1hyW+Rzw7Kkds6LO7KQzc9qc6fx+jYcL0codA6LE+v+BjSekFWqHattH5TL+3wPTA9AoRdZ8l f9UGJz6A==; 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 1paEwI-0006r5-Nx for pgsql-bugs@lists.postgresql.org; Thu, 09 Mar 2023 12:00:06 +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 1paEwE-009AU7-1i for pgsql-bugs@lists.postgresql.org; Thu, 09 Mar 2023 12:00:03 +0000 Content-Type: multipart/mixed; boundary="===============8323103083522414995==" MIME-Version: 1.0 Subject: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 09 Mar 2023 12:00:01 +0000 Message-ID: <17828-122da8cba23236be@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 --===============8323103083522414995== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgyOApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBzY3JpcHQ6DQpDUkVBVEUgRVhURU5TSU9OIHBvc3RncmVzX2Zk dzsNCkRPICRkJA0KICAgICAgICAgICAgQkVHSU4NCiAgICAgICAgICAgICAgICBFWEVDVVRFICQk Q1JFQVRFIFNFUlZFUiBsb29wYmFjayBGT1JFSUdOIERBVEEgV1JBUFBFUgpwb3N0Z3Jlc19mZHcN CiAgICAgICAgICAgICAgICAgICAgT1BUSU9OUyAoZGJuYW1lICckJHx8Y3VycmVudF9kYXRhYmFz ZSgpfHwkJCcsDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgIHBvcnQgJyQkfHxjdXJyZW50 X3NldHRpbmcoJ3BvcnQnKXx8JCQnLA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICBhc3lu Y19jYXBhYmxlICd0cnVlJw0KICAgICAgICAgICAgICAgICAgICApJCQ7DQogICAgICAgICAgICBF TkQ7DQokZCQ7DQoNCkNSRUFURSBVU0VSIE1BUFBJTkcgRk9SIENVUlJFTlRfVVNFUiBTRVJWRVIg bG9vcGJhY2s7DQoNCkNSRUFURSBUQUJMRSB0KGEgaW50KSBQQVJUSVRJT04gQlkgUkFOR0UgKGEp Ow0KQ1JFQVRFIFRBQkxFIHB0MSAoYSBpbnQpOw0KSU5TRVJUIElOVE8gcHQxIFNFTEVDVCAxOw0K Q1JFQVRFIEZPUkVJR04gVEFCTEUgZnB0MSBQQVJUSVRJT04gT0YgdCBGT1IgVkFMVUVTIEZST00g KCAwKSBUTyAoMTApIFNFUlZFUgpsb29wYmFjayBPUFRJT05TICh0YWJsZV9uYW1lICdwdDEnKTsN CkNSRUFURSBGT1JFSUdOIFRBQkxFIGZwdDIgUEFSVElUSU9OIE9GIHQgRk9SIFZBTFVFUyBGUk9N ICgxMCkgVE8gKDIwKSBTRVJWRVIKbG9vcGJhY2sgT1BUSU9OUyAodGFibGVfbmFtZSAnbm9uX2V4 aXN0ZW50X3RhYmxlJyk7DQoNCkNSRUFURSBUQUJMRSBudChhIGludCk7DQpTRUxFQ1QgJ0lOU0VS VCBJTlRPIG50IFNFTEVDVCAqIEZST00gdCcgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgNDAwKSAN ClxnZXhlYw0KDQooYXNzdW1pbmcgInVsaW1pdCAtbiIgPSAxMDI0IGFuZCBtYXhfc2FmZV9mZHMg LyAzID0gMzI5KQ0KaW52b2tlcyBlcnJvcnMgYW5kIGFuIGFzc2VydGlvbiBmYWlsdXJlOg0KLi4u DQpDT05URVhUOiAgcmVtb3RlIFNRTCBjb21tYW5kOiBTRUxFQ1QgYSBGUk9NIHB1YmxpYy5ub25f ZXhpc3RlbnRfdGFibGUNCkVSUk9SOiAgcmVsYXRpb24gInB1YmxpYy5ub25fZXhpc3RlbnRfdGFi bGUiIGRvZXMgbm90IGV4aXN0DQpDT05URVhUOiAgcmVtb3RlIFNRTCBjb21tYW5kOiBTRUxFQ1Qg YSBGUk9NIHB1YmxpYy5ub25fZXhpc3RlbnRfdGFibGUNCkVSUk9SOiAgcmVsYXRpb24gInB1Ymxp Yy5ub25fZXhpc3RlbnRfdGFibGUiIGRvZXMgbm90IGV4aXN0DQpDT05URVhUOiAgcmVtb3RlIFNR TCBjb21tYW5kOiBTRUxFQ1QgYSBGUk9NIHB1YmxpYy5ub25fZXhpc3RlbnRfdGFibGUNCkVSUk9S OiAgZXBvbGxfY3JlYXRlMSBmYWlsZWQ6IFRvbyBtYW55IG9wZW4gZmlsZXMNCkVSUk9SOiAgZXBv bGxfY3JlYXRlMSBmYWlsZWQ6IFRvbyBtYW55IG9wZW4gZmlsZXMNCldBUk5JTkc6ICBBYm9ydFRy YW5zYWN0aW9uIHdoaWxlIGluIEFCT1JUIHN0YXRlDQpzZXJ2ZXIgY2xvc2VkIHRoZSBjb25uZWN0 aW9uIHVuZXhwZWN0ZWRseQ0KICAgICAgICBUaGlzIHByb2JhYmx5IG1lYW5zIHRoZSBzZXJ2ZXIg dGVybWluYXRlZCBhYm5vcm1hbGx5DQogICAgICAgIGJlZm9yZSBvciB3aGlsZSBwcm9jZXNzaW5n IHRoZSByZXF1ZXN0Lg0KY29ubmVjdGlvbiB0byBzZXJ2ZXIgd2FzIGxvc3QNCi4uLg0KDQpDb3Jl IHdhcyBnZW5lcmF0ZWQgYnkgYHBvc3RncmVzOiBsYXcgcmVncmVzc2lvbiBbbG9jYWxdIElOU0VS VCAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICcuDQpQcm9ncmFtIHRlcm1p bmF0ZWQgd2l0aCBzaWduYWwgU0lHQUJSVCwgQWJvcnRlZC4NCg0Kd2FybmluZzogU2VjdGlvbiBg LnJlZy14c3RhdGUvMzIyOTc5NicgaW4gY29yZSBmaWxlIHRvbyBzbWFsbC4NCiMwICBfX3B0aHJl YWRfa2lsbF9pbXBsZW1lbnRhdGlvbiAobm9fdGlkPTAsIHNpZ25vPTYsCnRocmVhZGlkPTEzOTc0 ODI3Njc1MDI3MikgYXQgLi9ucHRsL3B0aHJlYWRfa2lsbC5jOjQ0DQo0NCAgICAgIC4vbnB0bC9w dGhyZWFkX2tpbGwuYzogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeS4NCihnZGIpIGJ0DQojMCAg X19wdGhyZWFkX2tpbGxfaW1wbGVtZW50YXRpb24gKG5vX3RpZD0wLCBzaWdubz02LAp0aHJlYWRp ZD0xMzk3NDgyNzY3NTAyNzIpIGF0IC4vbnB0bC9wdGhyZWFkX2tpbGwuYzo0NA0KIzEgIF9fcHRo cmVhZF9raWxsX2ludGVybmFsIChzaWdubz02LCB0aHJlYWRpZD0xMzk3NDgyNzY3NTAyNzIpIGF0 Ci4vbnB0bC9wdGhyZWFkX2tpbGwuYzo3OA0KIzIgIF9fR0lfX19wdGhyZWFkX2tpbGwgKHRocmVh ZGlkPTEzOTc0ODI3Njc1MDI3Miwgc2lnbm89c2lnbm9AZW50cnk9NikgYXQKLi9ucHRsL3B0aHJl YWRfa2lsbC5jOjg5DQojMyAgMHgwMDAwN2YxOWFkYjBlNDc2IGluIF9fR0lfcmFpc2UgKHNpZz1z aWdAZW50cnk9NikgYXQKLi4vc3lzZGVwcy9wb3NpeC9yYWlzZS5jOjI2DQojNCAgMHgwMDAwN2Yx OWFkYWY0N2YzIGluIF9fR0lfYWJvcnQgKCkgYXQgLi9zdGRsaWIvYWJvcnQuYzo3OQ0KIzUgIDB4 MDAwMDU1ZjY0MzYzMzBiNSBpbiBFeGNlcHRpb25hbENvbmRpdGlvbiAoY29uZGl0aW9uTmFtZT0w eDU1ZjY0M2M3Yjc4MAo8c3RyPiAiVHJhbnNhY3Rpb25JZElzVmFsaWQocHJvYy0+eGlkKSIsIA0K ICAgIGZpbGVOYW1lPTB4NTVmNjQzYzdlNDhjICJwcm9jYXJyYXkuYyIsIGxpbmVOdW1iZXI9Njgz KSBhdCBhc3NlcnQuYzo2Ng0KIzYgIDB4MDAwMDU1ZjY0MmFlMDgzYyBpbiBQcm9jQXJyYXlFbmRU cmFuc2FjdGlvbiAocHJvYz0weDdmMTlhOWMxZTE2MCwKbGF0ZXN0WGlkPTEwNjApIGF0IHByb2Nh cnJheS5jOjY4Mw0KIzcgIDB4MDAwMDU1ZjY0MTE4MDc2MyBpbiBBYm9ydFRyYW5zYWN0aW9uICgp IGF0IHhhY3QuYzoyODQxDQojOCAgMHgwMDAwNTVmNjQxMTg3MTBmIGluIEFib3J0Q3VycmVudFRy YW5zYWN0aW9uICgpIGF0IHhhY3QuYzozMzQ2DQojOSAgMHgwMDAwNTVmNjQyYzBmMjdhIGluIFBv c3RncmVzTWFpbiAoZGJuYW1lPTB4NjI5MDAwMDFiMzU4ICJyZWdyZXNzaW9uIiwKdXNlcm5hbWU9 MHg2MjUwMDAwMDIwZjggImxhdyIpDQogICAgYXQgcG9zdGdyZXMuYzo0Mjk5DQojMTAgMHgwMDAw NTVmNjQyNzY1YjM3IGluIEJhY2tlbmRSdW4gKHBvcnQ9MHg2MTQwMDAwMDAyNDApIGF0CnBvc3Rt YXN0ZXIuYzo0NDYxDQojMTEgMHgwMDAwNTVmNjQyNzVjZDkwIGluIEJhY2tlbmRTdGFydHVwIChw b3J0PTB4NjE0MDAwMDAwMjQwKSBhdApwb3N0bWFzdGVyLmM6NDE4OQ0KIzEyIDB4MDAwMDU1ZjY0 Mjc1NmQwMSBpbiBTZXJ2ZXJMb29wICgpIGF0IHBvc3RtYXN0ZXIuYzoxNzc5DQojMTMgMHgwMDAw NTVmNjQyNzUzZGEzIGluIFBvc3RtYXN0ZXJNYWluIChhcmdjPTMsIGFyZ3Y9MHg2MDMwMDAwMDA2 NzApIGF0CnBvc3RtYXN0ZXIuYzoxNDYzDQojMTQgMHgwMDAwNTVmNjQxZjVhMGZhIGluIG1haW4g KGFyZ2M9MywgYXJndj0weDYwMzAwMDAwMDY3MCkgYXQgbWFpbi5jOjIwMA0KDQpIZXJlIHBnZmR3 X2dldF9yZXN1bHQoKSBjYWxscyBXYWl0TGF0Y2hPclNvY2tldCgpIC0+DQpDcmVhdGVXYWl0RXZl bnRTZXQoKSwgdGhhdCBmYWlscyBkdWUgdG8gYSBsYWNrIG9mIGZpbGUgZGVzY3JpcHRvcnM7DQph cyBhIHJlc3VsdCwgQWJvcnRDdXJyZW50VHJhbnNhY3Rpb24oKSBjYWxsZWQsIHRoYXQgY2FsbHMN CkNhbGxYYWN0Q2FsbGJhY2tzKCkgLT4gcGdmZHdfeGFjdF9jYWxsYmFjaygpIC0+DQpwZ2Zkd19h Ym9ydF9jbGVhbnVwKCkgLT4gcGdmZHdfY2FuY2VsX3F1ZXJ5KCkgLT4NCnBnZmR3X2dldF9jbGVh bnVwX3Jlc3VsdCgpIC0+IFdhaXRMYXRjaE9yU29ja2V0KCkgLT4NCkNyZWF0ZVdhaXRFdmVudFNl dCgpLCB0aGF0IGZhaWxzIGFuZCBBYm9ydEN1cnJlbnRUcmFuc2FjdGlvbigpIGNhbGxlZA0KYWdh aW4uLi4KCg== --===============8323103083522414995==--