Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group