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

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Дата
Msg-id 4C1600060200002500032291@gw.wicourts.gov
обсуждение исходный текст
Ответ на BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX  ("Shinji Nakajima" <sinakaj@jops.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Следующее
От: Greg Stark
Дата:
Сообщение: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX