Re: Error: missing chunk number ...

On Mon, 5 Aug 2002, Neophytos Demetriou wrote:

> >
> >
> >Bizarre.  Evidently there's something broken about the TOAST data for
> >your table.  I am thinking that the toast table's index might be
> >corrupt, in which case you could probably recover by reindexing that
> >index.
> >
> 
> That's it! Doing the following fixed the problem:
> 
>  ./oid2name -d xxxxx-db -t rss_channels
> Oid of table rss_channels from database "xxxxx-db":
> _______________________________
> 796690 = rss_channels
> 
> backend> reindex index pg_toast_796690_idx;
> 
> I still don't know what caused this but I'll wait a bit and see how it 
> goes -- this was not the first time I had this problem. In the past 
> (couple of weeks), I  used to drop and recreate the table to resolve this.
> 

If you can, run memtest86 on the machine for 24 hours. Probably a hardware
memory problem.

Gavin