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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>
Cc: missing chunk number <chand(dot)vizag(at)gmail(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5646: missing chunk number 0 for toast
Date: 2010-09-07 21:42:50
Message-ID: 1283895706-sup-8779@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Excerpts from Kevin Grittner's message of mar sep 07 11:56:32 -0400 2010:
> "missing chunk number" <chand(dot)vizag(at)gmail(dot)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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2010-09-07 23:28:20 Re: BUG #5629: ALTER SEQUENCE foo START execute a RESTART
Previous Message Craig Ringer 2010-09-07 18:12:49 Re: BUG #5640: ODBC driver installed but not found