[opencms-dev] pool exhausted

[Fátima Rodríguez Calvo]

I don't have installed this module... I think the problem is the opencms
pool implementation, but i don't know how solve it.

2008/4/16, Juan Francisco Fernández <juanffernandez at faffe.es>:
>
> Fátima, do you have the Alkacon Webform module installed? It has a bug
> that
> was causing troubles to me, because it doesn't close connections in one
> function. I wrote this email to the list reporting the bug:
>
> > Looking at CmsFormDataAccess.java, why the module is not closing the
> > connection with database at line 538? Maybe this is the bug that is
> > producing the opened connections problem that I told in other mails to
> the
> > list.
>
> I downloaded the CVS code and fix that problem, and voilá, not more errors
> on pool exhausted.
>
> -----Mensaje original-----
> De: opencms-dev-bounces at opencms.org [mailto:
> opencms-dev-bounces at opencms.org]
> En nombre de Pam Callaway
> Enviado el: miércoles, 16 de abril de 2008 5:05
> Para: The OpenCms mailing list
> Asunto: Re: [opencms-dev] pool exhausted
>
>
> Yeah, first place I would look is opencms.properties.  There are
> settings for the pool size, initial size, growth rate, etc...
>
> Pam
>
> On Tue, Apr 15, 2008 at 5:42 PM, Pomegranate Software- Arash
> Kaffamanesh <arash.kaffamanesh at pomegranate.de> wrote:
> > Hi,
> >
> >  is there a firewall between your app server and the db server?
> >  which version of OpenCms do you have in place?
> >  how is the connection pool settings in opencms.properties?
> >
> >  Best,
> >  Arash
> >
> >  Fátima Rodríguez Calvo schrieb:
> >
> >
> > > Hi,
> >  >
> >  > I have a problem with the opencms connection pool. The error is :
> >  > "
> >  > ...
> >  > /Caused by: org.opencms.db.CmsDbSqlException: An SQL error
> >  >
> >  > // occurred when executing the following query: .
> >  >
> >  > ...
> >  > //Caused by: org.apache.commons.dbcp.SQLNestedException:
> >  > />/ Cannot get a connection, pool exhausted/
> >  >
> >  >
> >  > ... "
> >  >
> >  > Opencms pool can't open more connections and this makes the web isn't
> >  > operative.
> >  >
> >  > If I restart jboss the web woks again, but this happens once a day,
> >  > usually at 4 or 5 am, when the number of visits it's insignificant.
> >  >
> >  > Can someone help me??
> >  >
> >  > (Sorry about my poor English)
> >  >
> >  > Fafolkie
> >  >
> ------------------------------------------------------------------------
> >  >
> >  >
> >  > _______________________________________________
> >  > This mail is sent to you from the opencms-dev mailing list
> >  > To change your list options, or to unsubscribe from the list, please
> visit
> >  > http://lists.opencms.org/mailman/listinfo/opencms-dev
> >
> >
> >
> >
> >
> >
> >
> >  _______________________________________________
> >  This mail is sent to you from the opencms-dev mailing list
> >  To change your list options, or to unsubscribe from the list, please
> visit
> >  http://lists.opencms.org/mailman/listinfo/opencms-dev
> >
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080416/eb92bfaf/attachment.htm>