------=_Part_5353_3372136.1207748848285
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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
------=_Part_5353_3372136.1207748848285
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hello all<br><br>my struggle with the database continues (see earlier
thread titled "too many trigger records found for relation
xyz").<br><br>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:<br>
<br>2008-04-09 16:39:25 EEST [18984]: [1-1] FATAL: could not open
relation 1663/16386/544592: No such file or directory<br><br>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.<br>
<br>Regards<br><br>Mikko<br><br><br>
------=_Part_5353_3372136.1207748848285--
|
