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?

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJan 8, '10 at 2:23p
activeJan 8, '10 at 2:33p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Peter: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase