Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5646: missing chunk number 0 for toast - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5646: missing chunk number 0 for toast
Date
Msg-id 1283895706-sup-8779@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #5646: missing chunk number 0 for toast  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: BUG #5646: missing chunk number 0 for toast
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #5640: ODBC driver installed but not found
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART