From: Craig Ringer <craig@postnewspapers.com.au>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: John Rouillard <rouilj@renesys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: "error with invalid page header" while vacuuming pgbench data
Date: Thu, 26 May 2011 11:17:50 +0800
Message-ID: <4DDDC65E.1040606@postnewspapers.com.au> (raw)
In-Reply-To: <BANLkTikaAPZow+b2YZKOKH5KxuGYWvFi9w@mail.gmail.com>
References: <20110523221603.GA31823@renesys.com>
<4DDA9780020000250003DB62@gw.wicourts.gov>
<20110525171239.GC31823@renesys.com>
<4DDD1E1F020000250003DCDA@gw.wicourts.gov>
<20110525220716.GF31823@renesys.com>
<BANLkTikaAPZow+b2YZKOKH5KxuGYWvFi9w@mail.gmail.com>
On 05/26/2011 06:18 AM, Scott Marlowe wrote:
> On Wed, May 25, 2011 at 4:07 PM, John Rouillard<rouilj@renesys.com> wrote:
>> Well I am also managing to panic the kernel on some runs as well. So
>> my guess is this is not only a postgres bug (if it's a postgres issue
>> at all).
>>
>> As gregg mentioned in another followup ext4 under centos 5.x may be an
>> issue. I'll drop back to ext3 and see if I can replicate the
>> corruption or crashes one I rule out some potential hardware issues.
>
> Also do the standard memtest86+ run to ensure your memory isn't bad.
> Also do a simple dd if=/dev/sda of=/dev/null to make sure the drive
> has no errors.
If possible, also/instead use smartctl from smartmontools to ask the
drive to do an internal self-test and surface scan. This doesn't help
you with RAID volumes, but is often much more informative with plain
physical drives.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au, scott.marlowe@gmail.com, rouilj@renesys.com
Subject: Re: "error with invalid page header" while vacuuming pgbench data
In-Reply-To: <4DDDC65E.1040606@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox