db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Hellkamp (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1781) Process handles appear to be leaking in queries using an IN clause during concurrent DB access
Date Tue, 29 Aug 2006 23:56:22 GMT
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

       

Mime
View raw message