Return-Path: Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-dev@xml.apache.org Received: (qmail 9096 invoked from network); 19 Jan 2001 13:38:45 -0000 Received: from fw.infoplanning.net (HELO infoplanning.com) (@209.8.58.131) by h31.sny.collab.net with SMTP; 19 Jan 2001 13:38:45 -0000 Received: (qmail 764 invoked from network); 19 Jan 2001 13:47:41 -0000 Received: from unknown (HELO apache.org) (192.168.0.189) by inet with SMTP; 19 Jan 2001 13:47:41 -0000 Message-ID: <3A68427F.7080901@apache.org> Date: Fri, 19 Jan 2001 08:34:55 -0500 From: Berin Loritsch User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; 0.7) Gecko/20010109 X-Accept-Language: en MIME-Version: 1.0 To: cocoon-dev@xml.apache.org Subject: Re: [C2]Datasource with Postgresql 7.1 References: <000d01c0820c$87f4ce00$05c8a8c0@GOLLUM> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N Lassi Immonen wrote: > Hi all, > > > > Just tried fresh cvs version of C2 and found out there is connection pooling > > code added which is very nice. > > When I tried C2 and new Employee example, everything works fine for a while, > > but then Postgres says no more Clients allowable. > > Every time database command gets executed the number of postgres processes > > grows by 5. This happens until Postgres doesn't except anymore connections. > > So either Postgres or C2 pool is not releasing connections properly. > > I'm running Postgres7.1beta3 in Cygwin environment. > > > > Any ideas? This had to do with a bug that was recently fixed in the ComponentManager/Selector. I introduced the bug when I was trying to fix something else. Try to get a fresh CVS version and retry. You will find that it shouldn't do that anymore.