PG 7.4 possible (probable) corruption?

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

PG 7.4 possible (probable) corruption?

От:
"Steve Lane" <slane@soliantconsulting.com>
Дата:
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 in the 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 and extent of the problem?

-- sgl
FAQ