You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "Phil Steitz (JIRA)" <ji...@apache.org> on 2007/04/09 00:07:32 UTC
[jira] Commented: (DBCP-213) DBCP causes tomcat to hang under
moderate load
[ https://issues.apache.org/jira/browse/DBCP-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487461 ]
Phil Steitz commented on DBCP-213:
----------------------------------
What versions of commons-dbcp and commons-pool are your running?
> 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