You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "Sanjay Dahiya (JIRA)" <ji...@apache.org> on 2007/04/08 23:07:32 UTC
[jira] Created: (DBCP-213) DBCP causes tomcat to hang under
moderate load
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
[jira] Commented: (DBCP-213) DBCP causes tomcat to hang under
moderate load
Posted by "Sanjay Dahiya (JIRA)" <ji...@apache.org>.
[ 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
[jira] Resolved: (DBCP-213) DBCP causes tomcat to hang under
moderate load
Posted by "Sanjay Dahiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DBCP-213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sanjay Dahiya resolved DBCP-213.
--------------------------------
Resolution: Invalid
> 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
[jira] Commented: (DBCP-213) DBCP causes tomcat to hang under
moderate load
Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DBCP-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487486 ]
Phil Steitz commented on DBCP-213:
----------------------------------
Thanks for the info. You should run pool 1.3 with DBCP 1.2.2, but that is not likely to change anything here, as it looks to me from the stack traces that what is going on is the pool is exhausted and unless you or Hibernate (unlikely) are changing the settings somewhere, the default behavior for commons pool is to block (indefinitely) when the pool is exhausted. You can address this in a couple of ways. First, make sure you are closing connections so they get returned to the pool and that maxActive is set high enough to handle your concurrent load. Second, set the maxWait property of the BasicDataSource (should be able to do this via Hibernate config) to a positive number (must be >0), which is the number of milliseconds that a thread waiting for an available object from the pool will wait before throwing an exception.
> 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
[jira] Commented: (DBCP-213) DBCP causes tomcat to hang under
moderate load
Posted by "Phil Steitz (JIRA)" <ji...@apache.org>.
[ 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
[jira] Commented: (DBCP-213) DBCP causes tomcat to hang under
moderate load
Posted by "Sanjay Dahiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DBCP-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487474 ]
Sanjay Dahiya commented on DBCP-213:
------------------------------------
I am using commons-dbcp-1.2.2.jar, commons-pool-1.2.jar. Tried with commons-dbcp-1.2.1 as well with same result.
> 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