Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i7YsI-0005MB-Rp for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Sep 2019 05:39:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i7YsG-000832-Q8 for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Sep 2019 05:39:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i7YsG-00082v-FZ for pgsql-bugs@lists.postgresql.org; Tue, 10 Sep 2019 05:39:32 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1i7YsE-0001nW-6h for pgsql-bugs@lists.postgresql.org; Tue, 10 Sep 2019 05:39:31 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 6F97521650; Tue, 10 Sep 2019 01:39:29 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 10 Sep 2019 01:39:29 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=Nsyn0wh3Jp6t9S5gcPh4YeaIZSl U4wKcD+qmdiIRH14=; b=biNmkxIxTQoFoU1++zMmFe2hM3VMug08DqISfpG+LrN YtBYiIdxkKSgLrFTSuyyNW+3HVC2qOpNFwSMVV31/JVK6loJmTsS5rB5EK9t2sHf noO3ZmzJJwkAg3eHN9esKxP01eK/wOke3r1kM1lx7P36ELkYxmko+Hh12fxm4iVm NPkckKEOUWdeCi5iQv2BLuRF1NCezQhf/1YiGzaUXTEWSajs2TNUEBxYMZqXrWBr 5IZT0y0hcz7zYFhcOjqOdj0M+TRflcE7V7Hpk+gIUwHEJwKOOzZn+BQknNdCHZg9 9U0Hcq+XJfpTasM5wOzPHtbPkPlg9mDo89OSXbTaHTw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=Nsyn0w h3Jp6t9S5gcPh4YeaIZSlU4wKcD+qmdiIRH14=; b=zPKTCsMVBJqaLVozm7EGkh Xt/th6zWbOUsTLALY4G6i6ZI2reuq6QTlOQI8yK30PsV1gp0uj6Gq/81u9YS8aG7 uvriGGPfzgzgiYpLpdHvmpkPNFUXHo/TH0oc+u4wqc/qz1Egq+OgBQsQsYsODCzU unE3im85hGHdy/5WGtcSIPX3ynpcfXMnu0pZ73n7qsh4xZvzUpeXq3sElQSYj2Kf 36aswT8S4FkwlhPoQkd+KAP98wNhEslUuLF/XVcEmb5SYXTBpRYIGX2h/QkKrO3K LBCFRpmQh+2JkYifvvLPYMyUReYyzLIVt5g6XP3nTmuQuiS9nvTgvuBEZDzNBuQw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrudekjedgleegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepuddukedrvdeguddrvdehtddrvdeffeenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fae9.ap.nuro.jp [118.241.250.233]) by mail.messagingengine.com (Postfix) with ESMTPA id 24A5480061; Tue, 10 Sep 2019 01:39:26 -0400 (EDT) Date: Tue, 10 Sep 2019 14:39:23 +0900 From: Michael Paquier To: Tom Lane Cc: Andrew Dunstan , Andres Freund , Peter Eisentraut , Yuli Khodorkovskiy , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Message-ID: <20190910053923.GC11737@paquier.xyz> References: <22995.1558278322@sss.pgh.pa.us> <27719.1558282181@sss.pgh.pa.us> <16df9d01-8b03-2664-a18c-16c40186f5ab@2ndQuadrant.com> <2702.1558289980@sss.pgh.pa.us> <20190520012728.GC1923@paquier.xyz> <1664.1558325417@sss.pgh.pa.us> <7927.1558364465@sss.pgh.pa.us> <31457.1568057723@sss.pgh.pa.us> <20190910051115.GB22934@paquier.xyz> <6728.1568093331@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="adJ1OR3c6QgCpb/j" Content-Disposition: inline In-Reply-To: <6728.1568093331@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --adJ1OR3c6QgCpb/j Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 10, 2019 at 01:28:51AM -0400, Tom Lane wrote: > But the external PID file is a different story. I can believe that > something might be expecting the sockets to be open before we create > that file --- and since we're not using that file for an interlock, > there's no reason to be in a hurry to create it. I think it'd make > sense to move that step further down, so it's still done after the > create-sockets step. That's the actual take here. We cannot assume that nobody is relying on that. If they do, it could be tricky to rework this logic. Moving the external file write a bit later does not sound like a bad thing in itself to keep more consistency with the past. -- Michael --adJ1OR3c6QgCpb/j Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl13NwsACgkQnvQgOdby QH16ig/9FgIJeEpA+CwH4PTl2gBJ/T7Ema0o5OSFJTvn71upmpOhxwvlwK4JWy/U U4aj9/PShv4WVykbo+AgdOjXTTsTcF4lbPUkLDFPcst6qbTJmKYT67hoWMY+3aFN 8Y3Js+1KPpoK0p/i/J9Iw/QnIOc8hBveuekFC4A2Zb7/YL3+sbiaCTzMspfpFerD HT/JoTZlwH68zEaDrC0ONAtTpooCXohlAn4wsbtJJLrjXFHotBCoZvXntN8SCSm3 2OjttzFIybIrloZ1q5BuPxZdLaz68l2AnzYPkZoi9lILvfgVY0R2dl1CtJ+owpvf 7FSMEvHxncBXSomiRxACrBLSbUU0RCbSmJ/TKQ4ymd/xWEVUGZt7WNeQ1QwIc89c FwIRfnEYoAYEfWKdGpvSCPgJo1SEd0267jMHwaS+spUa2ETwsN8fRAssejT3GAvu PURpFhJfhRIfnYSNjyEi7Z/h5YoEUHyu9zod7UN0QJn8+ubseehuKeCnuo4a24zY NCFxDO2Kj0lQNazGxydkxXu2UbTQiMWViOViH4tMMnJABSeYVj41rHTWGegMfz7P Ndqs5ciNyQ3peR57QsmpD3BtPdTv2U/roZSpaYMerXLGYrno12q9rj2doSZ7vbSi T6+vm34kisOH/N0/U4cJdyiGX25tG6oqovH6YwtW8X8tmqNKoEg= =KzCq -----END PGP SIGNATURE----- --adJ1OR3c6QgCpb/j--