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
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.* |