From: | Nathan Robertson <nathan(dot)robertson(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: cache lookup failed for index |
Date: | 2010-06-30 16:04:06 |
Message-ID: | AANLkTikHYDu6d9qOrGK9L_t8zKk7znRngY8Tkmvv4BKo@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Kevin,
Thanks for this. I've found a lot of information on this online but I'm a
little unclear about how exactly I should connect and run the reindex.
My thinking based on the documentation is I run (as postgres user):
postgres -O -P -D /dbcluster/location
Then I run:
REINDEX TABLE pg_class_oid_in;
Is this correct?
Nate
On Wed, Jun 30, 2010 at 11:51 AM, Kevin Grittner <
Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Nathan Robertson <nathan(dot)robertson(at)gmail(dot)com> wrote:
>
> > The failure basically happened because the Django webapp we're
> > running isn't effectively closing database connections. So, memory
> > is completely filling up and causing the server to hang.
> > Yesterday, when this happened it caused the entire network
> > interface to become inoperable which meant that the iscsi
> > connection to the shared drive stopped working and data became
> > corrupt.
> >
> > I stopped the postgresql service before unmounting and remounting
> > the target.
>
> OK, I think the appropriate next step would be to try to run the
> PostgreSQL cluster in single-user mode:
>
> http://www.postgresql.org/docs/8.1/interactive/app-postgres.html
>
> Try to REINDEX pg_class_oid_index in that mode. If that fails, it
> might possibly help to run these statements and try the REINDEX
> command again:
>
> set enable_indexscan = off;
> set enable_bitmapscan = off;
>
> I hope this helps.
>
> -Kevin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-06-30 16:13:21 | Re: cache lookup failed for index |
Previous Message | Kevin Grittner | 2010-06-30 15:51:12 | Re: cache lookup failed for index |