Re: [BUGS] PostgreSQL 7.4RC1 crashes on Panther

[Scott Goodwin]

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 <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings