Re: pg_index_indrelid_index error, any ideas ??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aw_contact(at)inbox(dot)ru
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_index_indrelid_index error, any ideas ??
Date: 2005-09-21 14:55:14
Message-ID: 14515.1127314514@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

aw_contact(at)inbox(dot)ru writes:
> I've got an error from postgresql server -
> "ERROR: root page 1 of "pg_index_indrelid_index" has level 512, expected 0"
> This error appears on every command and i can't do anything with my
> database. Is it possible to solve this problem ?

See REINDEX. Also you ought to run some memory and disk diagnostics
--- it looks like some part of your hardware dropped a bit.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex R. Mosteo 2005-09-21 15:05:22 Re: Problem with libpq3 & postgresql8
Previous Message Tony Wasson 2005-09-21 14:48:36 Re: array_dims array_lower/upper distance