Обсуждение: BUG #5646: missing chunk number 0 for toast

The following bug has been logged online:

Bug reference:      5646
Logged by:          missing chunk number
Email address:      chand.vizag@gmail.com
PostgreSQL version: 8.3
Operating system:   Linux
Description:        missing chunk number 0 for toast
Details:

Hi,
when i run my table in editor i faced this below error.
Ex: select * from ad_role

ERROR:  missing chunk number 0 for toast value 525559 in pg_toast_325765

********** Error **********

ERROR: missing chunk number 0 for toast value 525559 in pg_toast_325765
SQL state: XX000


How can i solve this error.Can u guide me.

with regards,
chandrasekhar

"missing chunk number" <chand.vizag@gmail.com> wrote:

> when i run my table in editor i faced this below error.
> Ex: select * from ad_role
>
> ERROR:  missing chunk number 0 for toast value 525559 in
> pg_toast_325765
>
> ********** Error **********
>
> ERROR: missing chunk number 0 for toast value 525559 in
> pg_toast_325765
> SQL state: XX000
>
>
> How can i solve this error.Can u guide me.

This is database corruption and extremely unlikely to be a bug in
the current maintenance release of 8.3.  Please read the following
page and post with more information to the pgsql-general list:

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

Your first step, though, should be to stop the PostgreSQL service
and make a complete copy of the data directory and all its
subdirectories, and plan on keeping that until at least a few weeks
after the issue is resolved.

-Kevin

Excerpts from Kevin Grittner's message of mar sep 07 11:56:32 -0400 2010:
> "missing chunk number" <chand.vizag@gmail.com> wrote:
>
> > when i run my table in editor i faced this below error.
> > Ex: select * from ad_role
> >
> > ERROR:  missing chunk number 0 for toast value 525559 in
> > pg_toast_325765

> > How can i solve this error.Can u guide me.
>
> This is database corruption and extremely unlikely to be a bug in
> the current maintenance release of 8.3.

Actually, we seem to get this particular report so often that I have my
doubts about it not being a bug.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Kevin Grittner's message of mar sep 07 11:56:32 -0400 2010:
>> "missing chunk number" <chand.vizag@gmail.com> wrote:
>>> ERROR:  missing chunk number 0 for toast value 525559 in
>>> pg_toast_325765

> Actually, we seem to get this particular report so often that I have my
> doubts about it not being a bug.

I wonder too.  But what we never get is enough evidence to reproduce or
investigate it, if it is a bug.

            regards, tom lane