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(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