Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ropN8-003bhX-Fu for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Mar 2024 18:48:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ropN6-006u86-Qe for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Mar 2024 18:48:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ropN4-006u7x-UJ for pgsql-hackers@lists.postgresql.org; Mon, 25 Mar 2024 18:48:37 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ropN1-006S1a-8A for pgsql-hackers@postgresql.org; Mon, 25 Mar 2024 18:48:34 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id DA7BF32009B5; Mon, 25 Mar 2024 14:48:26 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 25 Mar 2024 14:48:27 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1711392506; x=1711478906; bh=Ad8wwgLOfY joxjgaon9+YIkAkH972HF1PcL+6xyd6MQ=; b=Vbah5XA67flWy6NXOXpFCR0BmW cQi27KAR75Eel+f6BlndjljXEzapccdiaZSpvHkrfnq3DIbVBUqx4+t+IimWvvPt bg86Mcj4WSMsPbHJjwqYU8BRcpXqDMcg4QZmsjr6ABjZ9NQQkrMFvqhpea2U6PLW eUY4NY1WyTDSwPzm6yFadVOw0/RVEwpxBu4Y9h1u5yYgxq5zH9FVNgp5Z5eWjnkp Ng5s50CNJE42WEYKbnOal3yJJf1V2/Z82Ka/rJASCwVgCbmrTMOIxe1vNDNYE0pc pzLQrHSXAj0n2fmZ3EbsgZA/Zi822B3Unx0u5+X1RD7QJATpsj3C/UwkG4CQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1711392506; x=1711478906; bh=Ad8wwgLOfYjoxjgaon9+YIkAkH97 2HF1PcL+6xyd6MQ=; b=ltzeUIjiE7LbAng2SoJTfInzyGCHmKfhFanQe9itNoiJ rwHhAIlqqHyR+XxoW0aCnAjawR7B1fzXgy04yr2HWgRkuCICDGf20k8V67o9WbhJ ILn+dumvXuz684ESEQZpHyz3xYo2VRb4CDWcO89JjI8g2RH4Og2bGDw6//OiouVU aLQtMCvgU4UfmmFH2P61mBXUh79Y8fTLuNdXxtKUxCwFzxj4AiK/oPvMOA3k9qt2 gMLo/6mzt2UdTP7DGLcFhDMWXhieIys6LLkA1rGT9O5hQ8+rvu46dGmWgadVBQgs tnOIWUhThZVwoPUe4td44/Dy7gjxqqKq+WyHV2a7/g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudduuddgheejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrf grthhtvghrnhepvdfffeevhfetveffgeeiteefhfdtvdffjeevhfeuteegleduheetvedu ieettddunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh eprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 25 Mar 2024 14:48:25 -0400 (EDT) Date: Mon, 25 Mar 2024 11:48:24 -0700 From: Andres Freund To: Peter Eisentraut Cc: Daniel Gustafsson , vignesh C , Alvaro Herrera , Tom Lane , Robert Haas , PostgreSQL Hackers Subject: Re: pgsql: Clean up role created in new subscription test. Message-ID: <20240325184824.uxbh6o7w4442o4nv@awork3.anarazel.de> References: <202312011219.aikuwve3cbku@alvherre.pgsql> <57373BD5-C0D9-486D-9096-276FE91411D7@yesql.se> <1ECB500B-F76F-4BBE-AE4D-91DDC5E59D7E@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2024-01-19 15:40:21 +0100, Peter Eisentraut wrote: > On 19.01.24 15:26, Daniel Gustafsson wrote: > > > On 18 Jan 2024, at 01:57, vignesh C wrote: > > > > > There are a lot of failures in CFBot at [1] with: > > > > > More details of the same are available at [2]. > > > Do we need to clean up the objects leftover for the reported issues in the test? > > > > Not really, these should not need cleaning up, and it's quite odd that it only > > happens on FreeBSD. I need to investigate further so I'll mark this waiting on > > author in the meantime > > Most likely because only the FreeBSD job uses > ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS. I don't think it's that, but that the freebsd task tests the installcheck equivalent in meson. I haven't checked what your patch is doing, but perhaps the issue is that it's seeing global objects concurrently created by another test? Greetings, Andres Freund