Re: Invalid page header

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Invalid page header
Date: 2003-12-04 21:39:19
Message-ID: 20031204213919.GA24247@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2003-12-04 22:02:05 Re: Misplaced modifier in Postgresql license
Previous Message Greg Stark 2003-12-04 21:18:38 Re: bug in 7.4