commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gerald....@ubs.com
Subject RE: [DBCP] Deadlock problem?
Date Tue, 02 Dec 2003 17:05:11 GMT
Frank:
   I had a similar problem, first you have to change your resource param to use the org.apache.commons.dbcp.BasicDataSourceFactory.
If you do not use org.apache.commons.dbcp.BasicDataSourceFactory, you will get stuck with
the default, which did not seem to work well for me. Use this as an example, and of course
check you code for leaks, and race conditions.
-Jerry

 <!-- JNDI Name for the DataSource -->
               <Resource name="jdbc/SOMENAME" auth="Container" type="javax.sql.DataSource"
/>

               <ResourceParams name="jdbc/SOMENAME">
               	  <parameter>
                     <name>factory</name>

                     <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                  </parameter>	
               
                  <parameter>
                     <name>username</name>

                     <value>88888</value>
                  </parameter>

                  <parameter>
                     <name>password</name>

                     <value>888888</value>
                  </parameter>

                  <parameter>
                     <name>driverClassName</name>

                     <value>com.sybase.jdbc2.jdbc.SybDriver</value>
                  </parameter>
                  
                  <parameter>
                     <name>testOnBorrow</name>

                     <value>true</value>
                  </parameter>
                  
                  <parameter>
                     <name>testOnReturn</name>

                     <value>false</value>
                  </parameter>
                  
                   
				  <parameter>
                     <name>validationQuery</name>

                     <value>SELECT count(*)  FROM  MYTABLE</value>
                  </parameter>	
                  
                  <parameter>
      				<name>url</name>
      					<value>url</value>
    			  </parameter>
	                  
				<!-- Maximum number of dB connections in pool. Make sure you
         			configure your DB max connections large enough to handle
         			all of your db connections. Set to 0 for no limit.
         			-->
				 <parameter>
                     <name>maxActive</name>

                     <value>40</value>
                  </parameter>
				<!-- Maximum number of idle dB connections to retain in pool.
         			 Set to 0 for no limit. 
         			 -->
         			<parameter>
                     <name>maxIdle</name>

                     <value>5</value>
                  </parameter>
                  
                  <!-- Maximum time to wait for a dB connection to become available
         			   in ms, in this example 10 seconds. An Exception is thrown if
         			   this timeout is exceeded.  Set to -1 to wait indefinitely. 
         			   -->
				    <parameter>
				      <name>maxWait</name>
				      <value>-1</value>
				    </parameter>
					   
               </ResourceParams>

-----Original Message-----
From: Frank Stolze [mailto:frank@directlyhome.com]
Sent: Tuesday, December 02, 2003 11:28 AM
To: commons-user@jakarta.apache.org
Subject: [DBCP] Deadlock problem?


Hi,

I have been having some problems with Tomcat + DBCP for some time now. I
made every effort to find the problem myself and also look through the
mailing list archives, but it seems that I'm at a dead end now. Here is
my problem:

Tomcat 4.1.27
Commons-Pool 1.1
Commons-DBCP 1.1
PostgreSQL 7.3.3

While everything works beautifully for a while, at some (seemingly)
random point in time getting a db connection from the pool fails.
Database connections are available, both idle and not yet established.

Configuration:

          <Resource auth="Container" name="jdbc/Public"
scope="Shareable" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/Public">
            <parameter>
              <name>password</name>
              <value>xxxx</value>
            </parameter>
            <parameter>
              <name>url</name>
              <value>jdbc:postgresql://localhost:5432/bfth_db</value>
            </parameter>
            <parameter>
              <name>driverClassName</name>
              <value>org.postgresql.Driver</value>
            </parameter>
            <parameter>
              <name>username</name>
              <value>xxxx</value>
            </parameter>
          </ResourceParams>

Here are two representative thread dumps:

===
Full thread dump Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode):

"MonitorRunnable" daemon prio=1 tid=0x08669ad0 nid=0x722c in
Object.wait() [4f7a2000..4f7a28b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x464199f0> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.java:503)
	- locked <0x464199f0> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-10" daemon prio=1 tid=0x0857f988 nid=0x722b runnable
[4f721000..4f7218b8]
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
	- locked <0x46419a70> (a java.net.PlainSocketImpl)
	at java.net.ServerSocket.implAccept(ServerSocket.java:448)
	at java.net.ServerSocket.accept(ServerSocket.java:419)
	at org.apache.jk.common.ChannelSocket.accept(ChannelSocket.java:268)
	at
org.apache.jk.common.ChannelSocket.acceptConnections(ChannelSocket.java:531)
	at org.apache.jk.common.SocketAcceptor.runIt(ChannelSocket.java:660)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-9" daemon prio=1 tid=0x087342c0 nid=0x722a in Object.wait()
[4f6a0000..4f6a08b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46419c68> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x46419c68> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-8" daemon prio=1 tid=0x08734008 nid=0x7229 in Object.wait()
[4f61f000..4f61f8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46419ce0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x46419ce0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-7" daemon prio=1 tid=0x0857ffe0 nid=0x7228 in Object.wait()
[4f59e000..4f59e8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46419d58> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x46419d58> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"MonitorRunnable" daemon prio=1 tid=0x4e4f8818 nid=0x7227 in
Object.wait() [4f51d000..4f51d8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x463d6dd8> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.java:503)
	- locked <0x463d6dd8> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-5" daemon prio=1 tid=0x4e2b60c8 nid=0x7226 in Object.wait()
[4f49b000..4f49c8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:793)
	- locked <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
	at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
	at com.bfth.util.DBBean.getTotalProductCount(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at
org.apache.taglibs.standard.lang.jstl.ArraySuffix.evaluate(ArraySuffix.java:317)
	at
org.apache.taglibs.standard.lang.jstl.ComplexValue.evaluate(ComplexValue.java:146)
	at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:242)
	at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:201)
	at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:138)
	at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:166)
	at
org.apache.taglibs.standard.lang.support.ExpressionEvaluatorManager.evaluate(ExpressionEvaluatorManager.java:112)
	at
org.apache.taglibs.standard.tag.el.core.ExpressionUtil.evalNotNull(ExpressionUtil.java:85)
	at
org.apache.taglibs.standard.tag.el.core.OutTag.evaluateExpressions(OutTag.java:137)
	at
org.apache.taglibs.standard.tag.el.core.OutTag.doStartTag(OutTag.java:95)
	at
org.apache.jsp.products_jsp._jspx_meth_c_out_0(products_jsp.java:336)
	at org.apache.jsp.products_jsp._jspService(products_jsp.java:147)
	at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
	at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
	at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
	at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-4" daemon prio=1 tid=0x4e24b3e8 nid=0x7225 runnable
[4f41b000..4f41b8b8]
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
	- locked <0x462d5758> (a java.net.PlainSocketImpl)
	at java.net.ServerSocket.implAccept(ServerSocket.java:448)
	at java.net.ServerSocket.accept(ServerSocket.java:419)
	at
org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(DefaultServerSocketFactory.java:107)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoint.java:356)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:529)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-3" daemon prio=1 tid=0x4e24b288 nid=0x7224 in Object.wait()
[4f399000..4f39a8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:793)
	- locked <0x46514830> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
	at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
	at com.bfth.export.CSVGenerator.prepare(Unknown Source)
	at
com.bfth.export.DataFileGeneratorFactory.getDataFileGenerator(Unknown
Source)
	at com.bfth.export.DataFileGeneratorServlet.doGet(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
	at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
	at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-2" daemon prio=1 tid=0x4e24b068 nid=0x7223 in Object.wait()
[4f319000..4f3198b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x463d6ff0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x463d6ff0> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"HostConfig[localhost]" daemon prio=1 tid=0x4e24ae18 nid=0x7222 waiting
on condition [4f298000..4f2988b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.startup.HostConfig.threadSleep(Unknown Source)
	at org.apache.catalina.startup.HostConfig.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"StandardManager[/manager]" daemon prio=1 tid=0x4e266450 nid=0x7221
waiting on condition [4f217000..4f2178b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
	at org.apache.catalina.session.StandardManager.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"StandardManager[/prodmgr]" daemon prio=1 tid=0x4e200748 nid=0x7220
waiting on condition [4e3ff000..4e3ff8b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
	at org.apache.catalina.session.StandardManager.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"WebappLoader[/prodmgr]" daemon prio=1 tid=0x4e276518 nid=0x721f waiting
on condition [4f117000..4f1178b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.loader.WebappLoader.threadSleep(Unknown Source)
	at org.apache.catalina.loader.WebappLoader.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"Signal Dispatcher" daemon prio=1 tid=0x080bc0d8 nid=0x7218 waiting on
condition [0..0]

"Finalizer" daemon prio=1 tid=0x080b7710 nid=0x7216 in Object.wait()
[4107c000..4107c8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
	at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111)
	- locked <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
	at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
	at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

"Reference Handler" daemon prio=1 tid=0x080b7358 nid=0x7215 in
Object.wait() [40ffb000..40ffb8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x461e8450> (a java.lang.ref.Reference$Lock)
	at java.lang.Object.wait(Object.java:429)
	at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
	- locked <0x461e8450> (a java.lang.ref.Reference$Lock)

"main" prio=1 tid=0x08052500 nid=0x7210 runnable [bfffc000..bfffcf78]
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
	- locked <0x46419e40> (a java.net.PlainSocketImpl)
	at java.net.ServerSocket.implAccept(ServerSocket.java:448)
	at java.net.ServerSocket.accept(ServerSocket.java:419)
	at org.apache.catalina.core.StandardServer.await(Unknown Source)
	at org.apache.catalina.startup.Catalina.start(Unknown Source)
	at org.apache.catalina.startup.Catalina.execute(Unknown Source)
	at org.apache.catalina.startup.Catalina.process(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.startup.Bootstrap.main(Unknown Source)

"VM Thread" prio=1 tid=0x080b48e0 nid=0x7214 runnable 

"VM Periodic Task Thread" prio=1 tid=0x080c0420 nid=0x721c waiting on
condition 
"Suspend Checker Thread" prio=1 tid=0x080bb780 nid=0x7217 runnable 
===

And another one:

====
Full thread dump Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode):

"MonitorRunnable" daemon prio=1 tid=0x0809afc0 nid=0x668c in
Object.wait() [4f418000..4f4188b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46417918> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.java:503)
	- locked <0x46417918> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-10" daemon prio=1 tid=0x08348538 nid=0x668b runnable
[4f397000..4f3978b8]
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
	- locked <0x46417998> (a java.net.PlainSocketImpl)
	at java.net.ServerSocket.implAccept(ServerSocket.java:448)
	at java.net.ServerSocket.accept(ServerSocket.java:419)
	at org.apache.jk.common.ChannelSocket.accept(ChannelSocket.java:268)
	at
org.apache.jk.common.ChannelSocket.acceptConnections(ChannelSocket.java:531)
	at org.apache.jk.common.SocketAcceptor.runIt(ChannelSocket.java:660)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-9" daemon prio=1 tid=0x083479f0 nid=0x668a in Object.wait()
[4f316000..4f3168b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46417b90> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x46417b90> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-8" daemon prio=1 tid=0x08347008 nid=0x6689 in Object.wait()
[4f295000..4f2958b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46417c08> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x46417c08> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-7" daemon prio=1 tid=0x08348958 nid=0x6688 in Object.wait()
[4f214000..4f2148b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x46417c80> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x46417c80> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"MonitorRunnable" daemon prio=1 tid=0x08349060 nid=0x6687 in
Object.wait() [4f193000..4f1938b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x463d5740> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable.run(ThreadPool.java:503)
	- locked <0x463d5740> (a
org.apache.tomcat.util.threads.ThreadPool$MonitorRunnable)
	at java.lang.Thread.run(Thread.java:534)

"Thread-5" daemon prio=1 tid=0x08345cd8 nid=0x6686 runnable
[4f112000..4f1128b8]
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
	- locked <0x462d5798> (a java.net.PlainSocketImpl)
	at java.net.ServerSocket.implAccept(ServerSocket.java:448)
	at java.net.ServerSocket.accept(ServerSocket.java:419)
	at
org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(DefaultServerSocketFactory.java:107)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.acceptSocket(PoolTcpEndpoint.java:356)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:529)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-4" daemon prio=1 tid=0x085158b8 nid=0x6685 in Object.wait()
[4f090000..4f0918b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:793)
	- locked <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
	at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
	at com.bfth.util.DBBean.getSiteCategories(Unknown Source)
	at com.bfth.export.CSVGenerator.generate(Unknown Source)
	at com.bfth.export.DataFileGeneratorServlet.doGet(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
	at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
	at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-3" daemon prio=1 tid=0x081c63e0 nid=0x6684 in Object.wait()
[4f00f000..4f0108b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:793)
	- locked <0x4656cad8> (a
org.apache.commons.pool.impl.GenericObjectPool)
	at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
	at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
	at com.bfth.util.DBBean.getTotalProductCount(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at
org.apache.taglibs.standard.lang.jstl.ArraySuffix.evaluate(ArraySuffix.java:317)
	at
org.apache.taglibs.standard.lang.jstl.ComplexValue.evaluate(ComplexValue.java:146)
	at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:242)
	at
org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:201)
	at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:138)
	at
org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:166)
	at
org.apache.taglibs.standard.lang.support.ExpressionEvaluatorManager.evaluate(ExpressionEvaluatorManager.java:112)
	at
org.apache.taglibs.standard.tag.el.core.ExpressionUtil.evalNotNull(ExpressionUtil.java:85)
	at
org.apache.taglibs.standard.tag.el.core.OutTag.evaluateExpressions(OutTag.java:137)
	at
org.apache.taglibs.standard.tag.el.core.OutTag.doStartTag(OutTag.java:95)
	at
org.apache.jsp.products_jsp._jspx_meth_c_out_0(products_jsp.java:336)
	at org.apache.jsp.products_jsp._jspService(products_jsp.java:147)
	at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
	at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
	at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
	at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
Source)
	at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
	at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
	at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
	at java.lang.Thread.run(Thread.java:534)

"Thread-2" daemon prio=1 tid=0x081c5df8 nid=0x6683 in Object.wait()
[4ef8f000..4ef8f8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x463d5958> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Object.wait(Object.java:429)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:595)
	- locked <0x463d5958> (a
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable)
	at java.lang.Thread.run(Thread.java:534)

"HostConfig[localhost]" daemon prio=1 tid=0x08343658 nid=0x6682 waiting
on condition [4ef0e000..4ef0e8b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.startup.HostConfig.threadSleep(Unknown Source)
	at org.apache.catalina.startup.HostConfig.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"StandardManager[/manager]" daemon prio=1 tid=0x083433e0 nid=0x6681
waiting on condition [4ee8d000..4ee8d8b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
	at org.apache.catalina.session.StandardManager.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"StandardManager[/prodmgr]" daemon prio=1 tid=0x08091f98 nid=0x6680
waiting on condition [4ee0c000..4ee0c8b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.session.StandardManager.threadSleep(Unknown
Source)
	at org.apache.catalina.session.StandardManager.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"WebappLoader[/prodmgr]" daemon prio=1 tid=0x4e70ddd0 nid=0x667f waiting
on condition [4ed0c000..4ed0c8b8]
	at java.lang.Thread.sleep(Native Method)
	at org.apache.catalina.loader.WebappLoader.threadSleep(Unknown Source)
	at org.apache.catalina.loader.WebappLoader.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:534)

"Signal Dispatcher" daemon prio=1 tid=0x080bc0d0 nid=0x664f waiting on
condition [0..0]

"Finalizer" daemon prio=1 tid=0x080b7710 nid=0x664d in Object.wait()
[4107c000..4107c8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
	at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111)
	- locked <0x461e83e8> (a java.lang.ref.ReferenceQueue$Lock)
	at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
	at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

"Reference Handler" daemon prio=1 tid=0x080b7358 nid=0x664c in
Object.wait() [40ffb000..40ffb8b8]
	at java.lang.Object.wait(Native Method)
	- waiting on <0x461e8450> (a java.lang.ref.Reference$Lock)
	at java.lang.Object.wait(Object.java:429)
	at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:115)
	- locked <0x461e8450> (a java.lang.ref.Reference$Lock)

"main" prio=1 tid=0x08052500 nid=0x6641 runnable [bfffd000..bfffd8d8]
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
	- locked <0x46417cb0> (a java.net.PlainSocketImpl)
	at java.net.ServerSocket.implAccept(ServerSocket.java:448)
	at java.net.ServerSocket.accept(ServerSocket.java:419)
	at org.apache.catalina.core.StandardServer.await(Unknown Source)
	at org.apache.catalina.startup.Catalina.start(Unknown Source)
	at org.apache.catalina.startup.Catalina.execute(Unknown Source)
	at org.apache.catalina.startup.Catalina.process(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.startup.Bootstrap.main(Unknown Source)

"VM Thread" prio=1 tid=0x080b48e0 nid=0x664b runnable 

"VM Periodic Task Thread" prio=1 tid=0x080c0418 nid=0x6653 waiting on
condition 
"Suspend Checker Thread" prio=1 tid=0x080bb778 nid=0x664e runnable 
===

Any advice would be appreciated!


Frank


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


Visit our website at http://www.ubs.com

This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free 
as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses.  The sender therefore 
does not accept liability for any errors or omissions in the contents 
of this message which arise as a result of e-mail transmission.  If 
verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities or 
related financial instruments.


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


Mime
View raw message