Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Error: missing chunk number for toast value

Posted on 2010-08-17 22:38:39 by Kevin Kempter

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

Report this message

#2: Re: Error: missing chunk number for toast value

Posted on 2010-08-17 22:54:06 by Kevin Grittner

Kevin Kempter <cs_dba@consistentstate.com> 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

Report this message