Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nf0gX-0003d9-Ri for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Apr 2022 14:43:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nf0gW-0008Jj-Ny for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Apr 2022 14:43:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nf0gW-0008Ja-ET for pgsql-hackers@lists.postgresql.org; Thu, 14 Apr 2022 14:43:00 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nf0gU-0003eE-FB for pgsql-hackers@lists.postgresql.org; Thu, 14 Apr 2022 14:42:59 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 23EEgrH51471621; Thu, 14 Apr 2022 10:42:53 -0400 From: Tom Lane To: Robert Haas cc: Andres Freund , Justin Pryzby , Kyotaro Horiguchi , Erik Rijkers , Matthias van de Meent , PostgreSQL Hackers Subject: Re: TRAP: FailedAssertion("HaveRegisteredOrActiveSnapshot()", File: "toast_internals.c", Line: 670, PID: 19403) In-reply-to: References: <20220330.100617.1491348930290941094.horikyota.ntt@gmail.com> <20220330.114613.1177577626285014184.horikyota.ntt@gmail.com> <20220330.175824.936439875658680065.horikyota.ntt@gmail.com> <20220413202819.GR26620@telsasoft.com> <20220414003802.e37dgzkgbi5t7ha4@alap3.anarazel.de> Comments: In-reply-to Robert Haas message dated "Thu, 14 Apr 2022 09:54:55 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1471619.1649947373.1@sss.pgh.pa.us> Date: Thu, 14 Apr 2022 10:42:53 -0400 Message-ID: <1471620.1649947373@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Robert Haas writes: > On Wed, Apr 13, 2022 at 8:38 PM Andres Freund wrote: >> FWIW, that'd just mean it's an old bug that wasn't easily noticeable >> before, not that it's the fault of 277692220. > I think you're still on the hook to do something about it for this > release. I think you're trying to shoot the messenger. As Andres says, 277692220 just exposes that there is some pre-existing bug here. It's probably related to 84f5c2908, so I was planning to take a look at it at some point, but there are a few other higher-priority bugs in the way. I see no point in reverting 277692220. Removing the Assert would prevent, or at least complicate, detection of other similar bugs. And it'd do nothing to help end users, who won't have assertions enabled anyway. regards, tom lane