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 1iFAcn-0007Fm-Ob for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2019 05:23:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iFAcm-0004TU-7Z for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2019 05:23:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFAcm-0004TD-0H for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2019 05:23:00 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iFAcf-00026o-8d for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2019 05:22:59 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id DB9E021CFD for ; Tue, 1 Oct 2019 01:22:50 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 01 Oct 2019 01:22:50 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=KgNYwBrsWdyvsfThEx+UmKBgsg9 v65P8t10IdvsjmNQ=; b=GDXKc78NX/daqtpINHS4u3pVW8m45e2naSaBIiS6Yki ai8J4pqiQF+BxRdxI8IHr1i6B74pI8Y/xTLo+R+Ken24Ge/huhHb/nhUTrBsJTcQ VPhxaNELtxokHllYfg1e17UQTMN7i5GSq01+1tPDDtWhlCUA98c2KevLtyNqHp0i Avqqa8XAr0QwtL1NLw7B1z+XPh8/nipvZw0Nds0ldhAaObO0+gqF/cC/2qw1EK27 Mt9VG+FnJtgo8MPm9yeKk/SE49cVyK51LMlB0OcCoiTov+Y1ZJj2dIVDm6pyM5w4 4rGM9noo1uywhSEFH95opY0+OHbVLSsJPmNJYHxCDGw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=KgNYwB rsWdyvsfThEx+UmKBgsg9v65P8t10IdvsjmNQ=; b=tp3Mnw8ItbS9uQ1vfDAKI/ JRmsg5U+d4/vOY3gUXJifjlhUNrQYE+u29VjHw+C/484rm6VgjPTeCQNmj14iHLz EwKJcS0fc1BjlqSCZsnI2Z5FU3ehVL3sXfHtMpBgw4rE5hDuvmireNforgs46pfg hbA8RK3CugAwD+l2haPxmIPtwWFNi0PF0tUnOnLBvnon2pJjeu4rJD/w/FZl6rnR L0CBSO3rtTiNvHv2WoZLL3bKB+LquzCswhVl5gPLzLPqVNQ9w8D8gfbjtR05QvSe NBgF3bMHqRLocGLifPSUNpxM/Vjxm2UiKPObz1p4NNGn8hgEJKDXOYx1z7fBPF6w == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrgeefgdelvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecukfhppeduudekrddvge durddvhedtrdefkeenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgr qhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fa26.ap.nuro.jp [118.241.250.38]) by mail.messagingengine.com (Postfix) with ESMTPA id 540A0D6005F for ; Tue, 1 Oct 2019 01:22:49 -0400 (EDT) Date: Tue, 1 Oct 2019 14:22:45 +0900 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Add hooks for session start and session end, take two Message-ID: <20191001052245.GH2781@paquier.xyz> References: <20191001045246.GF2781@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="qVyHzDF4yf4A8jkR" Content-Disposition: inline In-Reply-To: <20191001045246.GF2781@paquier.xyz> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --qVyHzDF4yf4A8jkR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Oct 01, 2019 at 01:52:46PM +0900, Michael Paquier wrote: > This indicates that it is possible to reach GetCurrentCommandId() for > a parallel worker in this context. It is possible to get rid of the > problem by enforcing the following in the tests so as we have no > parallel plans: > SET max_parallel_workers =3D 0; > SET max_parallel_workers_per_gather =3D 0; > Or just use SetConfigOption as per the attached which would be a bit > cleaner, and both could be used as a temporary solution to cool down > the buildfarm but that does not feel completely right to me in the > long term. >=20 > Any thoughts? Actually, it makes little sense to allow parallel workers to log their activity in the module. So if there are no objections, I would like to fix that by checking after IsParallelWorker() in the hooks of the module. -- Michael --qVyHzDF4yf4A8jkR Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2S4qUACgkQnvQgOdby QH30RA//VG19x/NZ02GJgiZJz7EbdkHSjF+pApVCahWkozcshi7X6hGktRcZYoc0 MSFmE090MfTb1b357WM2ERJmcy8KLSnyv2MVdrkPuB5/W4L23KV3l/iFAz52v4wv NFntLgv0zMIIydPbCTKHFmhF1GMj73aqJ67njijvHAXmIn3N75RFq44PaMGlAl1p 6rJTS2NXb9ri2oJ0OZ7IkAQUpCaPdMuY4HWgR0GGc/dTEQUScjQIsWUJCCZjOJq2 py9+sUMzdpQKeV0Ifr+qST7EGuBufQtPhu9UwNYDbpeFvHsrkJ1deIW2nHaX7vGv gsH7P33gjNqlViN/VGedAFvpYug85ZW11Nl8Atycb61nxIvItvlb99KPaWzjH9Dy 2Mzl/jJtouua87N5SOXegBszn1+I4IjyXZvsavxFk1UaHTAbPXd9M/lqiIlR5Qem f0RfZasN1LWxfw/ztVzYKkUqIKy/p+XHAfMtl1m/WUDriMnZNCaDSG3YtGwBbOPR higoOvVSN4A/9DZmNp/hOQVDb5CN3KOdNSqUczlcmtYGj3S/Omz0zGW1LGEunctz xx69FFcjv2Ud5ktfkWNThzqhQO8Mcjh4mNDl5w0SEEZpgvJ5aJIa5yRJZjPcdBhp yEs63hazLJv0REp7nykh9bkEEIHFso8c/BwkwY9DWjtbgK5n6/Q= =mZbf -----END PGP SIGNATURE----- --qVyHzDF4yf4A8jkR--