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
Дата
Msg-id AANLkTikpmt-P_FDcLD0ZlTcESOFakcKlMhWG5-AfSmvx@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX  ("Shinji Nakajima" <sinakaj@jops.co.jp>)
Ответы Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX
Следующее
От: "Tommy McDaniel"
Дата:
Сообщение: Re: BUG #5505: Busted referential integrity with triggers