Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing. - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.
Date
Msg-id 875zxj6my1.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400"is missing.  (tsuraan <tsuraan@gmail.com>)
Responses Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400"is missing.  (tsuraan <tsuraan@gmail.com>)
List pgsql-bugs
>>>>> "tsuraan" == tsuraan  <tsuraan@gmail.com> writes:

 >> What is in the pg_database row (especially the dattablespace column) for
 >> that database?

 tsuraan> Well, that can't be good:

 tsuraan> psql (10.1)
 tsuraan> Type "help" for help.

 tsuraan> root=# select * from pg_database;
 tsuraan> ERROR:  cache lookup failed for type 0

 tsuraan> I get that both on the original system (running 10.1) and on
 tsuraan> my up-to-date system that's running 10.5.

Does that error persist if you delete all files named pg_internal.init
in the data dir? (those files are a cache of the system tables and are
regenerated on the next new connection if they are missing)

-- 
Andrew (irc:RhodiumToad)


pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #15114: logical decoding Segmentation fault
Next
From: Pavel Stehule
Date:
Subject: Re: BEFORE triggers that return NULL can circumvent referential integrity