"could not read block" error message

From: peter(at)vfemail(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: "could not read block" error message
Date: 2010-01-08 14:14:38
Message-ID: 20100108142337.E05FC632211@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I have a perl script that's worked flawlessly for years to extract data from a PostgreSQL database and write the data to a 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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-01-08 14:33:06 Re: "could not read block" error message
Previous Message Tom Lane 2010-01-07 14:40:41 Re: Error on Vacuum?