db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Embretsen <John.Embret...@Sun.COM>
Subject Re: [jira] Updated: (DERBY-210) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed
Date Mon, 06 Feb 2006 15:23:47 GMT
John Embretsen wrote:

> I suspect there will be other issues that are uncovered by running the
> DOTS test case (or variations of it) with various configurations, but
> they may or may not be related to this particular issue. I will
> certainly let you know as soon as possible if I notice any memory leaks.
> I will run the test against a patched Derby trunk for a while longer,
> and see how it goes.

Here's an update:

I was running the DOTS test case (unmodified) this weekend using a
maximum number of 20 concurrent db connections. The Network Server threw
an "OutOfMemoryError: PermGen space" about 55 hours into the test run,
with same heap size as earlier (128 MB heap, 64 MB PermSpace).

So it seems that the patch does not completely eliminate the problem
associated with that particular test case. However, I do not believe
this test failure is a showstopper for the patch. More testing is needed
in order to determine if the failure is caused by
    * lack of explicitly closing all statements
    * using/compiling too many different statements (i.e., more than the
current heap size can handle)
    * something else
    * a combination of the above


View raw message