Re: Error: missing chunk number ...

From: Neophytos Demetriou <k2pts(at)cytanet(dot)com(dot)cy>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Error: missing chunk number ...
Date: 2002-08-05 09:21:18
Message-ID: 3D4E438E.2010808@cytanet.com.cy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
>
>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.

Thanks for the help.

Best wishes,
Neophytos

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neophytos Demetriou 2002-08-05 13:21:19 Re: Error: missing chunk number ...
Previous Message Gavin Sherry 2002-08-05 09:10:22 Re: Error: missing chunk number ...