Обсуждение: PG 7.4 possible (probable) corruption?

Поиск
Список
Период
Сортировка

PG 7.4 possible (probable) corruption?

От
"Steve Lane"
Дата:
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