Postgres Pro
Downloads
Home   >   mailing lists

Thread: root page error

root page error

From
"A Palmblad"
Date:
Today, queries to one of our tables started giving the following error:
    ERROR: root page xxxx of "primary_index_name" has level 0, expected 3.
 
What would cause that?  We did have a earlier today, methinks they are probably related.  It's a big table, in the neighbourhood of 45 million rows. 
 
How can I fix the problem?
 
-Adam Palmblad

Re: root page error

From
Martijn van Oosterhout
Date:
Dunno about the problem, but "reindex primary_index_name" will probably
fix it...

On Tue, Aug 03, 2004 at 01:04:43PM -0700, A Palmblad wrote:
> Today, queries to one of our tables started giving the following error:
>     ERROR: root page xxxx of "primary_index_name" has level 0, expected 3.
>
> What would cause that?  We did have a earlier today, methinks they are probably related.  It's a big table, in the
neighbourhoodof 45 million rows.   
>
> How can I fix the problem?
>
> -Adam Palmblad
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
Attachment