From: | Frederik Ramm <frederik(dot)ramm(at)geofabrik(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Various intermittent bugs/instability - how to debug? |
Date: | 2008-09-26 00:25:38 |
Message-ID: | 48DC2C02.8020709@geofabrik.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
just to give an update on this:
Frederik Ramm wrote:
> Every other night, the process aborts with some strange error message,
> and never at the same position:
[...]
Turns out it *was* a RAM defect on one of the machines. memtest86 ran
for a day and didn't detect it, but when I started making copies of a
100 GB file and m5dsumming it afterwards, I'd get one or two bad copies
per day. I then juggled RAM chips until I had identified the defective
one. As you can imagine, this took a while.
Lesson learnt: memtest86 running for a day and not finding an error does
not mean your RAM is ok!
I still have occasional problems on the *other* machine (if you remember
my original post, I had similar errors on two different machines) and
even massive data copying did not show any error there but at least a
PostGIS bug seems extremely unlikely now (and that's still running stock
packages, not patched).
Bye
Frederik
--
Frederik Ramm www.geofabrik.de
Geofabrik GmbH Handelsregister: HRB Mannheim 703657
Rueppurrer Strasse 4 Geschaeftsfuehrung: Frederik Ramm
76137 Karlsruhe Tel: 0721-1803560-0
frederik(dot)ramm(at)geofabrik(dot)de Fax: 0721-1803560-9
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Soules | 2008-09-26 00:27:19 | Re: Stroring html form settings |
Previous Message | Tom Lane | 2008-09-26 00:15:33 | Re: Out of memory on SELECT (from sort?) in 8.3 |