Re: FATAL: index contains unexpected zero page at block

From: VB N <vbnpgc(at)gmail(dot)com>
To: Dmitriy Tyugaev <dtyugaev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FATAL: index contains unexpected zero page at block
Date: 2012-11-14 22:34:09
Message-ID: CAHBAh5tshJ4QbS5=f7PLW2unRo3w_T_rAGbqYw9t=A=9pJ74kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> user=,db= FATAL: index "316879235" contains unexpected zero page at block
> 264
> user=,db= HINT: Please REINDEX it.
>
> Please tell me what can I do to recover?
>

Did you try re-building the index ? Re-Indexing or re-creating an new index
should resolve this.

Regards,
VBN

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2012-11-14 22:38:46 Re: How do query optimizers affect window functions
Previous Message Tianyin Xu 2012-11-14 22:16:29 Re: How do query optimizers affect window functions