PostgreSQL 7.4RC1 crashes on Panther

From: Scott Goodwin <scott(at)scottg(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: PostgreSQL 7.4RC1 crashes on Panther
Date: 2003-11-03 20:24:21
Message-ID: B55DEAE4-0E3B-11D8-ACE4-000A95A0910A@scottg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I've encountered a problem where the PostgreSQL database crashes when
attempting to load pltcl.so on Mac OS 10.3. PostgreSQL fails because
memory cannot be allocated during a shmget call. Here is the exact
error message:

FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001, size=3809280,
03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space. To reduce the
request size (currently 3809280 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 300) and/or its max_connections
parameter (currently 50).
The PostgreSQL documentation contains more information about
shared memory configuration.

Here's the code that triggers it:

create function pltcl_call_handler() RETURNS LANGUAGE_HANDLER
as 'pltcl.so' language 'c';

I have 1GB of memory and very little running on the powerbook (I
rebooted just to be sure I started with a clean system).

Not sure whether this is a PostgreSQL problem or a Mac OS 10.3 problem,
but I can load plpgsql.so right before loading pltcl.so and it still
only fails on the pltcl.so load. Commenting out the plpgsql.so load and
trying again it still fails on the pltcl.so load. I'm compiling against
a locally compiled version of Tcl 8.4.4. Here are the configure
settings:

./configure \
--prefix=$INSTALL/postgresql \
--with-tcl \
--with-tclconfig=$INSTALL/tcl/lib \
--with-includes=$INSTALL/tcl/include:$INSTALL/readline/include \
--with-libraries=$INSTALL/readline/lib \
--without-tk \
--without-openssl

thanks,

/s.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Edlman 2003-11-04 06:07:08 Re: Repeatedly breaking indexes
Previous Message Tom Lane 2003-11-03 15:37:50 Re: Possible bug in conversion_create.sql