Re: PostgreSQL 7.4RC1 crashes on Panther

After recompiling with GCC 3.1 it fails when I'm running initdb to
create the cluster -- it's a shmget error again. I believe that takes
both Tcl and PostgreSQL out of the suspect pool and leaves Mac OS 10.3
as the primary culprit. I installed Panther last week from scratch
(reformatted disk etc.) and haven't made any mods to it aside from the
SystemTuning params today. I haven't had any other apps crash, and I'm
using the system all day using Apple's apps, AOLserver, OpenSSL and
others. I tried gdb to get a backtrace but the signal gets caught by
postgres, so it doesn't dump me back to the gdb command line. I'll have
to set breakpoints, have GDB do something with the signal, or mod PG to
not catch it. That'll have to wait until tomorrow or Saturday.

thanks for the assist,

/s.

On Nov 6, 2003, at 2:41 PM, Tom Lane wrote:

> Scott Goodwin <scott(at)scottg(dot)net> writes:
>> psql:/Users/scott/m/ops/database/sql/add_languages.sql:13: server
>> closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>
>> ...output in the log file is:
>
>> LOG: server process (PID 2739) was terminated by signal 10
>
> Here's the real problem --- why are you getting a SIGBUS while trying
> to
> load the pltcl handler function? I suspect something broken in Tcl's
> shared library, but dunno what. You should be getting a core file from
> the crashed process --- can you get a stack trace from it with gdb?
>
>> FATAL: could not create shared memory segment: Cannot allocate memory
>> DETAIL: Failed system call was shmget(key=5432001, size=3809280,
>> 03600).
>
> This is evidently happening during attempted restart after the backend
> crash. I suspect it is a matter of the OS not having released the old
> memory segment yet, together with the SHMMAX limit being too tight to
> allow two such segments to exist concurrently. Are you able to start
> the server by hand immediately afterwards, or a few seconds afterwards?
> Or do you have to reboot before it will restart?
>
> regards, tom lane