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

On Mon, Jun 14, 2010 at 11:28 AM, Shinji Nakajima <sinakaj(at)jops(dot)co(dot)jp> wrote:
> PostgreSQL version: 8.3.8
> Description:        missing chunk number 0 for toast value XXXXX in
> pg_toast_XXXXX
>
> I delete a record, and the system restores, but prime cause is unknown.
> Will this be a bug of the databases?

Probably. Or possibly bad hardware. Assuming you didn't manually go in
and delete that record from the toast table, which would be a strange
thing to do.

The problem is it could have happened a long time ago and you just
discovered it now. Have you had any other significant events on this
machine? Any system crashes or power failures? Any drive crashes or
signs of bad memory?

In the postgres logs are there any instances of unusual error messages
or warnings?

--
greg