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 1sFQ2O-00275x-Sj for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Jun 2024 03:13:09 +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 1sFQ2M-006nQ0-Qq for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Jun 2024 03:13:07 +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 1sFQ2L-006nHT-U8 for pgsql-bugs@lists.postgresql.org; Fri, 07 Jun 2024 03:13:07 +0000 Received: from wfhigh6-smtp.messagingengine.com ([64.147.123.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFQ2J-000OJg-OM for pgsql-bugs@lists.postgresql.org; Fri, 07 Jun 2024 03:13:06 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.west.internal (Postfix) with ESMTP id D85CE18000F4; Thu, 6 Jun 2024 23:13:00 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 06 Jun 2024 23:13:01 -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=fm1; t=1717729980; x=1717816380; bh=i8LPQ/7/Y9 JnMIGwf5HpaSUltaue6GsTvreW9BVUIps=; b=CcDm5NnahMYvw9IDjgyJ77i/mS HkKOSzStGlT3DLFgKh13DOUd0xBCiWMvezciiQheS0N+GPgnHhDkuKErwRV/ZRR5 8/NfNYh+PNIFoQ9yFq0Fuhh0BwHmCco1hNDIXIvp5BGp+Pg48ktSj5QNfL9z14UF EbbDgWFYhNMJcMPf/Ss4jjQ99ZvSMUhmpBRpL6Lb/vffgpiRjOEhS3JX9TIFP3i2 dzAa3xhx1og+dRmb8QvMG+DUQ4LPgPlcM1mSTBZvM7BvQaqro3zltuV58lH6tIWq 8k5UzHGcl43hPHF5e+3d20iUycS/9v0LOTZzIDyt/l0NbFsfyVw9npm6y7SA== 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= fm1; t=1717729980; x=1717816380; bh=i8LPQ/7/Y9JnMIGwf5HpaSUltaue 6GsTvreW9BVUIps=; b=Rn0vUdfsO4B/kmPuMmg6BFTjZma8/hLi4hYrPytA5qyq tMYsgg70e0r1ccEr3QI+DKVzrKqMif+tyV8OpyoKSuhQwZs2lTUQqnjDx5Laz3Ds /63HutipvWHWqYNycRNwVbw37qPC/p8rrYEf+LuhA3PlU7fzf5jBjN1j1NBmO3ze LaMvCCyhohR+hp+hcTDRILC5Hlqpo5DaSL5NGvtAxDTy1qDWIxwitXHdt6Abl0TK mFcUkgFIegwQ9DW7A2MaKjUFJjelrilX0uke4GolwcNE0WKufQZ/ZQQWaCEr0KNP k71CygeLaJTz8O1duZ/K4lEXzrJVjzki0QFHNqpgXg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdelledgieejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrf grthhtvghrnhepvdfffeevhfetveffgeeiteefhfdtvdffjeevhfeuteegleduheetvedu ieettddunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh eprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 6 Jun 2024 23:12:59 -0400 (EDT) Date: Thu, 6 Jun 2024 20:12:58 -0700 From: Andres Freund To: Michael Paquier Cc: Kyotaro Horiguchi , bertranddrouvot.pg@gmail.com, florisvannee@optiver.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org Subject: Re: error "can only drop stats once" brings down database Message-ID: <20240607031258.l4fcpvulo3uee5g6@awork3.anarazel.de> References: <68430b1b76d44558b7b07ae8c69151f6@Optiver.com> <20240607.101540.1972690976596948719.horikyota.ntt@gmail.com> 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 On 2024-06-07 11:46:04 +0900, Michael Paquier wrote: > On Fri, Jun 07, 2024 at 10:15:40AM +0900, Kyotaro Horiguchi wrote: > > To me, this is something that is not expected to happen, but if it > > does, we would want detailed information. In that sense, it might be > > better not to hide it in the DETAILS field. > > Same arguments here. A simple elog() makes easier to get to this > data. +1