From users-return-98512-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org Fri Feb 12 21:44:20 2010 Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 41044 invoked from network); 12 Feb 2010 21:44:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Feb 2010 21:44:20 -0000 Received: (qmail 699 invoked by uid 500); 12 Feb 2010 21:44:19 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 631 invoked by uid 500); 12 Feb 2010 21:44:19 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: users@cocoon.apache.org List-Id: Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 623 invoked by uid 99); 12 Feb 2010 21:44:19 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Feb 2010 21:44:19 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [68.142.225.231] (HELO smtp115.rog.mail.re2.yahoo.com) (68.142.225.231) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 12 Feb 2010 21:44:12 +0000 Received: (qmail 70421 invoked from network); 12 Feb 2010 21:43:49 -0000 Received: from cmr-208-97-115-27.cr.net.cable.rogers.com (aghajani@208.97.115.27 with plain) by smtp115.rog.mail.re2.yahoo.com with SMTP; 12 Feb 2010 13:43:49 -0800 PST X-Yahoo-SMTP: G9buitaswBDFheEGdlQoCPX7pGQCiSi.nUxYiWZz7AGX.dQ7gg-- X-YMail-OSG: 9GUQ9jkVM1kYY1JiSVWqoFjrO5YXxi4HZ4SiTfMr1dmGaM18sY9SwmCS1ctja11T5g-- X-Yahoo-Newman-Property: ymail-3 Message-ID: <4B75CB94.5080100@principle.com> Date: Fri, 12 Feb 2010 16:43:48 -0500 From: Shahriar Aghajani User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: users@cocoon.apache.org Subject: Re: Database Connection Leak - When too many pipelines References: <4B75B1A8.7080903@principle.com> <4B75C075.3020304@gmail.com> In-Reply-To: <4B75C075.3020304@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Thanks Paul. I'm not certain, but it doesn't look like i'm using commons-dbcp. I think the spring DriverManagerDataSource is replacing it in this case? Below is what I'm using for my connector: Cheers. Paul Joseph wrote: > I vaguely recall having this problem in Cocoon 2.1.11 and that it > seemed to go away when I replaced my commons-dbcp jar with the latest > I could find (commons-dbcp-1.2.2.jar) > > Shahriar Aghajani wrote: >> Hello, >> >> I wonder if anybody can help me or point me in the right direction. >> >> I get database connection leaks if I'm including pipelines which >> reference other pipelines too many times. >> >> I'm using Cocoon 2.2 >> PostgreSQL 8.3 with postgresql-8.3-605.jdbc3.jar >> >> Here's what I got: >> >> Data comes from the parent sitemap, and the child sitemap uses that >> data. >> I've tried including the data using map:aggregate, XInclude, Include, >> and XSLT/document()... all lead to the leaks one way or another. >> For each of the "bad" piplines, I get a new idle postgres connection >> hanging around indefinitely. >> >> Below, >> for the via-agg.xml pipeline, the 3rd include does the job. If I >> remove that one, then I don't get a leak. >> for the via-include.xml pipeline, if I use only one of the "CULPRIT" >> includes, everything is fine. But if I use any 2 of the includes, >> then I get a leak. >> >> Any ideas? >> >> >> Thank you very much for your help. >> >> Regards, >> Shahriar Aghajani. >> >> >> Parent Sitemap: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Sub Sitemap: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Seed File: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org >> For additional commands, e-mail: users-help@cocoon.apache.org >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org > For additional commands, e-mail: users-help@cocoon.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org For additional commands, e-mail: users-help@cocoon.apache.org