pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Robertson <nathan.robertson@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: cache lookup failed for index
Date: Wed, 30 Jun 2010 16:30:15 -0400
Message-ID: <16649.1277929815@sss.pgh.pa.us> (raw)
In-Reply-To: <AANLkTimfCVD15Wy0ifNx8KRO-DCP3pDTXn9zJKRd-yCd@mail.gmail.com>
References: <AANLkTilzUWnxCjomBRHkByi6tHeS8fDIRNqvU9WCsv1G@mail.gmail.com>
	<4C2B02040200002500032D63@gw.wicourts.gov>
	<AANLkTikYlHg1mVytsX_QQWSf58MTrw-aTIklyv5Zh2KY@mail.gmail.com>
	<4C2B0AEF0200002500032D75@gw.wicourts.gov>
	<AANLkTilfWzYJTo7J39shOutT9bvM9tyxAYa1ZI1rkWeT@mail.gmail.com>
	<4C2B21A00200002500032D8D@gw.wicourts.gov>
	<11712.1277914463@sss.pgh.pa.us>
	<AANLkTim5VFISQ6IVRrtmy9dr1aRJb5fu7n_LUmTVDkak@mail.gmail.com>
	<12643.1277917499@sss.pgh.pa.us>
	<AANLkTikVuefbecakovUG6BGz-pJVFJ04us4YKH8VDQA5@mail.gmail.com>
	<15355.1277925611@sss.pgh.pa.us>
	<AANLkTimfCVD15Wy0ifNx8KRO-DCP3pDTXn9zJKRd-yCd@mail.gmail.com>

Nathan Robertson <nathan.robertson@gmail.com> writes:
> OK, as postgres user:
> -bash-3.2$ postgres -O  -P -D /tmp/database webapp
> FATAL:  cache lookup failed for index 2662

Even with -P?  Wow, that's bad.  This DB may be just toast I'm afraid.
But try it like this:

postgres -O  -P -D /tmp/database -c log_error_verbosity=verbose webapp

This should give you the exact location of the error, which will give us
a bit better clue what's failing.

			regards, tom lane



view thread (16+ messages)  latest in thread

Message-ID: <16649.1277929815@sss.pgh.pa.us>
Permalink:  ../16649.1277929815@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/16649.1277929815@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, nathan.robertson@gmail.com, Kevin.Grittner@wicourts.gov
  Subject: Re: cache lookup failed for index
  In-Reply-To: <16649.1277929815@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox