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

Re: cache lookup failed for index

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Nathan Robertson" <nathan(dot)robertson(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cache lookup failed for index
Date: 2010-06-30 15:51:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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:
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.

In response to


pgsql-admin by date

Next:From: Nathan RobertsonDate: 2010-06-30 16:04:06
Subject: Re: cache lookup failed for index
Previous:From: Nathan RobertsonDate: 2010-06-30 14:36:14
Subject: Re: cache lookup failed for index

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