Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 26293 invoked from network); 14 Apr 2009 21:25:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Apr 2009 21:25:37 -0000 Received: (qmail 18774 invoked by uid 500); 14 Apr 2009 21:25:36 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 18717 invoked by uid 500); 14 Apr 2009 21:25:36 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 18709 invoked by uid 99); 14 Apr 2009 21:25:36 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Apr 2009 21:25:36 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Apr 2009 21:25:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id EB551234C003 for ; Tue, 14 Apr 2009 14:25:14 -0700 (PDT) Message-ID: <215541270.1239744314948.JavaMail.jira@brutus> Date: Tue, 14 Apr 2009 14:25:14 -0700 (PDT) From: "Kathey Marsden (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4152) mailjdbc test database grows very fast with 10.5 In-Reply-To: <1879100697.1239143412944.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12698945#action_12698945 ] Kathey Marsden commented on DERBY-4152: --------------------------------------- I did just a quick ten minute run (by my watch) with 10.4 and trunk and compared some data points. I don't know that this short run really means much of anything except that clearly both versions are growing faster than they should, given the data that is in the database. 10.6.0.0 alpha sane 8 primary key violations. (ERROR 23505) du -sk mailsdb 122764 mailsdb last assessment in Activity.out : INFO :Backup Thread : dbsize after compress : 88571904 [C:/kmarsden/repro/derby-4152/trunk] wc performance.out 177 2213 12269 performance.out ij> connect 'jdbc:derby:mailsdb'; ij> select sum(length(message)) from refresh.inbox; 1 ----------- 18592990 ij> select count(*) from refresh.inbox; 1 ----------- 10 ij> select * from new org.apache.derby.diag.SpaceTable('REFRESH','INBOX') t; CONGLOMERATENAME |ISIND&|NUMALLOCATEDPAGES |NUMFREEPAGES |NUMUNFILLEDPAGES |PAGESIZE |ESTIMSPACESAVING ------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------- INBOX |0 |1015 |155 |24 |32768 |5079040 SQL090414131918880 |1 |1 |0 |1 |4096 |0 TO_DELETE_INDEX |1 |1 |0 |1 |4096 |0 TO_NAME_INDEX |1 |1 |0 |1 |4096 |0 DATE_INDEX |1 |1 |0 |1 |4096 |0 ATTACH_INDEX |1 |1 |0 |1 |4096 |0 6 rows selected ij> ij> select count(*) from refresh.attach; 1 ----------- 2 ij> select sum(length(attachment)) from refresh.attach; 1 ----------- 4436906 1 row selected ij> select * from new org.apache.derby.diag.SpaceTable('REFRESH','ATTACH') t; CONGLOMERATENAME |ISIND&|NUMALLOCATEDPAGES |NUMFREEPAGES |NUMUNFILLEDPAGES |PAGESIZE |ESTIMSPACESAVING ----------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- ATTACH |0 |1676 |82 |10 |32768 |2686976 SQL090414131918990 |1 |1 |0 |1 |4096 |0 SQL090414131918991 |1 |1 |0 |1 |4096 |0 ATTACH_AT_INDEX |1 |1 |0 |1 |4096 |0 4 rows selected 10.4.2.1 (head of 10.4 branch) 4 primary key violations (ERROR 23505) du -sk mailsdb 85603 mailsdb last assesment in Activity.out : INFO :Backup Thread : dbsize after compress : 45776896 [C:/kmarsden/repro/derby-4152/10.4] wc performance.out 179 2219 12363 performance.out ij> select sum(length(message)) from refresh.inbox; 1 ----------- 7895585 ij> select count(*) from refresh.inbox; 1 ----------- 9 ij> select * from new org.apache.derby.diag.SpaceTable('REFRESH','INBOX') t; CONGLOMERATENAME |ISIND&|NUMALLOCATEDPAGES |NUMFREEPAGES |NUMUNFILLEDPAGES |PAGESIZE |ESTIMSPACESAVING ------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------- INBOX |0 |319 |635 |13 |32768 |20807680 SQL090414133519540 |1 |1 |0 |1 |4096 |0 TO_DELETE_INDEX |1 |1 |0 |1 |4096 |0 TO_NAME_INDEX |1 |1 |0 |1 |4096 |0 DATE_INDEX |1 |1 |0 |1 |4096 |0 ATTACH_INDEX |1 |1 |0 |1 |4096 |0 6 rows selected ij> select count(*) from refresh.attach; 1 ----------- 0 ij> select * from new org.apache.derby.diag.SpaceTable('REFRESH','ATTACH') t; CONGLOMERATENAME |ISIND&|NUMALLOCATEDPAGES |NUMFREEPAGES |NUMUNFILLEDPAGES |PAGESIZE |ESTIMSPACESAVING ------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------- ATTACH |0 |528 |133 |3 |32768 |4358144 SQL090414133519630 |1 |1 |0 |1 |4096 |0 SQL090414133519631 |1 |1 |0 |1 |4096 |0 ATTACH_AT_INDEX |1 |1 |0 |1 |4096 |0 4 rows selected ij> > 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: 10.5.1.0 > 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 > > When I ran the mailjdbc test on 10.5.1.0 RC I found that the mailsdb database grew to 16GB after two days. On 10.4.2.0 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.