Re: postgresql fails to fork backend

Maarten,

On Thu, Apr 26, 2001 at 11:53:57PM +0200, Maarten Boekhold wrote:
> first of all, I should be doing this via the list, but I'm at home and can't
> dial in right now (but I've got a cable modem ;)

Hmm...I'm not sure why using a cable instead of a phone modem affects
how one addresses email.  In the future, please post to

    pgsql-cygwin@postgresql.org

instead of sending private email so others can benefit too.

> I tried to install Postgresql from the cygwin suite (I've got years of
> experience with pgsql on unix, first version I used was like in '95).
>
> [part of excellent trouble report snipped...]
>
> >/bin/postmaster: ServerLoop:        handling reading 6
> >/bin/postmaster: ServerLoop:        handling reading 6
> >/bin/postmaster: ServerLoop:        handling writing 6
> >/bin/postmaster child[347]: starting with (postgres -d9 -v131072 -p
> >template1 )
> >FindExec: found "/bin/postgres" using argv[0]
> >2001-04-26 20:59:39 [347]    DEBUG:  connection: host=127.0.0.1
> >user=administrator database=template1
> >2001-04-26 20:59:39 [347]    DEBUG:  InitPostgres
> >/bin/postmaster: BackendStartup: pid 347 user administrator db template1
> >socket 6
> >ZeroProcSemaphore: semctl(id=0,SETVAL) failed: Invalid argument
> >2001-04-26 20:59:39 [347]    DEBUG:  proc_exit(255)
> >2001-04-26 20:59:39 [347]    DEBUG:  shmem_exit(255)
> >2001-04-26 20:59:39 [347]    DEBUG:  exit(255)
> >/bin/postmaster: reaping dead processes...
>
> See below for all versions of relevant software installed. NT4 sp6(a?)
>
> Incidentally, since this appeared to involve IPC and shared mem stuff, I did
> a 'ipcs', which fails horribly. It hangs trying to retrieve the message
> queues (in fact, a CTRL-C gives an 'Application Error' dialog box).
>
> postgresql contrib/postgresql/postgresql-7.1-2.tar.gz 2161407
> cygwin     latest/cygwin/cygwin-1.3.1-1.tar.gz        714044
> crypt      latest/crypt/crypt-1.0-1.tar.gz            7407
> readline   contrib/readline/readline-4.1-2.tar.gz     646802
> zlib       contrib/zlib/zlib-1.1.3-6.tar.gz           72843
> cygipc-1.09-2.tar.gz (not installed via the cygwin setup prog)
>
> Known problem?

On Fri, Apr 27, 2001 at 12:02:08AM +0200, Maarten Boekhold wrote:
> this seems to be a cygipc issue. If I run the ipc-daemon from the command
> line, i.e. _not_ as an NT service, the thing works OK. Guess somebody
> has to report this....

Others have reported problems when ipc-daemon is running as a service.
I have not personally experienced any problems on either NT 4.0 SP5,
NT 4.0 SP6a or 2000 SP1 when ipc-daemon is installed as an NT service.
Sorry, but if I cannot reproduce it, then I cannot try to find the
root cause.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com