Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed
Дата
Msg-id CAB7nPqQ-5ykV1sQONzfeBZmqWFMOf377Q8+0XBd92S2z6hxQ+g@mail.gmail.com
обсуждение исходный текст
Ответ на incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed  (Tatsuki Kadomoto <tatsuki.kadomoto@proceranetworks.com>)
Ответы Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
On Mon, Aug 22, 2016 at 12:27 PM, Tatsuki Kadomoto
<tatsuki.kadomoto@proceranetworks.com> wrote:
> I see incorrect checksum detected on "global/pg_filenode.map" when "VACUUM
> FULL" is executed.
>
> The error message didn't repeat. It showed up only once.
>
> Is this expected? Can someone give me a plausible scenario why this
> happened?
> Aug 16 20:51:19 postgres[22329]: [2-1] FATAL:  relation mapping file
> "global/pg_filenode.map" contains incorrect checksum
> It looks like it's pretty rare and I have seen it only once at 2 different
> machines.

You are facing a corruption:
https://wiki.postgresql.org/wiki/Corruption
Be sure that you have a clean backup of your database first!

> PosgreSQL version is 9.2.4.

You are missing a couple of years worth of bug fixes here..
--
Michael


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed
Следующее
От: John R Pierce
Дата:
Сообщение: Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed