Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed - Mailing list pgsql-general

From Michael Paquier
Subject Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed
Date
Msg-id CAB7nPqQ-5ykV1sQONzfeBZmqWFMOf377Q8+0XBd92S2z6hxQ+g@mail.gmail.com
Whole thread Raw
In response to incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed  (Tatsuki Kadomoto <tatsuki.kadomoto@proceranetworks.com>)
Responses Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed  (John R Pierce <pierce@hogranch.com>)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed
Next
From: John R Pierce
Date:
Subject: Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed