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 1hFtIa-0007I5-PH for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Apr 2019 04:32:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hFtIY-0007sl-Eu for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Apr 2019 04:32:50 +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 1hFtIY-0006Ev-1z for pgsql-bugs@lists.postgresql.org; Mon, 15 Apr 2019 04:32:50 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hFsSm-0000g3-Lk for pgsql-bugs@lists.postgresql.org; Mon, 15 Apr 2019 03:39:29 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id A13402DC; Sun, 14 Apr 2019 23:39:12 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sun, 14 Apr 2019 23:39:12 -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=c38CCl/oujCR2eBu7ZOmkswCNZh byD0jkY5HhkQXU8I=; b=euc5veX9pJHk5ataBOB5htmHpWNMcmFngOtmqIoxJ9f 9GssQXq6N6fdfrRh4d5PdgpQPO0uKCfQ0R9taY+UOu6E5fGfAL7qaBOe1QXOc9Xj YuLDiZYlKhoU1p/mYfrzU4pVBPLfE1PBb1gi3xvmp80kK2UIm57RfYrUtPK1bbzq arpkKw1jgxto3n3d6/XOyiPPoZudkgF4kLwRKvwebtKDhyFzVt4ZPBzhQy9RrqNn qDg4Oa8DmIQtWOuf5N+/rwSSzcCV8qS1Vljkau8FhIuLhUMNGO43KUgyHm/K5pLH LDLd/YKtoF9cdpVObqXXyyJVjtqCDdqy0vzbSYSJ6Mg== 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=c38CCl /oujCR2eBu7ZOmkswCNZhbyD0jkY5HhkQXU8I=; b=AUI7Rn9vCBVl6W9E6uvJW0 SaX9vHRx3sVdPUVGqKS53UDd/WAB9Mq2+tL/D7cj2ZfqGZ7F3SxkV6ek7GFOewsG Hq3wp/T7UlKLh+eNPTCbNWhA6KdRcPiSmxzdoxFWf3W/Asc6udy6Ql0A5vGlpRW9 hET9SZmb7AB5TRNxlxMfM8Gf7B2iC4wXbdvFg83geQ1g0p2zr71eZi+v+uS4tnxS QOA9oerFJ7xjrlHfarjAKn96ivyMFVbQAhJfZn0Ytgz3ORiX3drPMTS05BmVmlqr OkeinHpk6RqZrllloEl9rlbLoAcwrIi+tFQJizORw2HZ6e86LDLeJBWOkqG2ODcw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddrvdekgdejgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduudekrddvgedurddvhedtrdduledvnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (mp76f1fac0.ap.nuro.jp [118.241.250.192]) by mail.messagingengine.com (Postfix) with ESMTPA id E328C10319; Sun, 14 Apr 2019 23:39:09 -0400 (EDT) Date: Mon, 15 Apr 2019 12:39:06 +0900 From: Michael Paquier To: Alvaro Herrera Cc: cyberdemn@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15734: Walsender process crashing when executing SHOW ALL; Message-ID: <20190415033906.GA3526@paquier.xyz> References: <20190410060427.GB2728@paquier.xyz> <20190410150121.GA26340@alvherre.pgsql> <20190411030712.GH2728@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="d6Gm4EdcadzBjdND" Content-Disposition: inline In-Reply-To: <20190411030712.GH2728@paquier.xyz> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --d6Gm4EdcadzBjdND Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Apr 11, 2019 at 12:07:12PM +0900, Michael Paquier wrote: > What do you think about the set attached? I prefer that we use > psql(on_error_die => 1) so as in the case of a crash or an error the > test dies hard and fast. In consequence, I have granted > pg_read_all_settings to the replication user to ensure that no errors > happen, still the syscache lookup is done. We could have negative > tests but I don't think that's worth the addition as we already have > tests for pg_read_all_settings in src/test/regress/. If I remove the > patched patch from walsender.c, the test fails immediately. I have done another round of review of this patch and committed it down to v10. When testing on Windows, I have noticed that these new regression tests suffer the same problem with SSPI authentication as the recent tweaks I have done for pg_rewind. So I have backpatched the extension for PostgresNode::init done in d9f543e9 to be able to add extra options for the authentication configuration so as the new tests are able to work. Thanks Alexander for the report! -- Michael --d6Gm4EdcadzBjdND Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyz/NoACgkQnvQgOdby QH2Chw//Uq8iVvdHg4+uHVC/qHQ67I2HclYOqXyzQ3p9Yo1X6EnRHvtt5sbRW2Dy CpcJDuzKMqpDeA8AhwWrQv2oLPGvz+KmumlctQMyO56RKMLKLxUOCdK30GdgzMNz gHdP1v8XLsAetFcQZZe4zk3yLI62nJXL50DZx5bjIMLs0btUE0Q/OUpFLZzUPvMT R7QezKU3oMxUO1YNDdqh8fVsSNrsluDa+6cZEMFZlGpd9nPz3yF9Orl9rgptZmO7 4I8ZUkxmDNEXIN9YTbkQa4QNcd3nPlwobI18HP25fnDSwBupDIY52ayXB26G1IZc Qls0Uak8toX037wzKPu3YZ/yA2ev0Ij+5rBL+W15oHvBM7Gz+aNlqxHHvTijDWW+ 5kI0Wmct9bl4T6jh3n+X4r4rOISc9lqwNd0YNi8+ldNmOqjC7nDj+gCDIhxW9YzL rvybRseyl1Ne+AyIeYbq1cPpfz4t3qBc3fHO9NqE9gYKvHcnVSWaLgmXLZLivXaT k29Q1LFzMpGrQcd4lkyu/8DCUrX34su0+aOKUpcM33MuNjXziTtRxuuNkuvMPv5I TLGqdof+1PMAPlwR+CfKQheQlB56EYyUYL8weZK463X1Igb34UAJpyGnZobPqLBK F+0UQc4MAWcwnkP3zbSlegANEuV0un4MUNZMQId8bSigTLE2o+U= =3j9U -----END PGP SIGNATURE----- --d6Gm4EdcadzBjdND--