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(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 13:09:40
Message-ID: 87a7mv7fbi.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "PG" == PG Bug reporting form <noreply(at)postgresql(dot)org> writes:

PG> I have a system running on AWS that had been processing data without any
PG> apparent issues, when the main database apparently just stopped existing.
PG> The postgres logs (considerably snipped) look like this:

PG> ...
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?

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-bugs by date

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