pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (2+ messages)  latest in thread

Message-ID: <7DF13FAE-CE2F-406C-98D6-2003D2BED624@o.ptimized.com>
Permalink:  ../7DF13FAE-CE2F-406C-98D6-2003D2BED624@o.ptimized.com/
Also on:    postgresql.org/message-id/7DF13FAE-CE2F-406C-98D6-2003D2BED624@o.ptimized.com

 · 

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