Re: HINT: Please REINDEX it?

On Thu, 26 Mar 2009 15:32:46 +0000
Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:

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

Not any power problem but had a disk problem; guess that might be the cause...
>
> 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!

Almost correct... I am running 8.3.6 now... :)

>
> > And how do I reindex it?
>
> Just type:
>
> REINDEX connect_idx;
>
> in psql.
>

Thx, did that and now the error message is gone...

BTJ