db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4152) mailjdbc test database grows very fast with 10.5
Date Thu, 16 Apr 2009 13:07:14 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12699691#action_12699691

Kathey Marsden commented on DERBY-4152:

I was having some trouble understanding the attachment insert code to try to eliminate the
PK contraint violations, so myrna suggested as a first step I remove the insert of the attachments
all together and run for a while to see if there is any growth in the INBOX.  I ran overnight
and without the attachment inserts  and found no growth  problems, so the  growth is in the
attachments.  I will work harder now to put the attachments back in but eliminate the possibility
of constraint violations in the  attachment insert code.

> mailjdbc test database  grows very fast with 10.5
> -------------------------------------------------
>                 Key: DERBY-4152
>                 URL: https://issues.apache.org/jira/browse/DERBY-4152
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions:
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pwi3260sr3-20081106_07(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 Windows 2000 x86-32 jvmwi3260-200811
> 05_25433 (JIT enabled, AOT enabled)
> J9VM - 20081105_025433_lHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> Windows 2000 5.00.2195 /Service pack 4
> 4 CPU 3.00GHz
>            Reporter: Kathey Marsden
>            Priority: Critical
>         Attachments: TestInPlaceCompressWithPKViolation.java, TestInPlaceCompressWithPKViolation.java
> When I ran the mailjdbc test on RC I found that the mailsdb database grew to
16GB after two days.  On  on the same machine with the same configuration (no derby.properties)
it grew to only 1.7GB after 7 days.  Both were sane builds.
> This is with the embedded configuration:
> java org.apache.derbyTesting.system.mailjdbc.MailJdbc embedded

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message