[opencms-dev] pool exhausted
Juan Francisco Fernández
juanffernandez at faffe.es
Wed Apr 16 09:25:39 CEST 2008
Fátima, do you have the Alkacon Webform module installed? It has a bug that
was causing troubles to me, because it doesnt 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
More information about the opencms-dev
mailing list