Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shinji Nakajima" <sinakaj(at)jops(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Date: 2010-06-14 15:06:21
Message-ID: 13288.1276527981@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Shinji Nakajima" <sinakaj(at)jops(dot)co(dot)jp> writes:
> Error message called "missing chunk number" occurred when I did select of
> the specific column of the specific table.

This might indicate that the toast table's index was corrupted.

> I delete a record, and the system restores, but prime cause is unknown.
> Will this be a bug of the databases?

Perhaps, but there's not a lot we can do without a lot more information...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2010-06-14 15:09:51 Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Previous Message Tom Lane 2010-06-14 14:20:24 Re: BUG #5506: Error in the grammar of de joins