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 1hR89B-0007zR-QL for pgsql-bugs@arkaria.postgresql.org; Thu, 16 May 2019 04:37:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hR88A-0000o6-SE for pgsql-bugs@arkaria.postgresql.org; Thu, 16 May 2019 04:36:34 +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 1hR889-0000nz-PG for pgsql-bugs@lists.postgresql.org; Thu, 16 May 2019 04:36:34 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hR882-0003rz-MF for pgsql-bugs@lists.postgresql.org; Thu, 16 May 2019 04:36:32 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 03AE42F8; Thu, 16 May 2019 00:36:23 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 16 May 2019 00:36:25 -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=fm1; bh=uYZ8I8LUK3+SGNXWHydSb2kGiUg CmwvdNyKxIJAvfVA=; b=af6tCgZ9zJXudlPCvvhpCQbOVxn8Dml6QAnshxaeqrM F6Ne/fF5950pn/EOMYh/IHh5ZP1IoY75r8DZUK6ITz6BID7/HYK9F6M7jBGLzXwW vE6o2VqxrvH4e7hmcV8/IXEi2A5gf7HYBC5tbkyI9aS+V71uvdoDMFf8uLUWl3R9 YoRltPNXvhd1EyDpVQT6XQoXk8rE+bAQxY06wRZQJTpGG1PhRQ8i6+oz8u/4sZ6I Gv+S5bZN1Q+KIo2ITIr8FfpxtzTCjPGUakBYfX0sTyCRbl1imoKOo2WKtLX+K7UF LOsa5zo15JUo9jZz+W7KxxXYd4L66obSSF9Tt/BpbOA== 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=fm2; bh=uYZ8I8 LUK3+SGNXWHydSb2kGiUgCmwvdNyKxIJAvfVA=; b=cyOPIo+M9JcBpd8LBiqMJd IrTadp61WPbtQClTtHtgRqd8TzfmAG3W9Nlv5q/zRL/oj0txuSwaqFRlVEBjwFTT +FU2rFudWTn1XwLoJTXMIWNinJNuDUUM2mAMkfSVH1uu7fAMG+PuhCSQ3EOo8sUU f8azFrS+c9BwpVxdi10TzVibQcPp7RZXU6SdQ0yZ7dkZEpZbGop08ON/Fd3cxmSL ccE1f1dUQUMEZ83wRzDOeynvrPSDYdWeYDzfSq4CqxLfmiJYT7Fv2yWZ2HYWfKIT bYrmB7MRIJMcZrIsK+JfqPbL3j3onFxOl9a8haKeUKQKz2d/BFc2CeCgwKw9yk2A == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrleelgdekiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 39694103CC; Thu, 16 May 2019 00:36:21 -0400 (EDT) Date: Thu, 16 May 2019 13:36:18 +0900 From: Michael Paquier To: Tom Lane Cc: Yuli Khodorkovskiy , pgsql-bugs@lists.postgresql.org, Peter Eisentraut Subject: Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Message-ID: <20190516043618.GD1415@paquier.xyz> References: <15804-3721117bf40fb654@postgresql.org> <27CD45B5-88F7-4A09-8B31-EFE41FC37FE1@crunchydata.com> <26332.1557863524@sss.pgh.pa.us> <20190515073125.GA1517@paquier.xyz> <4643.1557931189@sss.pgh.pa.us> <20190516013808.GA1415@paquier.xyz> <20190516021903.GB1415@paquier.xyz> <28927.1557977558@sss.pgh.pa.us> <20190516035617.GC1415@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Oiv9uiLrevHtW1RS" Content-Disposition: inline In-Reply-To: <20190516035617.GC1415@paquier.xyz> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Oiv9uiLrevHtW1RS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, May 16, 2019 at 12:56:17PM +0900, Michael Paquier wrote: > The test is able to pass, but we have a race condition between the > moment the backend file gets saved and the moment we allow it to be > read. I have not spent much time checking the stack between > InitializeMaxBackends() and RemovePgTempFiles() in postmaster.c, but > 57431a9 triggers the failure. Oh, I think I got it. The issue is that we call RemovePgTempFiles() after starting the syslogger. This cannot be run with other processes running in parallel, and with EXEC_BACKEND there is the extra case where we have a pgsql_tmp/ at the root of the data folder, so the syslogger complains on that. By making RemovePgTempFiles() happen before starting the syslogger, then the test complains again about the assertion without my previous patch applied of course. With the patch applied, I get no complains. -- Michael --Oiv9uiLrevHtW1RS Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlzc6MIACgkQnvQgOdby QH0X8w/+NE7loWLn3sqR8u4Cqs6ztN+dxZv8E6jM+vq13fXSA9Dyk6WoiKVs+Ce6 5SCk8xbEsJJUK6w3RqjruFQy7D7Fk5oI+tO+/RoZqTc5IrR96lQRbst7snMgK2Se DZXR6j5q4+ujtTYJbG9VvoZVeekZB0mGy3jFV9TDxX4mY1uP3v/P/d1rTCQGD0si lRE5Tt9bFD0QicX9QRPkIWng9b4DeRp/7C+NwtBTCaHhXkJUUQoLEh9uiv0eMZxr /tFSrRfqvbTBy0IczcxkYKHrjUbYT4L1iV3HUDXx9L7W7F5TSuIofJII8wGRJ+qK ihPEKeIGbP7krVGv908YebtOnbhYj1zsFdwn0IPOFUPD9xLVH17WfDRForgjpoPO t9zSO+fCcRAcA+jDCVi0OOLiRftJww6G+GdJgI4tcCLScXs70GbFZw2L7D3Ozn8z GOMiypsiVEOAyarLd4TbVlto2Fb0YU9BJJTf4clw33+rJp/9NRlkjZoYcH6qTNwB 4PxrPob/7kllXdo8XRftMoD3WYJ6Rd9l8HTCgSj2Zru/uGR1cHkXImwU+zuUyGwu GbWh/lnRkjYYnewlrLwi1uOkr2ebg3ND11nF/DZ7VsZmHhkY96SVXe8QRTVYZeAR zXLZQTl0f3+PKFGDViBg+S8wYA5xnH1TSxFFJ87hnmHvPtLqaHI= =jiDm -----END PGP SIGNATURE----- --Oiv9uiLrevHtW1RS--