[DERBY-4294] java.lang.OutOfMemoryError from mailjdbc test after running for one hour from select * from REFRESH.INBOX

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.6.2.1
• Fix Version/s: 10.7.1.1
• Component/s: Store
• Labels: derby_triage10_5_2
• Environment: Window Vista
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Crash
• Assignee: Unassigned
• Reporter: Lily Wei
• Created: 29/Jun/09 20:38
• Updated: 17/Jun/13 09:19
• Resolved: 01/Jun/11 10:53

Description

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'.)

Issue Links

• is related to: DERBY-1511 SELECT clause without a WHERE, causes an Exception when extracting a Blob from a database
• relates to: DERBY-5257 Make ij only fetch parts of a large string/binary field when displaying it