cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error

From: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error
Date: 2002-03-17 23:53:09
Message-ID: 001f01c1ce0e$e408a3c0$3200a8c0@abartleypc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are using Postgres 7.1.3.

I run a nightly cron that drops all of the application table indexes then unload and reload the most heavily used tables to ensure they are in key sequence, then vacuum analyse the whole DB, recreate the indexes and triggers.

Over the weekend, this error appeared.

ERROR: cannot read block 39 of pg_attribute_relid_attnam_index: Input/output error
vacuumdb: vacuum evolvo failed

Could this be a physical I/O error?

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

Thanks

Andrew Bartley.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-03-17 23:55:45 Re: Why is it not using an index?
Previous Message Stephan Szabo 2002-03-17 21:37:19 Re: [ODBC] ODBC