| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Tatsuki Kadomoto <tatsuki(dot)kadomoto(at)proceranetworks(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed |
| Date: | 2016-08-22 03:37:23 |
| Message-ID: | CAB7nPqQ-5ykV1sQONzfeBZmqWFMOf377Q8+0XBd92S2z6hxQ+g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 22, 2016 at 12:27 PM, Tatsuki Kadomoto
<tatsuki(dot)kadomoto(at)proceranetworks(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2016-08-22 03:42:41 | Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed |
| Previous Message | John R Pierce | 2016-08-22 03:34:57 | Re: incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed |