invalid page header in block 52979 of relation "pg_attribute"
От | Steve Crawford |
---|---|
Тема | invalid page header in block 52979 of relation "pg_attribute" |
Дата | |
Msg-id | 200411111446.27181.scrawford@pinpointresearch.com обсуждение исходный текст |
Ответы |
Re: invalid page header in block 52979 of relation "pg_attribute"
|
Список | 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
В списке pgsql-general по дате отправления: