[ https://issues.apache.org/jira/browse/DERBY-4294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lily Wei updated DERBY-4294: ---------------------------- Attachment: Derby4294_pid6920.zip This is the heap dump from OOM with the test case. Thank to Kathey and espinha for showing me how to do this. java -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/kmarsden/repro/derby-4294 org.apache.derby.tools.ij run the query and cause the OOM exception. Then exit. there will be a java_pid<pid>.hprof file. [15:03] jhat java_pid6920.hprof and then with your browser connect to http://localhost:7000 there are good quick instructions at http://www.marcsturlese.com/2009/05/09/analyzing-java-heaps-with-jmap-and-jhat/ > java.lang.OutOfMemoryError from mailjdbc test after running for one hour from > select * from REFRESH.INBOX > --------------------------------------------------------------------------------------------------------- > > Key: DERBY-4294 > URL: https://issues.apache.org/jira/browse/DERBY-4294 > Project: Derby > Issue Type: Bug > Components: Store > Affects Versions: 10.3.3.0 > Environment: Window Vista > Reporter: Lily Wei > Attachments: Derby4294_pid6920.zip, Heapspaceerror.zip > > Original Estimate: 0h > Remaining Estimate: 0h > > After running mailjdbc test on 10.3 branch, select * from REFRESH.INBOX gave > me error like: > ERROR XJ001: Java exception: 'Java heap space: java.lang.OutOfMemoryError' > I also see the same error on 10.5 branch. > I inculde my mailsdb directory in this bug too. > How to reproduce this issue: > 1. cd mailjdbc > 2. java org.apache.derbyTesting.system.mailjdbc.MailJdbc embedded > 3. Wait for an hour and ignore Primary key violation error > ( : INFO :Refresh Thread : Error while inserting attachments:The statement > was ab > orted because it would have caused a duplicate key value in a unique or > primary > key constraint or unique index identified by 'ATTACH__PK' defined on > 'ATTACH'.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.