Postgres Pro
Downloads
Home   >   mailing lists

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 87a7mv7fbi.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to BUG #15467: The database subdirectory"pg_tblspc/1932420460/PG_10_201707211/16400" is missing.  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400"is missing.  (tsuraan <tsuraan@gmail.com>)
List pgsql-bugs
Tree view 
>>>>> "PG" == PG Bug reporting form <noreply@postgresql.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)

pgsql-bugs by date:

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