Re: missing chunk number 0 for toast value ... - Mailing list pgsql-admin

From Tom Lane
Subject Re: missing chunk number 0 for toast value ...
Date
Msg-id 25742.1146688817@sss.pgh.pa.us
Whole thread Raw
In response to missing chunk number 0 for toast value ...  (MIlos Prudek <prudek@bvx.cz>)
Responses Re: missing chunk number 0 for toast value ...  (MIlos Prudek <prudek@bvx.cz>)
List pgsql-admin
MIlos Prudek <prudek@bvx.cz> writes:
> select * from info;
> ERROR:  missing chunk number 0 for toast value 190937

I was going to suggest the REINDEX, but no luck :-(

> What should I do to salvage the table?

Find the row containing the busted toast reference, and delete that row
(or just UPDATE it with some new value for the toasted column).  You can
home in on it with the usual sorts of search methods --- look in the PG
list archives for previous discussions of locating corrupted rows.

            regards, tom lane

pgsql-admin by date:

Previous
From: MIlos Prudek
Date:
Subject: missing chunk number 0 for toast value ...
Next
From: "[S] Dhandapani"
Date:
Subject: Help on restoration