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-31 15:53:25
Message-ID: 871s866rvi.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:

tsuraan> Starting up postgres again and querying pg_database still
tsuraan> gives the same cache lookup error.

Do you still get the error from just

select oid from pg_database;

or

select oid,dattablespace from pg_database;

?

tsuraan> Another person noticed that the missing directory
tsuraan> (pg_tblspc/1932420460/PG_10_201707211/16400)

I just noticed: 1932420460 = 0x732E656C = "le.s" which is suspiciously
textual.

Any chance you can do this query:

select pg_relation_filepath('pg_database'::regclass);

and then do hexdump -C on that file?

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-10-31 16:02:36 BUG #15473: Incorrect error when executing a certain create table statement through psql
Previous Message tsuraan 2018-10-31 14:30:26 Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.