From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | lhornbeck(at)oppunl(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Invalid memory alloc request size |
Date: | 2006-09-26 22:00:48 |
Message-ID: | 639.1159308048@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"Laura Hornbeck" <lhornbeck(at)oppunl(dot)com> writes:
> I am repeatedly getting invalid memory alloc request size errors on almost a
> daily basis and not always on the same table. To fix the troubled table, I
> find the record that either gives the memory error or makes postgres crash
> (gives a terminated by signal 11 error in the log) and delete it. Until I
> do that, I cannot select the data from the table by any means (select * ,
> dump, copy to, etc).
This sounds like nothing so much as flaky hardware. Could be bad RAM,
loose cables, disk drive on the edge of failure ...
You need to take the machine out of service for a bit and run some
hardware diagnostics on it. memtest86 is widely recommended for testing
RAM, and you could use badblocks or something similar to look for
possible disk flakiness. The old "clean, and reseat all the connectors"
drill would be a worthwhile step too.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | pr0v4 | 2006-09-27 10:41:21 | Re: pass date type data to PQexecparams |
Previous Message | Laura Hornbeck | 2006-09-26 20:33:13 | Invalid memory alloc request size |