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

  • Tom Lane at Jan 8, 2010 at 2:33 pm

    peter@vfemail.net writes:
    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.
    "Input/output error" generally means a hardware problem. You might try
    looking in the kernel log to see if there's any more info there.

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
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