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

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.
Дата
Msg-id 871s866rvi.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400"is missing.  (tsuraan <tsuraan@gmail.com>)
Ответы Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400"is missing.  (tsuraan <tsuraan@gmail.com>)
Список pgsql-bugs
>>>>> "tsuraan" == tsuraan  <tsuraan@gmail.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)


В списке pgsql-bugs по дате отправления:

Предыдущее
От: tsuraan
Дата:
Сообщение: Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400"is missing.
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15473: Incorrect error when executing a certain create tablestatement through psql