Input/output error

From: "Dan Langille" <dan(at)langille(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Input/output error
Date: 2002-05-10 14:36:42
Message-ID: 20010511103927.0554C3F3F@bast.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This morning I encountered the following error on my 7.2 database:

ERROR: cannot read block 16840 of commits_latest: Input/output error

The table 'commits_latest' was a derived table. I dropped it, created it,
granted the permissions, and ran the stored procedure which populates this
table. All went well and I had my database back and running.

I ran a VACUUM ANALYZE. No problems were reported. Then I ran a VACUUM
full ANALYZE, which went fine.

Any suggestions/recommendations/comments?
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-05-10 15:12:36 Log rotation for postgresql
Previous Message Nick Fankhauser 2002-05-10 14:11:57 A couple of errors encountered in 7.1.3=>7.2.1-2 data migration