pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Juliann Meyer <Julie.Meyer@noaa.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: vacuumdb problem v7.4.8
Date: Tue, 10 Jul 2007 11:38:29 -0400
Message-ID: <20229.1184081909@sss.pgh.pa.us> (raw)
In-Reply-To: <469391AD.3030206@noaa.gov>
References: <469391AD.3030206@noaa.gov>

Juliann Meyer <Julie.Meyer@noaa.gov> writes:
>    vacuumdb: vacuuming of database "adb_ob72orn" failed: ERROR:  could not
>    read block 18658 of relation "pecrsep_time_ind": Input/output error

This says read() failed with errno EIO, ie the operating system reported
a hardware failure while trying to read that disk block.

> The Elec. Technicians at first thought it was an issue with one of the 
> hard drives, but a very thorough check of the hardware has eliminated 
> this possibility.

Not thorough enough I would say, because there is no other cause of that
error code than hardware problems.

You do know that PG 7.4.8 is nine minor releases behind the times?
That's not the cause of your immediate problem, but personally
I'd suggest an update before some other bug bites you.  See
http://developer.postgresql.org/pgdocs/postgres/release.html

			regards, tom lane



view thread (2+ messages)

Message-ID: <20229.1184081909@sss.pgh.pa.us>
Permalink:  ../20229.1184081909@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/20229.1184081909@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Julie.Meyer@noaa.gov
  Subject: Re: vacuumdb problem v7.4.8
  In-Reply-To: <20229.1184081909@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox