Re: BUG #5646: missing chunk number 0 for toast

"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