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 1vIRaQ-001E9T-2V for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 13:05:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIRaO-000VCU-1g for pgsql-bugs@arkaria.postgresql.org; Mon, 10 Nov 2025 13:05:32 +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 1vIRaO-000VCM-0N for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 13:05:32 +0000 Received: from mail-pf1-x42d.google.com ([2607:f8b0:4864:20::42d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vIRaM-006NUc-1s for pgsql-bugs@lists.postgresql.org; Mon, 10 Nov 2025 13:05:31 +0000 Received: by mail-pf1-x42d.google.com with SMTP id d2e1a72fcca58-7a435a3fc57so3116495b3a.1 for ; Mon, 10 Nov 2025 05:05:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762779929; x=1763384729; darn=lists.postgresql.org; h=in-reply-to:references:to:from:subject:message-id:date :content-transfer-encoding:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=9PlAnljKTjpG52DMvIN+yLFvF0Pl5JhCPWslbrTsxes=; b=BmLLJxXAh+oa1RzFFQIFkQWXO6OMwLorN0lmjwXbNRAz3JXp9oDUqiS4OQcMF0/seR WAzHUoYN9lU99L0ldAJwrljLtkDnOk3i8o0445DVdkuPZF0WTechd7JOYE3WS28CHwAD 19rI7LXOfNRRKCgdpRGDxzhs4ahVqjYgt7oCMGAAUvdC4MV8B6FbF3siHKHOVn9faNDA 3a75dmvsanSL07RAoe9PQ2vnu5c7cbdgGZoMDkbJJHczc9N5BmDzr+rXpp4Z8O5/O4Bz TM1uODPz3DuQWCd34pWulWRA+suPYYAkcASr7IXY4svvJQEkD40xix6DGYyOuHfF8OaN IRuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762779929; x=1763384729; h=in-reply-to:references:to:from:subject: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=9PlAnljKTjpG52DMvIN+yLFvF0Pl5JhCPWslbrTsxes=; b=EPOL7ob+QNJBA70PbsY+EIKhxpnQl6aT1kXVTLFp1DCQgBzPKdckgtlWeU+/ONLWEd yYhtxH/RXQBNPeAPQnA/Eu9LFUSLSluP2xMKe3jDF3Ld//QrRHQ0RUqVPP9VPlZBKKn9 4Bru6+Bxa6BayOPyzRdk409XWfEVwRIaMWGLSl1HixlfmSIdflj1giZg2UIfaPsKWuVE G8uzSVz1LYqGaK6/SuXX7F2NUsrrhOE90Rr9SR2K2nmBztxLJW7fqnBcsl9z+mFY0pju wHSY3ysR8Y/bD0atl2/Vc8jqSJ5FBE3uVtHxVjW/L0Yg2gDeVt88YSwu2z+2x2i4TuHj ogwA== X-Forwarded-Encrypted: i=1; AJvYcCW0mxB/fhjO1I6hcsCOGkwMV8vFQCHeFOYmSonqCr44mHVTsh6xOHhqsUumlA7QG9KmLjDkkNCp/G5K@lists.postgresql.org X-Gm-Message-State: AOJu0YwYiva9E/JmNE6Qpea2kFBAy4VFqDeuOvKl7MsxVHme/Mna3kt6 Ma/BgUkTtSxxOclX1T1pUFUP7vzRIHTRcWhqcU19zYSk6prIQnFD4aoy X-Gm-Gg: ASbGncsX9sHKKOGPf/8AYdeH4tVa8erHA0rugPYev2V3i0tPj3oGzRzBsQt8Ghgk3hy GU7clqByxcYbXnPnXm8SEkVOrR4YgnZfSNB0+YXoNxkj4vM3Z8Tp4oXEoguueAJlKqhN4izvldx Gi62E5rG27Ee8zBZWYxASkjFqtKjJNZIX9R0ItrqsHIxWKkoMOkuKVaadIwdHKlikXb30LfU9IY DGSs0y0v7YIbB1Lf9akKDye2q4aFHje5+nW17w1PygqQfFO0YkKxyugabGLae8yjoBrIGjfbLmH dAhKojQE1eiwIJV7iVubpsiRWzM+F1ofPygOqfaM5jjwKbG12Vw8yf2F9w8EF9uR4A1lQwSNz1/ i9+/C21jOPH/OfTmIz4amBGTUVan1q96DDsFqmrXOFGDkz4Vnvn5jGSz1vRU/6dswYJrXPApUMX 6qk3CK+YDcKt75nEVFNCafFy9ijpmIhWxrPLCnRTXKZOmw X-Google-Smtp-Source: AGHT+IFuCjScD42swPFKN3r38HdF8Au4jCmwClVisTiyVF//UUDaYzLBlubugjWoSlJefkcl40OwGA== X-Received: by 2002:a05:6a00:4fd4:b0:781:16de:cc1a with SMTP id d2e1a72fcca58-7b22737e23cmr10177597b3a.32.1762779929379; Mon, 10 Nov 2025 05:05:29 -0800 (PST) Received: from localhost ([2804:14d:328a:a59c:2c5a:e10f:82c2:e167]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7b2c83906e5sm7469431b3a.71.2025.11.10.05.05.27 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 10 Nov 2025 05:05:28 -0800 (PST) Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=UTF-8 Date: Mon, 10 Nov 2025 10:05:26 -0300 Message-Id: Subject: Re: clog segment truncation From: "Matheus Alcantara" To: "Smolkin Grigory" , 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: > Hello, hackers! > > I`m currently investigating the case of one of our PostgreSQL instance > having started issuing error messages about missing clog segment: > ERROR: could not access status of transaction 1550558894 > DETAIL: Could not open file "pg_xact/05C6": No such file or directory. > Is this error happening with the LISTEN/NOTIFY? There is a discussion going on [1] that aims to fix this issue for the LISTEN/NOTIFY. [1] https://www.postgresql.org/message-id/CAK98qZ3wZLE-RZJN_Y%2BTFjiTRPPFPB= wNBpBi5K5CU8hUHkzDpw%40mail.gmail.com --=20 Matheus Alcantara EDB: http://www.enterprisedb.com