From: Thomas F. O'Connell <tf@o.ptimized.com>
To: pgsql-admin@postgresql.org
Subject: Block Read Error: Success?
Date: Wed, 13 Feb 2008 15:21:08 -0600
Message-ID: <7DF13FAE-CE2F-406C-98D6-2003D2BED624@o.ptimized.com> (raw)
A few days ago, we began seeing this error in our logs:
ERROR: could not read block [redacted] of relation [redacted]: Success
I've encountered "could not read block" errors in other databases in
the past, but have never witnessed the "Success" tag at the end. What
does that mean?
The error went unnoticed until, ultimately, significant parts of a
database-driven website were not able to be read. Backups had been
collected for days using pg_dump (which is configured to output SQL),
and we were able to restore from a backup created earlier on the day
that the content became unavailable. After restoration from backup,
we haven't seen the errors again.
We're running 8.0.13 on FC3. Is there any reason not to suspect the
hardware at this point?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
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: tf@o.ptimized.com
Subject: Re: Block Read Error: Success?
In-Reply-To: <7DF13FAE-CE2F-406C-98D6-2003D2BED624@o.ptimized.com>
* 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