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

From: tsuraan <tsuraan(at)gmail(dot)com>
To: andrew(at)tao11(dot)riddles(dot)org(dot)uk
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 13:26:10
Message-ID: CALKcMwKE4ssO_14vrHW3HvsJE79FNV=o9Ln_t2AHG-mUyWSeZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> PG> [2018-10-29 15:51:30 UTC]STATEMENT: INSERT INTO ... RETURNING inserted
> PG> [2018-10-29 15:52:05 UTC]FATAL: database "db" does not exist
> PG> [2018-10-29 15:52:05 UTC]DETAIL: The database subdirectory
> PG> "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.
>
> What is in the pg_database row (especially the dattablespace column) for
> that database?

Well, that can't be good:

psql (10.1)
Type "help" for help.

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

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-10-30 13:30:54 Re: BUG #15471: psql 11 array concatenation in CASE takes on values from the CASE expression when using enum_range
Previous Message Andrew Gierth 2018-10-30 13:09:40 Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.