Re: [HACKERS] FreeBSD problem under heavy load - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] FreeBSD problem under heavy load
Date
Msg-id 11460.944797509@sss.pgh.pa.us
Whole thread Raw
In response to FreeBSD problem under heavy load  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] FreeBSD problem under heavy load
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I seem to run into a serious problem. With 6.5.x + FreeBSD 3.2, I get
> a core under heavy load (16 or more concurrent users). FreeBSD 2.2.x
> seems more stable but soon or later same thing happens. Examing a
> core, I found it segfaulted in hash_search().

I've been looking into this without much success.  I cannot reproduce it
here under HPUX --- I ran pgbench for several hours without seeing any
problem.  I also made another pass over the dynahash.c code looking for
portability bugs, but didn't find anything that looked promising.  (The
code is ugly and fragile, but AFAICT it will work under existing usage
patterns.)  It's quite possible the problem is elsewhere and dynahash is
just on the receiving end of a memory clobber ... but if so, we have
very little to go on in guessing where to look.

Can anyone else reproduce the problem?  Does anything show up in the
postmaster log at or just before the crash?
        regards, tom lane

PS: pgbench's configure fails on HPUX, because HP's compiler doesn't
like whitespace before #include.  I modified configure.in like this:

AC_TRY_LINK([#include <sys/time.h>
#include <sys/resource.h>],    [struct rlimit rlim;


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] FOREIGN KEY and shift/reduce
Next
From: Tom Lane
Date:
Subject: pgsql web site busted?