Re: HINT: Please REINDEX it? - Mailing list pgsql-general

From Sam Mason
Subject Re: HINT: Please REINDEX it?
Date
Msg-id 20090326153246.GH12225@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to HINT: Please REINDEX it?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: HINT: Please REINDEX it?  (Bjørn T Johansen <btj@havleik.no>)
List pgsql-general
On Thu, Mar 26, 2009 at 09:00:53AM +0100, Bjørn T Johansen wrote:
> ERROR:  index "connect_idx" contains unexpected zero page at block 208
> HINT:  Please REINDEX it.
>
> What does this mean?

It means something bad has happened to an index.  If you're running
an old version of PG then you may be affected by a known bug or you
could have bad hardware.  Did the computer have its power turned off
unexpectedly, as if things are set up right then this could affect
things.

I've just had a quick search and you seemed to be running 8.3.5 before,
there don't seem to be any index related changes since then so maybe
your hardware isn't doing what it's told to!

> And how do I reindex it?

Just type:

  REINDEX connect_idx;

in psql.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: log shipping from 64 bit linux server to a 32 bit linux server
Next
From: Tom Lane
Date:
Subject: Re: Weird encoding behavior