tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sasidhar prabhakar <sasidhar1...@gmail.com>
Subject Re: pool error timeout waiting for idle object
Date Thu, 09 Sep 2010 09:17:57 GMT
tomcat - 6
oracle 11g
centos 5
jdbc type 4


the thread dump some of threads are

"http-80-262" daemon prio=1 tid=0x73048fd8 nid=0x268a waiting for monitor
entry [0x6f975000..0x6f9760b0]
    at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    - waiting to lock <0x87287c00> (a
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory)
    at
org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
    at
org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
    at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at com.common.dao.LoginDAO.login(LoginDAO.java:87)
     at com.common.bo.LoginBO.login(LoginBO.java:28)
    at com.common.actionform.LoginForm.validate(LoginForm.java:54)
    at
org.apache.struts.action.RequestProcessor.processValidate(RequestProcessor.java:945)


"http-80-259" daemon prio=1 tid=0x71903f60 nid=0x2687 waiting for monitor
entry [0x6fbfa000..0x6fbfb030]
    at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    - waiting to lock <0x87287c00> (a
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory)
    at
org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
    at
org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
    at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at
com.cont.quiz.dao.QuizDAO.updateUserSelectionOfQOption(QuizDAO.java:320)
     at com.cont.quiz.bo.QuizBO.updateUserSelectionOfQOption(QuizBO.java:51)
    at
com.cont.quiz.action.AnsOfQuizQuestionAction.execute(AnsOfQuizQuestionAction.java:61)
    at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
    at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)


"http-80-257" daemon prio=1 tid=0x7aafeb68 nid=0x242b waiting for monitor
entry [0x6fc7b000..0x6fc7beb0]
    at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    - waiting to lock <0x87287c00> (a
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory)
    at
org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
    at
org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
    at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at com.stat.dao.StatisticsDAO.updateVisitor(StatisticsDAO.java:75)
     at com.stat.bo.StatisticsBO.updateVisitor(StatisticsBO.java:27)
    at org.apache.jsp.jsp.common_jsp._jspService(main_jsp.java:650)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


On Thu, Sep 9, 2010 at 2:31 PM, Mark Thomas <markt@apache.org> wrote:

> On 09/09/2010 07:57, sasidhar prabhakar wrote:
> > My application sometimes responding very slow.
> > When I observed the logs, it is showing these lines
> >
> > Cannot get a connection, pool error Timeout waiting for idle object.
>
> > The maximum connections on oracle I set 150.
>
> <snip/>
>
> >   maxActive="200"
>
> That doesn't look right.
>
> There are lots of things that could be going on here and you have
> provided very little in the way of information. Questions it would be
> helpful to have the answers to include:
>
> - Tomcat version
> - Oracle version
> - Oracle JDBC driver type and version
> - Number of connections from Tomcat reported by Oracle when this happens
> - What does a thread dump show those connections are doing
>
> Mark
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message