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.96) (envelope-from ) id 1vISCX-001Ye3-0r for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 13:44:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vISBV-000acg-2L for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 13:43:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vISBV-000acW-1S for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 13:43:53 +0000 Received: from mail-pg1-x52f.google.com ([2607:f8b0:4864:20::52f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vISBT-006NjC-2n for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 13:43:52 +0000 Received: by mail-pg1-x52f.google.com with SMTP id 41be03b00d2f7-b6ceb3b68eeso1848503a12.2 for ; Mon, 10 Nov 2025 05:43:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762782231; x=1763387031; darn=lists.postgresql.org; h=in-reply-to:references:from:subject:to:message-id:date :content-transfer-encoding:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=t6qmNhGRJAvS1fPBq7s1DfnMXCUSRe8qv0MuSl5W4ZM=; b=MrkoOTfX6GcI7h/nzQNOjCeY2dd50Im7MmNFX6f9Gqmknknt1c55YARG/zKVcAlIMR OOS/r+U4pKqA2HZaDgcTJmktMMkQLJhlNl9GMd9XkECCH000jRjnZVLAcn57jWfjDTB9 7fPS8oUo9lpAO3uBc2QaFCfiVIbPKeyxhZjChCoZgrSNRYF1MFNoHA0Pq3jZwOGYCZWk q/ZPdi+Ow5Rex1j9+wLB2Afy6cI7lKqp6Zny8/BA1luweckS0wW6cMinCv+BKrAEtsT9 nOT6MEgw3CABL4EkVZIbD7YO+GYJQQhXtib6s0wNhSe4KbLy3wRWRoNj4L9p4ti+pQZ1 brWA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762782231; x=1763387031; h=in-reply-to:references:from:subject:to:message-id:date :content-transfer-encoding:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=t6qmNhGRJAvS1fPBq7s1DfnMXCUSRe8qv0MuSl5W4ZM=; b=w9LSlX/9aWr9t5ksB77pzC87fHzLpsKaVFnSbl4y2vzSbwWMzqJDNui77gsf7wxIcf 28YJksIDkYM6cSS7DyX756jonUBPJKj/7Y8jysjpSZHWYWitAsNIBa2LbWjsTz1Z3vFm snTt73Yi9ed4obpY0zTPAUrrL/nIYiZjaH+x4oYhzJoSLOpjNoP/1B0Z//yDHsO56uNf GzAfOIaFykiQQZOwkPYGQzydomlTAJpmcr2gO5g2PNCyXR/moHkXxTfIH3Nz5FhaLlon WpMCNB3s6KdJ6jlCy+WopdZno0k6Md8gPQI+M9m/gxT4BMoETM6GcR3xWpv2Erz0fjGp jcxA== X-Forwarded-Encrypted: i=1; AJvYcCUO4HyAQSgldbyhCJNz2c4RhBdwQt57AvK++Rd9HcnRevmgKOUBlUdG/gK4Z2X67/3PFH8OpVOf2Jqp@lists.postgresql.org X-Gm-Message-State: AOJu0YxO4wzoAbwSZh8Pkd8T6sUnVvn7tz4W3ufDtaFhwOVnvArkNolV UkASCgpz2XL/rDEza5v0otCnjiFgxMVC8pNE+enwlI1jE+rM8v8zPmWu X-Gm-Gg: ASbGncstNDJiiXb6Zre0PSjN4D1cJFzsnaspEcUSERghRj6ptN2lWqt+rfzQqKv5rb6 E5K+xSe9+sef0ME/W+kgLdBZpwpfYTt1U9d0Ed8ytxdXt/TOMQYyl+HUgfO06Qa5q6134bRSxeb 2y2rQjSPfTAaEP6EcdL1tzHv9tOf+FQApdriobjO2pUEMkwsxd9/07dMcfAIr1Mz2xzlZWEb6VK aeV8XqzBE0JywSWHDF6sTqJhZmTowxsDoOTp8+iZ/EGDVrY53Wt7Ayx97NEQm6Loi7NAzeI/v07 W5CtEjpifQgAsPpjTIRLLT3H/Ba5O5es+TeB3h/1ylSNnWTLqN4fjnOS4TYe5PgoAScafyTy+jR HwghPZxb+ibk9xI1GAOK1p4XrH8nsHLZplzpXvW3V2cvFgljMpm3A87cwDJaog7un5Yc8pKNvll 4Bof1/K0I/rOL9UqbpYWIjWv8= X-Google-Smtp-Source: AGHT+IHFAcDcHSG3kuMeDCrJOb5TgV6xikHtVwmfyhNcLHmwg4P4veUT6/IIqRB+bIBZZKr6gZcGxA== X-Received: by 2002:a17:902:d4cd:b0:295:6d30:e268 with SMTP id d9443c01a7336-297e57101f6mr125197845ad.59.1762782230827; Mon, 10 Nov 2025 05:43:50 -0800 (PST) Received: from localhost ([2804:14d:328a:a59c:2c5a:e10f:82c2:e167]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-297ed6808ddsm73401625ad.17.2025.11.10.05.43.49 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 10 Nov 2025 05:43:50 -0800 (PST) Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=UTF-8 Date: Mon, 10 Nov 2025 10:43:47 -0300 Message-Id: To: "Smolkin Grigory" , Subject: Re: clog segment truncation From: "Matheus Alcantara" X-Mailer: aerc 0.21.0 References: In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon Nov 10, 2025 at 9:29 AM -03, Smolkin Grigory wrote: > So is it possible that either all_frozen bit was set incorrectly or wansn= 't > unset when tuples were created? > I will be happy to provide any additional information if required. > PostgreSQL version: 15.6, data_checksums: on > Actually the 15.6 is quite old. I would also recommend to upgrade to the latest 15 release which is 15.14. I didn't find any specific release note about clog truncation but you are missing some important fixes though. There is this fix [1] on 15.8 but I'm not sure if it's fully related with your issue faced here. [1] https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommitdiff;h= =3Dc809a2b2d --=20 Matheus Alcantara EDB: http://www.enterprisedb.com