Error: missing chunk number for toast value

Hi All;

We're seeing this error in our 8.3.9 database:

# select * from comments;
ERROR: missing chunk number 0 for toast value 1274882 in pg_toast_49234


I tried this:

# reindex table pg_toast.pg_toast_49234;
REINDEX


but the error still persists.

Thoughts?

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Error: missing chunk number for toast value

Kevin Kempter wrote:

> # select * from comments;
> ERROR: missing chunk number 0 for toast value 1274882 in
> pg_toast_49234
>
>
> I tried this:
>
> # reindex table pg_toast.pg_toast_49234;
> REINDEX
>
>
> but the error still persists.
>
> Thoughts?

Your database is corrupted. Any idea how that happened? As with
any database corruption, I recommend you stop the server and make a
copy of the whole data directory and everything under it before any
recovery attempts.

You could zero in on the damage by selecting specific columns, and
ranges of rows.

A little more detail would be helpful. For ideas, read this:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin