Re: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error
Дата
Msg-id 22291.1016418294@sss.pgh.pa.us
обсуждение исходный текст
Ответ на cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error  ("Andrew Bartley" <abartley@evolvosystems.com>)
Список pgsql-general
"Andrew Bartley" <abartley@evolvosystems.com> writes:
> ERROR:  cannot read block 39 of pg_attribute_relid_attnam_index: Input/outp=
> ut error

> Could this be a physical I/O error?

Sure looks like it.

> Can someone tell me what I can do to fix this?

If it's only the index that is hosed, and not any of the tables,
REINDEX should save the day.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-reindex.html

(Even though you're running 7.1, I recommend looking at the 7.2 docs in
this connection --- they're much more complete about how to use
REINDEX.)

            regards, tom lane

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Maintainer(s) for gborg?
Следующее
От: "Jonathan Ellis"
Дата:
Сообщение: Re: locking problems