Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text, WWWXXXAPC.

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