Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Date
Msg-id AANLkTikpmt-P_FDcLD0ZlTcESOFakcKlMhWG5-AfSmvx@mail.gmail.com
Whole thread Raw
In response to BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX  ("Shinji Nakajima" <sinakaj@jops.co.jp>)
Responses Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
List pgsql-bugs
On Mon, Jun 14, 2010 at 11:28 AM, Shinji Nakajima <sinakaj@jops.co.jp> wrot=
e:
> PostgreSQL version: 8.3.8
> Description: =A0 =A0 =A0 =A0missing 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?

--=20
greg

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Next
From: "Tommy McDaniel"
Date:
Subject: Re: BUG #5505: Busted referential integrity with triggers