Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

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