Process handles appear to be leaking in queries using an IN clause during
concurrent DB access
----------------------------------------------------------------------------------------------
Key: DERBY-1781
URL: http://issues.apache.org/jira/browse/DERBY-1781
Project: Derby
Issue Type: Bug
Environment: Windows XP, Java 1.5.0_05
Reporter: Mark Hellkamp
Attachments: SqlStressTest.java
We are currently using Derby embedded in our web application running on
Windows. When processing multiple concurrent requests we have noticed that the
Java process handle count continues to increase until the machine becomes
unresponsive. I was able to isolate the problem to Derby by running the
database in network mode in another process. Further investigation showed that
the problem could be reproduced using a select statement that has an IN clause
with multiple entries on the primary key column. Spawning multiple threads
running the same query causes the handle count to increase considerably on the
Derby process. The problem occurs in version 10.1.3.1 and 10.2.1.1 (even worse)
in both embedded and network mode. The attached test program duplicates the
problem. Start Derby in network mode (using startNetworkServer.bat) and run the
enclosed test program. The handle count on the Derby process will increase and
never go down short of restarting Derby. Using 10.2.1.1 the handle count for
the Derby process goes somewhere between 1400-1500 with just two threads in my
environment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
