From: | Matthias(dot)Pitzl(at)izb(dot)de |
---|---|
To: | smarlowe(at)g2switchworks(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange database corruption with PostgreSQL 7.4.x o |
Date: | 2006-09-20 14:16:14 |
Message-ID: | 11EC9A592C31034C88965C87AF18C2A70CFC59@m0000s61 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Scott!
Thank you. Memtest86 i know. I think we will use this for testing our
hardware too.
Got some other nice information meanwhile from someone also running a DL380
server which had a defect backplane causing similar issues.
He also gave me the hint that there's a test suite CD by Compaq to run some
hardware diagnostic checks on our machine. I will try this out as soon as
possible.
I will inform you when i know more :)
-- Matthias
> -----Original Message-----
> From: Scott Marlowe [mailto:smarlowe(at)g2switchworks(dot)com]
> Sent: Wednesday, September 20, 2006 4:12 PM
> To: Matthias(dot)Pitzl(at)izb(dot)de
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: RE: [GENERAL] Strange database corruption with
> PostgreSQL 7.4.x o n
>
> Keep in mind, a single bad memory location is all it takes to
> cause data
> corruption, so it could well be memory. CPU is less likely if the
> machine is otherwise running stable.
>
> The standard tool on x86 hardware is memtest86 www.memtest86.com
>
> So, you'd have to schedule a maintenance window to run the
> test in since
> you have to basically down the machine and run just
> memtest86. I think
> a few live linux distros have it built in (FC has a memtest label in
> some versions I think)
>
> My first suspicion is always memory. We ordered a batch of
> memory from
> a very off brand supplier, and over 75% tested bad. And it took >24
> hours to find some of the bad memory.
>
> good luck with your testing, let us know how it goes.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Harry Hehl | 2006-09-20 14:17:14 | pg_dump output containing CREATE TYPE does not restore with psql |
Previous Message | Scott Marlowe | 2006-09-20 14:12:19 | Re: Strange database corruption with PostgreSQL 7.4.x o n |