RE: DataSourceConnection not closed

[Juan Lorandi (Chile)]

yes, I've been complaining about this issues starting a month ago... check bugs #161 & #170 for more info

 

nobody from orion replies, and it's a shame, because I can´t license the products until I work my way around these

 

Anybody performing a DoS attack on any Orion Web Site will effectively crash the server

 

 

-----Original Message-----
From: Daniel G. Koulomzin [mailto:[EMAIL PROTECTED]]
Sent: Miércoles, 22 de Noviembre de 2000 11:44
To: Orion-Interest
Subject: DataSourceConnection not closed

Hi all,

I've recently been load-testing my app, and have been getting some strange problems after between 15 minutes and an hour of tests.  My application uses EJBs that are accessed through Turbine.  I'm running RedHat 6.2, with the Sun jdk1.2.2.  The database is Sybase workgroup edition.  I'm using Orion 1.3.8.

The problem is as follows:  I am using JMeter to test the performance of the site under load.  When I hit it with 10 threads that pause approximately 300ms between requests, the thing hums along with decent performance.  However, between 15 minutes and an hour later, it has what looks to be some sort of lockup (perhaps a DB table is locked, or is it a thread prob?).  Nothing really happens until the transactions time-out, and then an exception gets thrown (see below).  Sometimes, it will also print "DataSourceConnection was not closed, check your code!"  Well, I did check my code, and I never do any explicit database calls.  In fact, if you look at the stacktrace, you'll see it seems to die in Orion's generated HomeWrapper.  (Of course, this seems to be thread-related, so just because the process dies there, doesn't mean the problem is there.)  Anyway, multiple threads do share the same EJBHome.  Is that legal?  Could this be causing the problem?

Here's that stack trace:

com.evermind.server.rmi.OrionRemoteException: SQL Error opening DataSource: Timed out waiting for an avai
lable connection after 60 second (connection pool reached max-connections which was set to 6)
        at com.evermind.server.ejb.DataSourceConnectionContainer.getConnection(JAX)
        at FeatureHome_EntityHomeWrapper12.findRankedFeatures(FeatureHome_EntityHomeWrapper12.java:1645)
        at com.dbusa.webmacro.helpers.feature.FeatureHelper.getRankedFeatures(FeatureHelper.java:61)
        at com.dbusa.webmacro.helpers.feature.FeatureHelper.loadRankedFeatures(FeatureHelper.java:89)
        at com.dbusa.webmacro.helpers.feature.FeatureHelper.loadRankedCommentaries(FeatureHelper.java:103)
        at com.dbusa.webmacro.navigations.MessageBoardTease.doBuildTemplate(MessageBoardTease.java:43)
        at org.apache.turbine.modules.navigations.WebMacroSiteNavigation.doBuildTemplate(WebMacroSiteNavigation.java:117)
        at org.apache.turbine.modules.navigations.TemplateNavigation.doBuild(TemplateNavigation.java:110)
        at org.apache.turbine.modules.navigations.WebMacroSiteNavigation.doBuild(WebMacroSiteNavigation.java:131)
        at org.apache.turbine.modules.Navigation.build(Navigation.java:99)
        at org.apache.turbine.modules.NavigationLoader.eval(NavigationLoader.java:126)
        at org.apache.turbine.util.webmacro.WebMacroNavigation.toString(WebMacroNavigation.java:133)
        at org.webmacro.engine.Variable.write(Variable.java:156)
        at org.webmacro.engine.Block.write(Block.java:56)
        at org.webmacro.engine.WMTemplate.write(WMTemplate.java:251)
        at org.apache.turbine.services.webmacro.TurbineWebMacroService.handleRequest(TurbineWebMacroService.java:237)
        at org.apache.turbine.services.webmacro.TurbineWebMacroService.handleRequest(TurbineWebMacroService.java:208)
        at org.apache.turbine.services.webmacro.TurbineWebMacro.handleRequest(TurbineWebMacro.java:107)
        at org.apache.turbine.modules.layouts.WebMacroSiteLayout.doBuild(WebMacroSiteLayout.java:131)
        at org.apache.turbine.modules.Layout.build(Layout.java:93)
        at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:120)
        at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:171)
        at org.apache.turbine.modules.Page.build(Page.java:92)
        at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:119)
        at org.apache.turbine.Turbine.doGet(Turbine.java:366)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java)
        at com.evermind.server.http.d1.si(JAX)
        at com.evermind.server.http.d1.forward(JAX)
        at com.evermind.server.http.ed.sp(JAX)
        at com.evermind.server.http.ed.so(JAX)
        at com.evermind.util.f.run(JAX)

        Nested exception is:
java.sql.SQLException: Timed out waiting for an available connection after 60 second (connection pool rea
ched max-connections which was set to 6)
        at com.evermind.sql.OrionPooledDataSource.d1(JAX)
        at com.evermind.sql.OrionPooledDataSource.d3(JAX)
        at com.evermind.server.ejb.DataSourceConnection.<init>(JAX)
        at com.evermind.server.ejb.DataSourceConnectionContainer.getConnection(JAX)
        at FeatureHome_EntityHomeWrapper12.findRankedFeatures(FeatureHome_EntityHomeWrapper12.java:1645)
        at com.dbusa.webmacro.helpers.feature.FeatureHelper.getRankedFeatures(FeatureHelper.java:61)
        at com.dbusa.webmacro.helpers.feature.FeatureHelper.loadRankedFeatures(FeatureHelper.java:89)
        at com.dbusa.webmacro.helpers.feature.FeatureHelper.loadRankedCommentaries(FeatureHelper.java:103)
        at com.dbusa.webmacro.navigations.MessageBoardTease.doBuildTemplate(MessageBoardTease.java:43)
        at org.apache.turbine.modules.navigations.WebMacroSiteNavigation.doBuildTemplate(WebMacroSiteNavigation.java:117)
        at org.apache.turbine.modules.navigations.TemplateNavigation.doBuild(TemplateNavigation.java:110)
        at org.apache.turbine.modules.navigations.WebMacroSiteNavigation.doBuild(WebMacroSiteNavigation.java:131)
        at org.apache.turbine.modules.Navigation.build(Navigation.java:99)
        at org.apache.turbine.modules.NavigationLoader.eval(NavigationLoader.java:126)
        at org.apache.turbine.util.webmacro.WebMacroNavigation.toString(WebMacroNavigation.java:133)
        at org.webmacro.engine.Variable.write(Variable.java:156)
        at org.webmacro.engine.Block.write(Block.java:56)
        at org.webmacro.engine.WMTemplate.write(WMTemplate.java:251)
        at org.apache.turbine.services.webmacro.TurbineWebMacroService.handleRequest(TurbineWebMacroService.java:237)
        at org.apache.turbine.services.webmacro.TurbineWebMacroService.handleRequest(TurbineWebMacroService.java:208)
        at org.apache.turbine.services.webmacro.TurbineWebMacro.handleRequest(TurbineWebMacro.java:107)
        at org.apache.turbine.modules.layouts.WebMacroSiteLayout.doBuild(WebMacroSiteLayout.java:131)

-- 
Daniel G. Koulomzin
Digital Media On Demand
244 Brighton Ave. 3rd Floor
Allston MA 02134