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 1uWlcp-0018Bb-24 for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Jul 2025 00:46:59 +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 1uWlcm-009149-5y for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Jul 2025 00:46:56 +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 1uWlcl-00913q-An for pgsql-hackers@lists.postgresql.org; Wed, 02 Jul 2025 00:46:56 +0000 Received: from fout-a7-smtp.messagingengine.com ([103.168.172.150]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uWlcj-005C2I-02 for pgsql-hackers@postgresql.org; Wed, 02 Jul 2025 00:46:55 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfout.phl.internal (Postfix) with ESMTP id C36A5EC0478; Tue, 1 Jul 2025 20:46:50 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Tue, 01 Jul 2025 20:46:50 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; 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=fm2; t=1751417210; x=1751503610; bh=n9aK0Wlb9E SenN3/Jr7FUObncTKOwMoPT6qI2j42EcE=; b=PIlSidgiz30sPY6ZroOvFB50Qb wqtjXfWPGLLO9KDczorN9hMoeNCQjqiT7jQ9n38qo5cmtB58IFy/y7kw7afV9bBq Cuqr2PWj5aRf5j1mgo1hmJMpYoxjrr1UGdAnQEq0fuRRIBY1GCSTpsKxCJ17YugM NNZOkIYQlgXvOaP5V+eiwqxJ+lYiX13Z1fTxHbpDCPQOJgRphYjvgzVlqKhHQuWW OX/Ve5O1FojYJznykYWi6HFEkpmFsDOP6cAE+FQrjGRk9wdWcM1nGvcG748tMm1d dn2ySho41OhZi5jbcvvjIoJ3QxBiTj1AwDU/MCLSSE95Yja4/U7XRNPXYfyg== 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-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1751417210; x=1751503610; bh=n9aK0Wlb9ESenN3/Jr7FUObncTKOwMoPT6q I2j42EcE=; b=bMwYSOT1RQh68ZztszkqM2sGpmwoCiL0M709C6a0jo5eVjVClN+ 1rEQk4C0CETp4bX/9Mzf0oS8GMrQ939/O/Vbl+NmI5kihLHo5ElOy0/DJBpIgifa ZcKuySjnUHRKSuXrTRJi9Hicd+n0VKras6+p0jubxibRWjGmOISGGTaF14p9QYtH mL7k4Ed8GzMIvs42yM4SJFmr1AGCNxninj+KV7IhIrQkeMOiVPgoK+3dikRf8G5K 350EWbeBayEnWlYBSyLvAPG9tbu6jCr5RaVywWQBTC9JMy4DY4aaAMMyFXYzF90l 7Gsc1sYgVCv5MhoRz0zEOKcikpfmEEiOYCg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdduiedttdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlh cuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvden ucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquh hivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeff hfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurf grrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhn sggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopeiihhhihh huihhfrghnuddvudefseduieefrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghk vghrshesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 1 Jul 2025 20:46:49 -0400 (EDT) Date: Wed, 2 Jul 2025 09:46:42 +0900 From: Michael Paquier To: Andy Fan Cc: PostgreSQL Hackers Subject: Re: A assert failure when initdb with track_commit_timestamp=on Message-ID: References: <87plejmnpy.fsf@163.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="abJrl1HWvLiwLYst" Content-Disposition: inline In-Reply-To: <87plejmnpy.fsf@163.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --abJrl1HWvLiwLYst Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Jul 02, 2025 at 12:38:01AM +0000, Andy Fan wrote: > However this is not true in BootstrapMode, this failure is masked by > default because TransactionTreeSetCommitTsData returns fast when > track_commit_timestamp is off. Agreed that there is no point in registering a commit timestamp in the cases of a frozen and bootstrap XIDs. I would recommend to keep the assertion in TransactionIdSetCommitTs(), though, that still looks useful to me for the many callers of this routine, at least as a sanity check. I did not check, but usually we apply filters based on IsBootstrapProcessingMode() for code paths that we do not want to reach while in bootstrap mode. Could the same be done here? -- Michael --abJrl1HWvLiwLYst Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmhkgXIACgkQnvQgOdby QH2YuQ//fqauKO0gDfVIBn5M83aG8l37gYPonO3pVgtoCnOORYvC0uTQaIjEcGco tlIRkCQ0BeBT8Ph8vFpoVraU3navtRx1zF4HBGK9LBT4aWapSc2f2P+Ve3gSjJlT RWTB7MEERraStu6PqjCBoqfQ9h+ZayyeMT3YFj+QKbhQ8iTAS+Ubg18bfEPc4/3t ws/NQQZLtnKmEVbum+5LkyHOkF92nJ/hAg0CXAqBROczvigIGhadyn3XvieuTxxg fPynW2/CW7a4CNd65Lk3VqkI60UrcmY69OGlr8GfzwowqMVvFMYzbfOZh3UDITOF fRAyDMOWqgOznMq8oOjZfqutDfqfnig33XYzE9Xb7RSmG9JtLSHGTgAaiiK5nj7L NkYaCQT94oxdWyvNFKosl9etg/zOmQveWVgUI6TLR45pGbm9H4ZeqCN9Z6iFDZBT 6pOBI8DujrSF9AIX3d2P1psO6r2vY/fHyroT/37hWlOU+UdJGVpIUzmiChPU6FpP 2m22x0xAnoTRIonPccDWfht7gkjTSvGp25TkeaebOS3p/w47DGKeuLDX1AOZ0i4O BgaFj6LEpujQTDkuLTjvYC9adtVbDc4MCSluSnVZLaeXREG+ortcNPwUuse5F7rb cTROnOM99u2gVbI5UkQjbWyR/T5bnlH6a/qBnyR6LQ1FMtUfF5Y= =KJe7 -----END PGP SIGNATURE----- --abJrl1HWvLiwLYst--