Re: Server hangs on multiple connections - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Server hangs on multiple connections
Date
Msg-id 16533.1032535831@sss.pgh.pa.us
Whole thread Raw
In response to Re: Server hangs on multiple connections  (David Christian <davidc@comtechmobile.com>)
Responses Re: Server hangs on multiple connections  (David Christian <davidc@comtechmobile.com>)
Re: Server hangs on multiple connections  (David Christian <davidc@comtechmobile.com>)
List pgsql-bugs
David Christian <davidc@comtechmobile.com> writes:
> On Thursday, Sep 19, 2002, at 18:33 US/Eastern, Tom Lane wrote:
>> There should be a core file left in the database subdirectory after
>> the assert failure --- would you gdb it and get a stack trace from it?

> Unfortunately, I see no core file under the source tree after the
> assert failure.

If you are using "make check" then look for
src/test/regress/tmp_check/data/base/*/core

If you don't see one then you must be running with a ulimit setting that
forbids core dumps --- try "ulimit -c unlimited" before starting the
postmaster.

> TRAP: Failed Assertion("!(lock->shared > 0):", File: "lwlock.c", Line:
> 434)

This confirms my suspicion that something is busted in lock handling on
your machine, but there's not enough info here to tell just what.  We
still need a stack trace.

Another interesting line of attack would be to try compiling
src/backend/storage/lmgr/lwlock.c at different optimization levels,
to see if the problem goes away with less optimization.  We saw a
problem on AIX (if memory serves) before 7.2 release that turned out
to be due to overaggressive optimization by the compiler.  We thought
we'd added enough "volatile" keywords to lwlock.c to discourage any
code rearrangement, but maybe we still need more.

            regards, tom lane

pgsql-bugs by date:

Previous
From: David Christian
Date:
Subject: Re: Server hangs on multiple connections
Next
From: David Christian
Date:
Subject: Re: Server hangs on multiple connections