Skip site navigation (1) Skip section navigation (2)

Re: Server hangs on multiple connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Christian <davidc(at)comtechmobile(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Server hangs on multiple connections
Date: 2002-09-20 15:30:31
Message-ID: 16533.1032535831@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
David Christian <davidc(at)comtechmobile(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: David ChristianDate: 2002-09-20 15:49:53
Subject: Re: Server hangs on multiple connections
Previous:From: David ChristianDate: 2002-09-20 13:23:05
Subject: Re: Server hangs on multiple connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group