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

John, Michael,

Thanks. The server is Dell PowerEdge R720.

The checksum error only was reported only once so I guess it was automatically fixed immediately.

The log was output only one time while the box was running very long time (> 1 year.).

I have hundreds of the machines with same configuration running very long time as well,

but the incident was only once.

Can we point out a specific bug that can lead to this?

Or HW issue is the most probable cause?

I don't see any HW error logs.

Regards,

Tatsuki

________________________________
From: pgsql-general-owner(at)postgresql(dot)org <pgsql-general-owner(at)postgresql(dot)org> on behalf of John R Pierce <pierce(at)hogranch(dot)com>
Sent: Monday, August 22, 2016 12:42:41 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] incorrect checksum detected on "global/pg_filenode.map" when VACUUM FULL is executed

On 8/21/2016 8:37 PM, Michael Paquier wrote:

PosgreSQL version is 9.2.4.

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

3+ years, to be more specific, 9.2.4 was released in april 2013.

indeed, and several of the bug fixes involved data corruption. current is 9.2.18

--
john r pierce, recycling bits in santa cruz