Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: tsuraan <tsuraan(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.
Date: 2018-10-30 23:23:43
Message-ID: 875zxj6my1.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "tsuraan" == tsuraan <tsuraan(at)gmail(dot)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)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2018-10-31 07:08:47 Re: BEFORE triggers that return NULL can circumvent referential integrity
Previous Message Andres Freund 2018-10-30 23:09:31 Re: BUG #15114: logical decoding Segmentation fault