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 1rVZmT-0006sL-BO for pgsql-general@arkaria.postgresql.org; Thu, 01 Feb 2024 16:19:14 +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 1rVZmS-005v5p-FO for pgsql-general@arkaria.postgresql.org; Thu, 01 Feb 2024 16:19:12 +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 1rVZmR-005v5e-Kr for pgsql-general@lists.postgresql.org; Thu, 01 Feb 2024 16:19:12 +0000 Received: from wfout8-smtp.messagingengine.com ([64.147.123.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rVZmN-004vYU-VE for pgsql-general@lists.postgresql.org; Thu, 01 Feb 2024 16:19:11 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailfout.west.internal (Postfix) with ESMTP id 521F31C0008E; Thu, 1 Feb 2024 11:19:04 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 01 Feb 2024 11:19:04 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding: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=1706804343; x=1706890743; bh=820W1qowN7GU+nwjRG+o7eaQxPAGuguH2kBA+WXkzkI=; b= t5avllpK6gLSU1ZsDmCxaP/pe+Bt7zQkN6QExQhR93wpjLDnAUyOTO0J5oPgE3qi 29yqa+ShGxbIB1WRjRJrE88aiEzOt/QUE9nZbuNB2hah+VyjuV/G01tbDSszqvww X3qaohlkf9sDh4oxxc3eTN9X3Lvjt5xnP+XXbF5uTqsoON2KhjOFU8MtsogrLZjV YgbSCq4NEOUwSVb0oZQkuprj/BN4dENwQtP08deo30tJDeKOEC2DQWMBeaLr7IML jGsztiSv6o2EVIJ+2bwEVTMY+/UmG6a8B195pWluSz2lB/PAuaFjcatw0b+MwcgA R2wJ6T+A9j1ZzmSvRlVk7Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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=fm3; t=1706804343; x= 1706890743; bh=820W1qowN7GU+nwjRG+o7eaQxPAGuguH2kBA+WXkzkI=; b=j t5Jb89gjg3XL1sPrC0KooaFGRvc28/4fXdartyVZINQ2JlT/IvwLF1ce7cxbBh6G 4K1EgrxM7EY6cnLkE+/rKw8NAHHxqb05UgUPcBglmNwB5ObL8/wOfoWAGBwb/IRt pW6vcaSuE4C8KpqhxsniWt8/5yKVNt9F0U8HdZ8zsbWnOBp1JTxlfXxoecMcJlHQ /bwaKH6IbD7zQIxoA/07WAlNZ8e1z6mjBQ/gMXPS4p1lcGcJPsASafs4YD7Ozp2y Hr93Nf5X/61ClPGjlOpSifovq6k5rECwZHmbh4YuSHl5PLihJnIRREL6ZN6fnlBI d1AcNCF/7Csgy5JQ4BdDQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrfeduuddgkeefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhepgfdufeekhfevfeelveeiueevhedvuddukeduvddv lefhueeuieejtdeuvdevvdeunecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrgh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughr ihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 1 Feb 2024 11:19:02 -0500 (EST) Message-ID: <3557b7ff-fb5f-4d2f-bd6b-d277e086a336@aklaver.com> Date: Thu, 1 Feb 2024 08:19:02 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Postgresql BUG / Help Needed To: Johnathan Tiamoh , Jehan-Guillaume de Rorthais Cc: Laurenz Albe , "pgsql-generallists.postgresql.org" References: <77117e9ba4045f525307b0e62b1dedb395932f61.camel@cybertec.at> <20240201150615.0bbde2ad@karst> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/1/24 06:10, Johnathan Tiamoh wrote: > I haven't had difficulties in this cluster recently. > > However I upgraded it from  version 9.5 to 14.10  about 3 weeks ago. > Have you being doing any of the things that got you in trouble in this thread: https://www.postgresql.org/message-id/CACoPQdbEoQrusU4RC1o2zEC8CEm4PVdhy6xbH2x_hQPwPOdO%3DQ%40mail.gmail.com and/or this one: https://www.postgresql.org/message-id/CACoPQdZWnrc1ZBGpUBTFE_3Eo2sOV3w%2B5RqPhMHgDe6zNV_1DQ%40mail.gmail.com > > > On Thu, Feb 1, 2024 at 9:06 AM Jehan-Guillaume de Rorthais > > wrote: > > On Thu, 1 Feb 2024 08:28:45 -0500 > Johnathan Tiamoh > wrote: > > > Thank you Laurenz! > > > > Is there a way of preventing this from happening ? > > This could either come from a hardware issue, or easily from your > own actions > or procedures. > > Did you have some difficulties with your instance lately? exceptional > intervention? backup restoration? failover? > -- Adrian Klaver adrian.klaver@aklaver.com