Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
FATAL: could not open relation xxx: No such file or directory
- From: "Mikko Partio" <mpartio(at)gmail(dot)com>
- To: pgsql-admin(at)postgresql(dot)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(at)mail(dot)gmail(dot)com>
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
- Follow-Ups:
- Re: FATAL: could not open relation xxx: No such file or directory
- From: Mikko Partio
- Re: FATAL: could not open relation xxx: No such file or directory
- Prev by Date: Re: pg_dump/pg_restore
- Next by Date: How do i get DDL of a Table from system catalog ?
- Previous by thread: Recovering records after running out of disk space
- Next by thread: Re: FATAL: could not open relation xxx: No such file or directory
- Indexes: