Skip site navigation (1) Skip section navigation (2)

Re: postgresql fails to fork backend

From: Jason Tishler <Jason(dot)Tishler(at)dothill(dot)com>
To: Maarten Boekhold <boekhold(at)hotmail(dot)com>
Cc: Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: postgresql fails to fork backend
Date: 2001-04-27 18:22:55
Message-ID: 20010427142255.D308@dothill.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
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(at)postgresql(dot)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(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

pgsql-cygwin by date

Next:From: Jason TishlerDate: 2001-04-27 18:26:30
Subject: Re: Error INITDB
Previous:From: Jason TishlerDate: 2001-04-27 18:10:12
Subject: Re: postgres on Win2K

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group