[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 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




More information about the opencms-dev mailing list