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

From Kevin Grittner
Subject Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Date
Msg-id 4C1600060200002500032291@gw.wicourts.gov
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>)
List pgsql-bugs
"Shinji Nakajima" <sinakaj@jops.co.jp> wrote:

> Error message called "missing chunk number" occurred when I did
> select of the specific column of the specific table.

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

Errors like this are usually caused by hardware problems.  I think
the second-most common cause is running in a configuration with
fsync = off or full_page_writes = off, and suffering a power outage
or OS crash.  I would recommend that you check your configuration
for these unsafe settings and schedule a check of your hardware and
drivers.

-Kevin

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Next
From: Greg Stark
Date:
Subject: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX