Re: Invalid page header - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Invalid page header
Date
Msg-id 20031204213919.GA24247@svana.org
Whole thread Raw
In response to Invalid page header  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Looks bad. Have you got backups. Seriously!

REINDEX works on system indexes but you have to drop to single user mode in
postgres to do it. Check out the -P option in the manpage.

Good luck!

Hope this helps,

On Thu, Dec 04, 2003 at 12:54:07PM -0700, Ed L. wrote:
> I have a server with 20 pgsql clusters on it.  I am seeing a slew of errors
> like the following across 5 of these clusters, all running 7.3.4 on Linux
> with kernel 2.4.18-4bigmem:
>
>     ERROR:  Invalid page header in block N of R
>
> N and R vary among block numbers and relation names, respectively.  Looking
> at the archives, it sounds like a possible hardware issue, and we're
> investigating that.  In the meantime, every query that attempts to access
> those blocks errors out.
>
> Taking the server down or losing data is very expensive, so I'm looking for
> some short-term band-aids to re-enable full production access and recover
> data while we sort out the hardware issues.  When the corrupted block is
> within a user index, I've been able to fix the corruption by dropping and
> recreating the index.  Not sure what I can do for user tables yet.
> Preparing to run e2fsck/badblocks after I'm convinced there's nothing more
> to salvage.
>
> Is there anything I can do for invalid page header in a block of
> pg_depend_reference_index?
>
> Other suggestions?
>
> TIA.
>
> Ed
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

Attachment

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: bug in 7.4
Next
From: Robert Treat
Date:
Subject: Re: Misplaced modifier in Postgresql license