Skip site navigation (1) Skip section navigation (2)

Re: "error with invalid page header" while vacuuming pgbench data

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: John Rouillard <rouilj(at)renesys(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: "error with invalid page header" while vacuuming pgbench data
Date: 2011-05-26 03:17:50
Message-ID: 4DDDC65E.1040606@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
On 05/26/2011 06:18 AM, Scott Marlowe wrote:
> On Wed, May 25, 2011 at 4:07 PM, John Rouillard<rouilj(at)renesys(dot)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

In response to

pgsql-performance by date

Next:From: SanthakumaranDate: 2011-05-26 03:55:53
Subject: Re: Speeding up loops in pl/pgsql function
Previous:From: Craig RingerDate: 2011-05-26 02:40:22
Subject: Re: Hash Anti Join performance degradation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group