Postgres Pro
Downloads
Home   >   mailing lists

Re: FATAL: index contains unexpected zero page at block - Mailing list pgsql-general

From VB N
Subject Re: FATAL: index contains unexpected zero page at block
Date
Msg-id CAHBAh5tshJ4QbS5=f7PLW2unRo3w_T_rAGbqYw9t=A=9pJ74kg@mail.gmail.com
Whole thread Raw
In response to FATAL: index contains unexpected zero page at block  (Dmitriy Tyugaev <dtyugaev@gmail.com>)
Responses Re: FATAL: index contains unexpected zero page at block  (Dmitriy Tyugaev <dtyugaev@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Tianyin Xu
Date:
Subject: Re: How do query optimizers affect window functions
Next
From: Jeff Janes
Date:
Subject: Re: How do query optimizers affect window functions