BUG #17384: ERROR: missing chunk number 0 for toast value 152073604 in pg_toast_2619

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: padam(dot)tehlan(at)leptonsoftware(dot)com
Subject: BUG #17384: ERROR: missing chunk number 0 for toast value 152073604 in pg_toast_2619
Date: 2022-01-27 20:57:28
Message-ID: 17384-f50f2eedf541e512@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17384
Logged by: Padam Tehlan
Email address: padam(dot)tehlan(at)leptonsoftware(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: Windows 2012 R2
Description:

Hi,

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.

Thanks!
Padam

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Langote 2022-01-28 06:48:07 Re: The follwing error sometimes happened while updating partitioned table using inheritance; ERROR: attribute xxx of type record has wrong type
Previous Message Tom Lane 2022-01-27 14:52:17 Re: No access to TOAST tables shown in EXPLAIN ( ANALYZE, BUFFERS )