The moose likes Testing and the fly likes JMeter test run leaks Oracle Sessions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Engineering » Testing
Bookmark "JMeter test run leaks Oracle Sessions" Watch "JMeter test run leaks Oracle Sessions" New topic
Author

JMeter test run leaks Oracle Sessions

tim too
Greenhorn

Joined: Mar 14, 2010
Posts: 1
Hi,

I'm using JMeter v2.3.4 to load test a GWT based web application. The webserver used is Tomcat v6.0.20.

When I run a simple JMeter recording which queries database and displays some information on the browser, I see lot of sessions getting created in the Oracle. These sessions become INACTIVE and do not get terminated once the recording completes its execution. The next run of the same recording again creates the same number of sessions. Because of this behavior, once I run out of all the Oracle sessions available, my subsequent executions of the test start failing.

This problem is not seen when the test is run directly using the application (i.e. without using JMeter). Please throw some light on what is the actual problem and how to fix it.

Thanks & Regards,
Tim
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

JMeter shouldn't do anything differently than a browser does (except not run JavaScript, which makes me wonder how you're using it to test a GWT app). It has no way of directly affecting server behavior--it cannot hold Oracle sessions open. I'd be suspicious that your tests aren't logging out or doing something similar that affects app behavior--but it can't be JMeter itself causing a server-side issue.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31054
    
162

tim too wrote:This problem is not seen when the test is run directly using the application (i.e. without using JMeter). Please throw some light on what is the actual problem and how to fix it.

Sounds like a connection leak in the application itself. It wouldn't show up in manual testing because you don't put forth enough requests. I would look at the code and check you are always closing connections (and in a finally block.)


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JMeter test run leaks Oracle Sessions