Re: missing chunk number 0 for toast value ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: MIlos Prudek <prudek(at)bvx(dot)cz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: missing chunk number 0 for toast value ...
Date: 2006-05-03 20:40:17
Message-ID: 25742.1146688817@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

MIlos Prudek <prudek(at)bvx(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message [S] Dhandapani 2006-05-03 21:39:54 Help on restoration
Previous Message MIlos Prudek 2006-05-03 20:02:57 missing chunk number 0 for toast value ...