Skip site navigation (1) Skip section navigation (2)

"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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group