PG 7.4 possible (probable) corruption?

Поиск
Список
Период
Сортировка
От Steve Lane
Тема PG 7.4 possible (probable) corruption?
Дата
Msg-id 680F503D41F9B445B51BE1E49A6E35EF09CE44@utopiasystems.net
обсуждение исходный текст
Список pgsql-admin
Hello all:

I'm hoping I'm wrong, but I think I'm looking at a corrupted table or database. We have a column that's
sequence-driven,with a unique index, but we're seeing duplicate values in that column. We're also seeing duplicate OIDs
inthe affected table. And we're seeing this ominous message: 

iep_db=# select distinct * into lavere_form_004 from iep_form_004;
ERROR:  missing chunk number 0 for toast value 42551774

Does this look like some kind of corruption? any particular kind? Any tools out there to help us determine the nature
andextent of the problem? 

-- sgl

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Uwe C. Schroeder"
Дата:
Сообщение: Re: unsubscribe
Следующее
От: Yiqun Lin
Дата:
Сообщение: adduser postgres