invalid page header in block 52979 of relation "pg_attribute"

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: invalid page header in block 52979 of relation "pg_attribute"
Date: 2004-11-11 22:46:27
Message-ID: 200411111446.27181.scrawford@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS"
from tables without OIDs bug in 7.4.1.

Postmaster killed all the backends and restarted - pg was down for 2
seconds.

This happened two times within a few minute period.

Now I am getting 'invalid page header in block 52979 of relation
"pg_attribute"' errors in the postgresql log file. I cannot reindex
or view the table at all even as user postgres.

I have not tried a manual restart of PG.

Although hardware could be an issue I tend to doubt it. This server
passed an extensive memory test before going into service and I see
no occurrences of this error prior to the crash but several since
then.

This is a 24x7x365 system. I do have a dump from this morning (I do
two per day) but I would prefer to fix the problem with no downtime
or data loss.

What serious problem is this likely to cause/be causing? What are my
options for fixing it?

Naturally, quick replies are appreciated - this is making me very
nervous.

Cheers,
Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-11 23:14:16 Re: invalid page header in block 52979 of relation "pg_attribute"
Previous Message Max 2004-11-11 22:25:19 Re: comp.database.postgresql.*