Re: "could not read block" error message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter(at)vfemail(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: "could not read block" error message
Date: 2010-01-08 14:33:06
Message-ID: 5250.1262961186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

peter(at)vfemail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Matthew Kirk 2010-01-08 18:31:17 upgrade from 32 bit to 64 bit within same postgresql major release (e.g. 8.3.x)
Previous Message peter 2010-01-08 14:14:38 "could not read block" error message