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 1ng4zv-0001ml-Mg for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Apr 2022 13:31:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ng4zt-0007L0-9m for pgsql-hackers@arkaria.postgresql.org; Sun, 17 Apr 2022 13:31:25 +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 1ng4zr-0007Kr-12 for pgsql-hackers@lists.postgresql.org; Sun, 17 Apr 2022 13:31:24 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ng4zj-0002RI-Sm for pgsql-hackers@lists.postgresql.org; Sun, 17 Apr 2022 13:31:21 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 8885F5C00C6; Sun, 17 Apr 2022 09:31:14 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 17 Apr 2022 09:31:14 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1650202274; x=1650288674; bh=OQwObDh3Ll wuUbv/tkepDoULv9ijxgzfzeRQoMo4xyk=; b=D1NvHqnm5/4WewYOGJtIOeBJr7 TViLCdiQSp+PaY/6mjhlrW6ywq4ssiIGVD7NLdPGgw/65JkGyvcsWxLYcKp+u9uw riON7XMXu4r2Gqb1Y9SZYjFEhVWYBSBkh6QrH/DNEOPOBojIDEZf0ilgEf/B/PJN J5+a24W3v9HiQntTiTZSCT2ttKZ2FgGTzlLcJh8irSKZIA7KZAATSRQoEs3cNl9D hK45QImGB7mFbkRUhh/PnJfQYbmT8SLCPLN/+ap3561OCEjJQYdGFgIkZAaQ/Fce Ai8gcsd59GYY4sFsd+t1vo8pgsSsy6ItYa63FrvnC8wT3Fc2unV6t3Wy/nMQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1650202274; x= 1650288674; bh=OQwObDh3LlwuUbv/tkepDoULv9ijxgzfzeRQoMo4xyk=; b=P sw19FVZhUbmhy3W67j6RZZCX4Y72qDNhWnuBsCJg3rdBldc4w8IGV3a8W4LGAj3Y KGwyCzrt1vmjFIYCsYOQYNvzwG/NLRDQeQXLQZms6RRfN2u3jWL25G3cQbG6SIop iW4lkghNFSudkm38RsZhMqXF7W+J/3I+LWY5YQHD4AbDQWh7A4OPUVbXKmCb79SO 9pZMl+GXuuox9XQ5DspWHOjO9J4ocpMsWaxdGvNy14Y+ek2OPBwhjr8Y2zJya5iJ 8FMieDt32ZgSgAAKjSzpy86HPyZ2g6/8LAi52d3ZPYvZT9xvjFPKLsQiHcb1ci5s XZ61G5CoXOnPka0UTsoqg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudelledgieekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedukefhkeelueegveetheelffffjeegleeuudelfeefuedtleffueejfffh ueffudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 17 Apr 2022 09:31:13 -0400 (EDT) Date: Sun, 17 Apr 2022 06:31:12 -0700 From: Andres Freund To: Tom Lane Cc: Robert Haas , 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) Message-ID: <20220417133112.phzg25rs66w5zipv@alap3.anarazel.de> References: <20220414165425.pxn22hdlwdrcouh6@alap3.anarazel.de> <1527714.1649957811@sss.pgh.pa.us> <1535399.1649963150@sss.pgh.pa.us> <1542208.1649967960@sss.pgh.pa.us> <1971135.1650134559@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1971135.1650134559@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-04-16 14:42:39 -0400, Tom Lane wrote: > In the meantime, since it's clear that HaveRegisteredOrActiveSnapshot > is failing to meet its contract, I'm going to go fix it. +1 > I think (based on the above argument) that what it intends to enforce > is not really the system design we need, but it certainly isn't > helping anyone that it enforces that design incorrectly. I think it's approximately right for the current caller. But that caller likely needs an improved design around snapshots... Greetings, Andres Freund