Re: Help Required - Mailing list pgsql-cygwin

From Jason Tishler
Subject Re: Help Required
Date
Msg-id 20030813111355.GE1108@tishler.net
Whole thread Raw
In response to Help Required  ("Kamalraj Singh Madhan" <kamalr@networkprograms.com>)
List pgsql-cygwin
Kamalraj,

On Wed, Aug 13, 2003 at 12:28:04PM +0530, Kamalraj Singh Madhan wrote:
> I'am using PostGre SQL along with JBOSS and Tomcat for our
> application.  After quite some time of the usage of the application i
> start getting these messages in my database console (Cygwin) :
>
>
> DEBUG:  geqo_main: using edge recombination crossover [ERX]
> CheckPoint Data Base: fork failed: Resource temporarily unavailable
> /usr/bin/postmaster: BackendStartup: fork failed: Resource temporarily
                                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> unavailable - Backend startup failed
> DEBUG:  geqo_main: using edge recombination crossover [ERX]
> CheckPoint Data Base: fork failed: Resource temporarily unavailable
> CheckPoint Data Base: fork failed: Resource temporarily unavailable
> DEBUG:  geqo_main: using edge recombination crossover [ERX]

My WAG is that you hit the Cygwin fork() limit of 63 children per
parent.  If I'm correct, then I recommend limiting your connections to
~60 if possible.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: IpcSemaphoreCreate Error,help pls
Next
From: Jason Tishler
Date:
Subject: Re: PostgreSQL