"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 по дате отправления: