Re: Server hangs on multiple connections

David Christian <davidc(at)comtechmobile(dot)com> writes:
> Happy to. Interestingly, when I build with --enable-debug and
> --enable-cassert, the server doesn't lock up during 'make check', it
> just (very quickly) fails all of the tests and exits. I tried several
> times.

Oh, that's interesting; that says that an Assert() check is failing.
We should investigate that first.

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?
Also, you will probably find some useful messages in the postmaster
log (which should be left in the log/ subdirectory of the regress tests).

> (gdb) bt
> #0 0x0fdc297c in __syscall_ipc () at soinit.c:76
> #1 0x0fdc38c0 in semop (semid=4, sops=0x7fffea18, nsops=1) at
> ../sysdeps/unix/sysv/linux/semop.c:36
> #2 0x100e4424 in IpcSemaphoreLock ()
> #3 0x100eb018 in LWLockAcquire ()
> #4 0x100e7f3c in LockAcquire ()
> #5 0x100e7434 in LockRelation ()

Sure enough, it would seem that everyone's stuck waiting for a lock.
But let's chase the Assert first; that might identify the problem.

regards, tom lane