Is it also unlimited (or insanely huge) on the database? -e
On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > i adjusted the pool to unlimited and am still getting these errors. > something else seems to be fekachte. > > barclay > > -----Original Message----- > From: Eric J. Pinnell [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 1:11 PM > To: Tomcat Users List > Subject: Re: Help! heavy traffic is crapping out our site every 5 min! > DBCP exceptions > > > Hi, > > Your pool of connections to your database is exhausted. Try upping the > number. > > -e > > On Fri, 8 Aug 2003, Barclay A. Dunn wrote: > > > we are getting a ton of these errors in our catalina.out and i could use > > help in fixing it. > > > > i know they are related to our connection pooling, but not what to do to > > fix. my understanding of the underlying mechanics of connection pooling is > > somewhat limited. > > > > i have put two different but related error messages in here: > > > > java.sql.SQLException: DBCP could not obtain an idle db connection, pool > > exhausted > > at > > > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool > > .java:123) > > at > > > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja > > va:110) > > at > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 > > 12) > > at com.happypuppy.util.HPSql.getConnection(HPSql.java:21) > > at org.apache.jsp.index_jsp._jspService(index_jsp.java:222) > > at > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > > 04) > > at > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. > > java:684) > > at > > > org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch > > er.java:575) > > at > > > org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher > > .java:498) > > at > > > org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8 > > 22) > > at org.apache.jsp._404_jsp._jspService(_404_jsp.java:373) > > at > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > > 04) > > at > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > > FilterChain.java:247) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > > ain.java:193) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > > va:260) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > > va:191) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > > ) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > > java:170) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:641) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 > > ) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:641) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > > :174) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) > > at > > org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) > > at java.lang.Thread.run(Thread.java:536) > > > > org.apache.commons.dbcp.DbcpException: java.sql.SQLException: > > [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. > > at > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne > > ctionFactory.java:85) > > at > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect > > ionFactory.java:184) > > at > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown > Source) > > at > > > org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool > > .java:117) > > at > > > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja > > va:110) > > at > > > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 > > 12) > > at com.happypuppy.util.HPSql.getConnection(HPSql.java:21) > > at com.happypuppy.util.HPUser.isLoggedIn(HPUser.java:121) > > at > > org.apache.jsp.checkLoggedIn_jsp._jspService(checkLoggedIn_jsp.java:56) > > at > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > > 04) > > at > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. > > java:684) > > at > > > org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch > > er.java:575) > > at > > > org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher > > .java:498) > > at > > > org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8 > > 22) > > at org.apache.jsp._404_jsp._jspService(_404_jsp.java:351) > > at > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 > > 04) > > at > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > > FilterChain.java:247) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > > ain.java:193) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > > va:260) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > > va:191) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > > ) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > > java:170) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:641) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 > > ) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:641) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > > :174) > > at > > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > > eNext(StandardPipeline.java:643) > > at > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:458) > > at > > org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:551) > > at java.lang.Thread.run(Thread.java:536) > > Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > > JDBC]Error establishing socket. > > at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown > > Source) > > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > Source) > > at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown > > Source) > > at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown > > Source) > > at > com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown > > Source) > > at > > com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown > Source) > > at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) > > at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) > > at > > > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne > > ctionFactory.java:83) > > ... 51 more > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
