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

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

pgsql-novice by date

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

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