Skip site navigation (1) Skip section navigation (2)

Re: cache lookup failed for index

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 (view raw or flat)
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
>

In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2010-06-30 16:13:21
Subject: Re: cache lookup failed for index
Previous:From: Kevin GrittnerDate: 2010-06-30 15:51:12
Subject: Re: cache lookup failed for index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group