Re: Postgres Crashes - Mailing list pgsql-hackers

From F Harvell
Subject Re: Postgres Crashes
Date
Msg-id 845E32CE-9EBC-11D8-9D61-000A95A5E4A0@fts.net
Whole thread Raw
In response to Postgres Crashes  (prem@mazunetworks.com (Prem Gopalan))
List pgsql-hackers
   This sounds very much like a memory problem.  I would replace all of 
the memory with another set of (preferably known good) memory and see 
if the problems persist.  Also look for other cores that may be 
dropped.  If there are several, memory is the likely cause.  Be aware 
that it will likely be active, large memory applications (of which 
PostgreSQL may be the only one on the server) that will materialize the 
issues.
  Memory testing application may also show the problem, however, they 
do not test like production use.  I have had test apps run for weeks 
where production use can cause failures in mere minutes.  Also, note 
that I have seen issues with bad CPU's (bad cache?) that have caused 
similar problems.

On 30 Apr 2004, at 15:24, Prem Gopalan wrote:

> We run a multithreaded application that uses postgres 7.4 on Linux
> 2.4.18, dual cpu Xeon processor machine. We have occassional weird
> crashes and have tried a lot of things to reproduce them in house, but
> in vain. We do have coredumps and I have listed the backtraces and
> their common characteristics here.
>
> ...



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: initdb failure in CVS
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE TODO items