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 1pF41h-0004kt-O1 for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Jan 2023 02:06:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pF40i-0005Os-Ir for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Jan 2023 02:05:08 +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 1pF40i-0005Oj-9B for pgsql-hackers@lists.postgresql.org; Tue, 10 Jan 2023 02:05:08 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pF40f-0002P4-Mh; Tue, 10 Jan 2023 02:05:06 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id D666432009A7; Mon, 9 Jan 2023 21:05:03 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 09 Jan 2023 21:05:04 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm3; t=1673316303; x=1673402703; bh=pvwey7WId8 cwt0e5hLBKnfHeijgFocJT7xAksA4aH2I=; b=HIdT6TQBNZHNJa6ok0jLzYX54y 9BHZTj9w9z7OicJs816S7NTEEYvn1nmw8kjljnWrttXGmZJkoJmhSnFYRKE8Jtxj CBOJnYt0LV/1K2TO6Ca/XCuo0bbQCKVIlYEM2S5FsqUnsCHcguqKmxXMbtX8qw/n h/LAohYUK150eA/yi+1D3wtGeMihqzqZIfTUa0ST3CLZDHA93+WdLo1Uy7eriSUl Qp0HANlDhEi34I0x3tU2MfdHQzuAoJHD7b+O9RZt8JSEB+/6czlp0gglBjgZB2Q2 af68FidTRJMLCr6xb1/k7n9p7Wqtrc+uZ/ZA8Xi0MAmYfRot9rRkjvEToTqA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; t=1673316303; x=1673402703; bh=pvwey7WId8cwt0e5hLBKnfHeijgF ocJT7xAksA4aH2I=; b=FVCIhR/OUr59d8A0QRvU2a5euwpR5SfY8FoINeuw2zEQ XdFCkpBWJz18nChOep4guz1Nnat/KMJnne5c4bUolGEai1fVdPhaHQR7sfSRy8G4 mjH2wGDzeH3ZMdoHYf+eMCcDv7Epri6ktjPlWaYW3GR7aH1hgZlq72aaZM8yDFSX cvqDJgoqeTCSaXuai6Al3stoQROjFs+9ZiCVAuWFL6MoWNV+i5/+mol8pP3Pp/gd nWtPrDiQVHXuggqW2q1cPMZrpYt5Qo5+BDKAEzscmtO1XqeMfNiBMvDJ2FJouWO3 zbFNJAXWOgCjVBdN9QkCURs97uptnaw8KXT+jp/M2Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrkeejgdegfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedvffefvefhteevffegieetfefhtddvffejvefhueetgeeludehteevudei tedtudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 9 Jan 2023 21:05:03 -0500 (EST) Date: Mon, 9 Jan 2023 18:05:01 -0800 From: Andres Freund To: Thomas Munro Cc: pgsql-hackers@postgresql.org, Robert Haas , Peter Geoghegan , Tom Lane , Fujii Masao , Bharath Rupireddy Subject: Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Message-ID: <20230110020501.bujiesmhe2fuka42@awork3.anarazel.de> References: <20220925232237.p6uskba2dw6fnwj2@awork3.anarazel.de> <20221209020815.wsoixct72c6hst5l@awork3.anarazel.de> <20221229172330.jpuoljhtvivci3cd@awork3.anarazel.de> <20221229215437.s4q5lu6ijb67jugx@awork3.anarazel.de> <20230103200520.di5hjebqvi72coql@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230103200520.di5hjebqvi72coql@awork3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2023-01-03 12:05:20 -0800, Andres Freund wrote: > The attached patch adds libpq-be-fe-helpers.h and uses it in libpqwalreceiver, > dblink, postgres_fdw. > As I made libpq-be-fe-helpers.h handle reserving external fds, > libpqwalreceiver now does so. I briefly looked through its users without > seeing cases of leaking in case of errors - which would already have been bad, > since we'd already have leaked a libpq connection/socket. > > > Given the lack of field complaints and the size of the required changes, I > don't think we should backpatch this, even though it's pretty clearly buggy > as-is. Any comments on this? Otherwise I think I'll go with this approach. Greetings, Andres Freund