commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sanjay Dahiya (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DBCP-213) DBCP causes tomcat to hang under moderate load
Date Mon, 09 Apr 2007 13:14:32 GMT

    [ https://issues.apache.org/jira/browse/DBCP-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487544
] 

Sanjay Dahiya commented on DBCP-213:
------------------------------------

Using high values for timeout/max connections takes care of the problem for now. 
thanks. marking it as invalid issue for now. 

> DBCP causes tomcat to hang under moderate load
> ----------------------------------------------
>
>                 Key: DBCP-213
>                 URL: https://issues.apache.org/jira/browse/DBCP-213
>             Project: Commons Dbcp
>          Issue Type: Bug
>            Reporter: Sanjay Dahiya
>            Priority: Critical
>
> It appears that the problem in this case is with DBCP, so I am logging this here. If
i reload my web page rapidly a few times ( 5-6 times to be exact) it causes tomcat to hang.
A thread dump of tomcat shows multiple threads blocked at this line. 
> I am using following options for - org.apache.commons.dbcp.BasicDataSource
>     <property name="maxActive" value="25"/>
>     <property name="maxIdle" value="10"/>
>     <property name="maxOpenPreparedStatements" value="50"/>
>     <property name="poolPreparedStatements" value="true"/>
> Not sure if its a bug or a misconfiguration. 
> "http-8080-2" daemon prio=5 tid=0x00567a20 nid=0x1951600 in Object.wait() [0xf1599000..0xf159bab0]
>         at java.lang.Object.wait(Native Method)
>         - waiting on <0x2709d0e8> (a org.apache.commons.pool.impl.GenericObjectPool)
>         at java.lang.Object.wait(Object.java:474)
>         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:748)
>         - locked <0x2709d0e8> (a org.apache.commons.pool.impl.GenericObjectPool)
>         at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
>         at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
>         at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
>         at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:421)
>         at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
>         at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
>         at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1538)
>         at org.hibernate.loader.Loader.doQuery(Loader.java:661)
>         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
>         at org.hibernate.loader.Loader.doList(Loader.java:2211)
>         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
>         at org.hibernate.loader.Loader.list(Loader.java:2090)
>         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>         at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>         at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:844)
>         at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
>         at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:835)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message