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
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