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_roleERROR: 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: XX000How 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_roleERROR: 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