Обсуждение: HINT: Please REINDEX it?

I am seeing this in my log...:

ERROR:  index "connect_idx" contains unexpected zero page at block 208
HINT:  Please REINDEX it.


What does this mean? And how do I reindex it?



Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

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/

On Thu, 26 Mar 2009 15:32:46 +0000
Sam Mason <sam@samason.me.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