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

Re: Row data corruption under 7.3.5

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Marc Mitchell <marcm(at)eisolution(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Row data corruption under 7.3.5
Date: 2004-03-17 16:51:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Wed, 17 Mar 2004, Marc Mitchell wrote:

> This is follow-up to a problem first reported on 3/1/04.  The problem
> has continued to occur intermittently and recently we experienced the
> first occurrence where the first column of a table was the column where
> the corrupted and thus we could not recover it.
> Google groups searching have found numerous hits for people reporting
> the same symptoms.  While we've seen some instructions to get things
> back, we've seen nothing about correcting the root cause.

Have you tested your hardware and proven to yourself that both your memory 
and your drive subsystem have no bad blocks or bits?

Postgresql is good, but it can't make up for broken hardware.

If you haven't actually tested your hardware, then you don't know if it's 
truly reliable or not.  and if you put a server into production without 
testing the drives and memory, you can't just expect it to be good.  I've 
seen many a brand new server, both intel and Sparc based, with bad memory 
or drives right from the factory.

> We've observed nothing that would lead us to believe there are any
> hardware problems.

What you are seeing from Postgresql IS a sign that you have hardware 
problems.  Please test your hardware immediately.

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-03-17 16:53:36
Subject: Re: Row data corruption under 7.3.5
Previous:From: Marc MitchellDate: 2004-03-17 16:12:47
Subject: Re: Row data corruption under 7.3.5

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