[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slide-user
Subject:    DB Connection pool leak
From:       "PRAKASH,RAJESH (HP-PaloAlto,ex1)" <rajesh.prakash () hp ! com>
Date:       2002-10-21 19:02:43
[Download RAW message or body]

Hello,

     I am using silde1.0.16 with J2EEDescriptorsStore and J2EEContentStore.
This seems to work fine with as far the functionality slide is concerned.
While trying the same in a multiuser environment the connection pool  gets
exhausted. It seems like there is a connection pool leak.  Following is the
exception that I get. 

21 Oct 2002 11:56:10 - slidestore.j2ee.J2EEDescriptorsStore - INFO - No id
for c
urrent thread (Thread[Thread-35,5,main]) - called outside transaction?
CONNDEBUG: Couldn't get connection: DBCP could not obtain an idle db
connection,
 pool exhausted
java.sql.SQLException: DBCP could not obtain an idle db connection, pool
exhaust
ed
        at
org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObj
ectPool.java:123)
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSo
urce.java:110)
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:312)
        at
slidestore.j2ee.J2EEStore$TransactionId.<init>(J2EEStore.java:515)
        at slidestore.j2ee.J2EEStore.start(J2EEStore.java:438)
        at
org.apache.slide.transaction.SlideTransaction.enlistResource(SlideTra
nsaction.java:518)
        at
org.apache.slide.store.AbstractStore.enlist(AbstractStore.java:1373)
        at
org.apache.slide.store.AbstractStore.createRevisionContent(AbstractSt
ore.java:1203)
        at
org.apache.slide.store.StandardStore.createRevisionContent(StandardSt
ore.java:654)
        at org.apache.slide.content.ContentImpl.create(ContentImpl.java:511)
        at
com.hp.esdo.ti.service.transaction.SlideTransactionController.upload(
Unknown Source)
        at
com.hp.esdo.ti.service.transaction.TransactionController.dispatchRequ
est(Unknown Source)
        at com.hp.esdo.ti.service.main.TreasureIsland.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:260)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve
.java:246)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2397)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:180)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche
rValve.java:170)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:171)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:174)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex
t.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:480)
        at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22
3)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:405)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:380)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:508)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:533)
        at java.lang.Thread.run(Thread.java:536)
CONNDEBUG: Got connection successfully
Finalizer, called close()
CONNDEBUG: Got connection successfully
Finalizer, called closeInternal(true)
Finalizer, called close()
Finalizer, called closeInternal(true)
Finalizer, called close()
Finalizer, called closeInternal(true)
Finalizer, called close()
Finalizer, called closeInternal(true)
Finalizer, called close()
Finalizer, called closeInternal(true)
Finalizer, called close()
Finalizer, called closeInternal(true)

Any thoughts???


Regards,
Rajesh



--
To unsubscribe, e-mail:   <mailto:slide-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:slide-user-help@jakarta.apache.org>

[prev in list] [next in list] [prev in thread] [next in thread]