From: Justin Pryzby <pryzby@telsasoft.com>
To: padam.tehlan@leptonsoftware.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17384: ERROR: missing chunk number 0 for toast value 152073604 in pg_toast_2619
Date: Wed, 2 Feb 2022 22:42:57 -0600
Message-ID: <20220203044257.GH23027@telsasoft.com> (raw)
In-Reply-To: <17384-f50f2eedf541e512@postgresql.org>
References: <17384-f50f2eedf541e512@postgresql.org>
On Thu, Jan 27, 2022 at 08:57:28PM +0000, PG Bug reporting form wrote:
> Issue: ERROR: missing chunk number 0 for toast value 152073604 in
> pg_toast_2619
> we are facing issue with mentioned short description error while trying any
> operation on database.
>
> We execute the various commands recommended in various blogs , given
> below-
> REINDEX table mytable;
> REINDEX table pg_toast.pg_toast_40948;
> VACUUM analyze mytable;
>
> Even after successful execution of the above commands, still when execute
> the Vacuum full its give error.
>
> Earlier response will be appreciable.
It sounds like the statistics for a catalog table are causing an error.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: pryzby@telsasoft.com, padam.tehlan@leptonsoftware.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17384: ERROR: missing chunk number 0 for toast value 152073604 in pg_toast_2619
In-Reply-To: <20220203044257.GH23027@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox