"could not read block" error message

Поиск
Список
Период
Сортировка
От peter@vfemail.net
Тема "could not read block" error message
Дата
Msg-id 20100108142337.E05FC632211@mail.postgresql.org
обсуждение исходный текст
Ответы Re: "could not read block" error message
Список pgsql-novice
I have a perl script that's worked flawlessly for years to extract data from a PostgreSQL database and write the data
toa text file once a day.  The script is now terminating abnormally with this message: 

     DBD::Pg::db selectall_arrayref failed: ERROR:
     could not read block 53044 of relation "news":
     Input/output error at {script name} line 93.

The FreeBSD box hosting PostgreSQL shows this recurring message in its /var/log/messages file:

     postgres[18215]: [52-1] ERROR:  could not read block 53044 of relation "{xyz}": Input/output error

Are these error messages pointing to:

     (A) a physical defect on the hard drive;

     (B) something that's gone haywire inside the database; or

     (C) something else?




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error on Vacuum?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "could not read block" error message