"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