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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1sineN-009XTb-G3
	for pgsql-admin@arkaria.postgresql.org; Tue, 27 Aug 2024 04:17:47 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1sineL-001UWK-2W
	for pgsql-admin@arkaria.postgresql.org; Tue, 27 Aug 2024 04:17:45 +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.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1sineK-001UTS-JX
	for pgsql-admin@lists.postgresql.org; Tue, 27 Aug 2024 04:17:45 +0000
Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1sineI-001cqP-5G
	for pgsql-admin@lists.postgresql.org; Tue, 27 Aug 2024 04:17:43 +0000
Received: by mail-ej1-x62e.google.com with SMTP id
 a640c23a62f3a-a867a564911so595789266b.2
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 26 Aug 2024 21:17:41 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1724732260;
 x=1725337060; darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=JOIPkF5nPpVm5I5iFcrYlXHomosaaoArTOwe+2lRJLY=;
        b=y2Qq3aX/OPLRnSZN01Mvo1bnX2uBDsYkO3d4Yk4QjcFiClcwXfjLk6JgCmb18MKPGF
         9jd5/fbSL/WGIKCxplja8Np4AciZwh7DPj/6WSO/TJD9u6daqzHJMtXLkJAnmAyk2sCm
         2BWvIo3ige+uG9v/whK1a9dUZu91R9OVXwkbS1nRZUeyrAHygyDtERJ5j4mNtyOZ2hTt
         NoaQBhoGfaxCE3eWyqI1faZ8Yx6rXVdXmcAMPnr0Y97KmcNy+lUrYic2QEdbDiJIG6aa
         1K5mSp+oFXd3QorYKjUYwazop6Zg7HVWhzJhNGRMdgYAdka1RFFR6l1kVBz0x3psMrrc
         gUAg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1724732260; x=1725337060;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=JOIPkF5nPpVm5I5iFcrYlXHomosaaoArTOwe+2lRJLY=;
        b=R3ElmM7BXoRD3sP0TbxKgdc3I5pJKnhXEwjRZhjMeSoD5CdvaArVz4eFpC8W7pzjEH
         b1xdPFsolSqy+kIaHHN3AeBJgTth4K/2HqOU4SgzFbzzHKLj9iXGUVX6ZyRy0A0LTizT
         OAaXcPLGjv6J9d8Hf40KA8bgSmV1ecfOtuQO1bGrp7gFU5QyFu1MMLtOHkuYFxmU2jy+
         cULPU+ikw86wOD9Dx0Y8k89nikfa9ZqYc8rGglKYCDCdT8GVnx3GL+YEzxEw67us/XwU
         d4TPV+zY2MLa5gUa6eEStPZA03fKqBr0B/GyFFvDm/hlbq/b/OgxHYRVIHXykd0KsNHA
         3r7w==
X-Forwarded-Encrypted: i=1;
 AJvYcCUw8ca2ls9FTj79gGKWwdXkpFk/83taENFMeIjlde/xuqPQiHIB6WQgzFh2IsYzaOQy9opBndTXKVsJlQ==@lists.postgresql.org
X-Gm-Message-State: AOJu0YwhoAWVnSCJ0Zg4yfFWC6CIxecC0T9Utj1qY9MtKZfRvdC95LAw
	5ZwSQ/LCkl+pqlPnAsRBzJ30VVzXB5jmFFo2qZayx8O5spaCMklpYVZccWZXlv4=
X-Google-Smtp-Source: 
 AGHT+IHcRxALfILdzvpX2JpJmMdUmkcxv+vFBbPya0ZYE5yABK9CGqXAyE2wfZxaVfJpl7b+sw2ZPA==
X-Received: by 2002:a17:907:9725:b0:a86:a41c:29e with SMTP id
 a640c23a62f3a-a86a51659b8mr798430166b.2.1724732260173;
        Mon, 26 Aug 2024 21:17:40 -0700 (PDT)
Received: from dynamic-pd01.res.v6.highway.a1.net
 ([2001:871:260:52c8:9387:8d5:1d7c:eff5])
        by smtp.gmail.com with ESMTPSA id
 a640c23a62f3a-a86e54851d9sm56447566b.24.2024.08.26.21.17.39
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 26 Aug 2024 21:17:39 -0700 (PDT)
Message-ID: <1f386f506f89e04420715a25d7f7d46f763de1e4.camel@cybertec.at>
Subject: Re: LIsten Errror
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: tiamoh m <tiamohm25@gmail.com>, pgsql-admin@lists.postgresql.org
Date: Tue, 27 Aug 2024 06:17:39 +0200
In-Reply-To: 
 <CAPsGGUpHS66meRBToi9RpSPtsq9qrK+7_cXnBiN0rREbD9jj1A@mail.gmail.com>
References: 
	<CAPsGGUpHS66meRBToi9RpSPtsq9qrK+7_cXnBiN0rREbD9jj1A@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/1f386f506f89e04420715a25d7f7d46f763de1e4.camel%40cybertec.at>
Precedence: bulk

On Wed, 2024-08-14 at 13:00 -0400, tiamoh m wrote:
> We keep having these errors=C2=A0 below in our different clusters.
>=20
> LISTEN| PGE-58P01: ERROR:=C2=A0 could not access status of transaction 45=
43382428
>=20
> When it starts=C2=A0occurring, so far the only way to stop it has been to=
 restart.=C2=A0=C2=A0
>=20
> Is there any permanent=C2=A0fix for this=C2=A0issue?

This can happen if you have transactions that are open for a very long time=
.
Avoid such transactions.

Yours,
Laurenz Albe