[opencms-dev] problem with threads number on tomcat

Thu Oct 30 17:06:01 CET 2003

 Giuseppe,

I had the same problem with my MSSQL and found that if I set
"SelectMethod=Cursor" it controled my threading problem. Opencms kept
opening threads and not closing them. Eventually it took down the server. I
hope this helps.

pool.mssqlonline.url=jdbc:microsoft:sqlserver://WS2KRDB1A:1433;SelectMethod=Cursor

Dean Bradley
Information Systems
Applications Development
________________________________________

"Ars Gratia Artis"

                      Giuseppe Troianiello                                                                                                
                      <giuseppe.troianiell        To:       opencms-dev at opencms.org                                                       
                      o at agora.it>                 cc:                                                                                     
                      Sent by:                    Subject:  [opencms-dev] problem with threads number on tomcat                           
                      opencms-dev-admin at op                                                                                                
                      encms.org                                                                                                           

                      10/30/2003 09:52 AM                                                                                                 
                      Please respond to                                                                                                   
                      opencms-dev                                                                                                         

Dear all
I experienced this kind of problem:

At least once a week my OpenCMS-based web-site crashes, due to a problem
about threads. The message I can read on stdout is
INFO: All threads are busy, waiting. Please increase maxThreads or check
the servlet status75 75

Last time I had this inconvenient I dumped  all active threads, and I could
notice a lot of  traces like the ones I refer below.
I could increase maxThreads, but I suppose I would only delay my problems.
The question seems to me to belong to database connections.

My system configuration is Linux Red Hat 9.2, tomcat 4.1.18, opencms 5.0,
jdk 142_01-b06, mysql 3.23.58

Thanks,
    Giuseppe

"Thread-4410" daemon prio=1 tid=0x08959250 nid=0x6546 waiting for monitor
entry [5dcb5000..5dcb5d98]
    at java.sql.DriverManager.getConnection(DriverManager.java:187)
    - waiting to lock <0x54eff978> (a java.lang.Class)
    at
com.opencms.file.genericSql.CmsDbAccess.readUser(CmsDbAccess.java:10136)
    at
com.opencms.file.genericSql.CmsResourceBroker.readUser(CmsResourceBroker.java:6478)

    at com.opencms.file.CmsRequestContext.init(CmsRequestContext.java:172)
    at com.opencms.file.CmsObject.init(CmsObject.java:2200)
    at com.opencms.core.OpenCms.initUser(OpenCms.java:896)
    at
com.opencms.core.OpenCmsHttpServlet.initUser(OpenCmsHttpServlet.java:473)
    at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:304)
    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(ApplicationFilterChain.java:247)

    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)

    at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)

    at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)

    at java.lang.Thread.run(Thread.java:534)

"Thread-4409" daemon prio=1 tid=0x08958698 nid=0x6546 waiting for monitor
entry [5dc35000..5dc35e18]
    at java.sql.DriverManager.getConnection(DriverManager.java:187)
    - waiting to lock <0x54eff978> (a java.lang.Class)
    at
com.opencms.file.genericSql.CmsDbAccess.readUser(CmsDbAccess.java:10136)
    at
com.opencms.file.genericSql.CmsResourceBroker.readUser(CmsResourceBroker.java:6478)

    at com.opencms.file.CmsRequestContext.init(CmsRequestContext.java:172)
    at com.opencms.file.CmsObject.init(CmsObject.java:2200)
    at com.opencms.core.OpenCms.initUser(OpenCms.java:896)
    at
com.opencms.core.OpenCmsHttpServlet.initUser(OpenCmsHttpServlet.java:473)
    at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:304)
    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(ApplicationFilterChain.java:247)

    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)

    at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)

    at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)

    at java.lang.Thread.run(Thread.java:534)

"Thread-4408" daemon prio=1 tid=0x08957ae0 nid=0x6546 in Object.wait()
[5dbb5000..5dbb5e98]
    at java.lang.Object.wait(Native Method)
    at java.lang.Object.wait(Object.java:429)
    at org.apache.tomcat.util.threads.ThreadPool.runIt(ThreadPool.java:232)
    - locked <0x45b49628> (a org.apache.tomcat.util.threads.ThreadPool)
    at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:503)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)

    at java.lang.Thread.run(Thread.java:534)

"Thread-4407" daemon prio=1 tid=0x089567a8 nid=0x6546 waiting for monitor
entry [5db35000..5db35f18]
    at java.sql.DriverManager.getConnection(DriverManager.java:187)
    - waiting to lock <0x54eff978> (a java.lang.Class)
    at
com.opencms.file.genericSql.CmsDbAccess.readUser(CmsDbAccess.java:10136)
    at
com.opencms.file.genericSql.CmsResourceBroker.readUser(CmsResourceBroker.java:6478)

    at com.opencms.file.CmsRequestContext.init(CmsRequestContext.java:172)
    at com.opencms.file.CmsObject.init(CmsObject.java:2200)
    at com.opencms.core.OpenCms.initUser(OpenCms.java:896)
    at
com.opencms.core.OpenCmsHttpServlet.initUser(OpenCmsHttpServlet.java:473)
    at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:304)
    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(ApplicationFilterChain.java:247)

    at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

    at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)

    at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

    at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

    at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)

    at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
    at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)

    at java.lang.Thread.run(Thread.java:534)

_______________________________________________ This mail is send to you
from the opencms-dev mailing list To change your list options, or to
unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev