pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mikko Partio <mpartio@gmail.com>
To: pgsql-admin@postgresql.org
Subject: FATAL: could not open relation xxx: No such file or directory
Date: Wed, 9 Apr 2008 16:47:28 +0300
Message-ID: <2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com> (raw)

Hello all

my struggle with the database continues (see earlier thread titled "too many
trigger records found for relation xyz").

Today, I created yet another to table to the same database. Everything went
ok, no errors or anything, but when I checked pg_tables -view I saw two
tables with the same name. Instantly I queried pg_class and yes there was
again two tables with same oid. I dropped the table before anything more
serious could happen, but then postgres started to complain of "cache lookup
failed for relation ...". I disconnected my psql session and tried to
reconnect but failed to do so:

2008-04-09 16:39:25 EEST [18984]: [1-1] FATAL:  could not open relation
1663/16386/544592: No such file or directory

Indeed, there is no such file in that directory. I'm guessing that file is
connected to the table I just dropped. Now, is there anything to do to get
the database back online? I can still connect to other databases in the same
instance.

Regards

Mikko

view thread (14+ messages)  latest in thread

Message-ID: <2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com>
Permalink:  ../2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com/
Also on:    postgresql.org/message-id/2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com

 · 

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: mpartio@gmail.com
  Subject: Re: FATAL: could not open relation xxx: No such file or directory
  In-Reply-To: <2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com>

* 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