Re: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error
Date: 2002-03-18 02:24:54
Message-ID: 22291.1016418294@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrew Bartley" <abartley(at)evolvosystems(dot)com> writes:
> ERROR: cannot read block 39 of pg_attribute_relid_attnam_index: Input/outp=
> ut error

> Could this be a physical I/O error?

Sure looks like it.

> Can someone tell me what I can do to fix this?

If it's only the index that is hosed, and not any of the tables,
REINDEX should save the day. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-reindex.html

(Even though you're running 7.1, I recommend looking at the 7.2 docs in
this connection --- they're much more complete about how to use
REINDEX.)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Ellis 2002-03-18 04:54:18 Re: locking problems
Previous Message Francisco Reyes 2002-03-18 01:50:54 Re: Maintainer(s) for gborg?