Memory do not return to the system after Shuting down derby 10.2.1.0
--------------------------------------------------------------------
Key: DERBY-1713
URL: http://issues.apache.org/jira/browse/DERBY-1713
Project: Derby
Issue Type: Bug
Components: Performance
Affects Versions: 10.2.0.0
Environment: Windows XP SP2
JRE 1.6 beta2
Reporter: Ibrahim
Priority: Critical
I face a problem when querying large tables. I run the below SQL and it stuck
in this query and throws java heap exception OutOfMemory:
SELECT count(*) FROM <table> WHERE .....
N.B. I'm using a database of more than 90,000 records (40 MB). I set the
maxHeap to 32 MB (all other settings have the default value, pageCache ... etc
).
Then, I shutdown the database but the memory is not returned to the system (and
remain 32 MB [max threshold]). I tried to increase the maxHeap to 128 MB in
which it works and releases the memory, so I think the problem is when it
reaches the maxHeap then it seems to not respond to anything such as closing
the connection or shutting down the database. How can I get rid of this?
(because i cannot increase the maxHeap as the database increases, I want to
throw an exception and release the memory)
I'm using this to shutdown the DB:
try{DriverManager.getConnection("jdbc:derby:;shutdown=true");}
catch(SQLException ex){System.err.println("SQLException: " + ex.getMessage());}
I'm using a memory Profiler for monitoring the memory usage.
Thanks in advanced.
--
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
