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 1sEnvL-003jhA-Bq for pgsql-bugs@arkaria.postgresql.org; Wed, 05 Jun 2024 10:31:20 +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 1sEnvL-007bIP-Cr for pgsql-bugs@arkaria.postgresql.org; Wed, 05 Jun 2024 10:31:19 +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 1sEnvL-007bI4-3l for pgsql-bugs@lists.postgresql.org; Wed, 05 Jun 2024 10:31:19 +0000 Received: from mx0a-00134001.pphosted.com ([205.220.160.129]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sEnvD-0006PS-PM for pgsql-bugs@lists.postgresql.org; Wed, 05 Jun 2024 10:31:18 +0000 Received: from pps.filterd (m0267960.ppops.net [127.0.0.1]) by mx0a-00134001.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 4554XTVj013154; Wed, 5 Jun 2024 10:31:06 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=optiver.com; h= cc:content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to; s=mail; bh=qf7aL 5P1qS+qqS+ZRwEsPF74Dj4E+BfHF70Hmh/uOaU=; b=YK7KiK39ulGC4Bjf66Zor pHf/8YKnGF5xQmMwhynaSu3r0vgdLXi3xADbBWOOpVPDGKL29cq4T2W+htGGYVkT iLf2q0nrrsp1WJc/hGmoIbSEN15M98UVvhM/0iTh91758thZHtSutarqhr/yfrBe 8xcaB1GFiPjfOUTyHqZU8PdSaWXzBBEJWGTohWBSlq5PGNp/5Rc6X9CCedYxkfjc tle8aXdzPsSnXLr6RA0JpUp/l9/gWlhRodkPnNHLPrPhkc/1+wPculGwYSo8V2k6 1BZ/JIwpYi/SYICOiBQOG1zolGz+RPTxO4O1K3jlnacCPRKXOajXkN49FJYR/8x9 A== Received: from opammb1266.comp.optiver.com ([195.246.114.78]) by mx0a-00134001.pphosted.com (PPS) with ESMTPS id 3yfw3r4yr2-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 05 Jun 2024 10:31:06 +0000 (GMT) Received: from opammb1267.comp.optiver.com (100.68.11.12) by opammb1266.comp.optiver.com (100.68.11.26) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.26; Wed, 5 Jun 2024 12:31:04 +0200 Received: from opammb1267.comp.optiver.com ([fe80::5b6f:1976:98cd:68a7]) by opammb1267.comp.optiver.com ([fe80::5b6f:1976:98cd:68a7%13]) with mapi id 15.02.1118.026; Wed, 5 Jun 2024 12:31:04 +0200 From: Floris Van Nee To: Michael Paquier CC: Andres Freund , Tom Lane , "pgsql-bugs@lists.postgresql.org" Thread-Topic: [External] Re: error "can only drop stats once" brings down database [External] Thread-Index: AQHaZC2BJX3cZ68Gf0SnR3ukCGL5orGGQZEwgALhs4CAAGv+AIAsEUZQgAHuzgCAAg6I8A== Date: Wed, 5 Jun 2024 10:31:04 +0000 Message-ID: <68430b1b76d44558b7b07ae8c69151f6@Optiver.com> References: <215498.1708454947@sss.pgh.pa.us> <8e5cb534706a4f43bd74405c8fd91437@Optiver.com> <20240505160915.6boysum4f34siqct@awork3.anarazel.de> <20240505223546.6yvjzgqifuoiii3e@awork3.anarazel.de> <47ca6fcc687e408287871f7eaaaf3c3b@Optiver.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [100.68.31.122] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Subject: RE: error "can only drop stats once" brings down database X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16 definitions=2024-06-05_01,2024-06-05_02,2024-05-17_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >=20 > The only reason why I did not do one or the other yet is that this is an > improvement, hence I was waiting for v18 to open. If somebody feels > differently, feel free to proceed before that with the format you like. = Still I'd > vote for the addition of the refcount to the patch proposed on this threa= d, to > provide more debugging info to the information reported. This patch would help in getting more info about this specific issue if it = reoccurs, but in that case it's only helpful if it's backpatched. Agree the refcount addition makes sense. -Floris