Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <2743062.168051284423212937.JavaMail.jira@thor>
Date: Mon, 13 Sep 2010 20:13:32 -0400 (EDT)
From: "Lily Wei (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-4771) Continue investigation of automatic
 creation/update of index statistics
In-Reply-To: <27013377.329781281704596759.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lily Wei updated DERBY-4771:
----------------------------

    Attachment: derby.log
                error-stacktrace.out

Thanks Kristian for the prompt reply and explanation.
                
Good eyes. I add the "CHECKING" so it is easier for me to see what is going on for now.  
                if (tableDescriptor.getTableType() ==
                        TableDescriptor.BASE_TABLE_TYPE &&
                        tableDescriptor.getTotalNumberOfIndexes() > 0) {
                    System.out.println("CHECKING: " + tableDescriptor.getQualifiedName());
                    long rows = baseRowCount();
                    if (statisticsForTable) {
                        tableDescriptor.markForIndexStatsUpdate(rows);
                    } else if (rows > 100) {
                        // Only create statistics if there are "enough" rows.
                        tableDescriptor.markForIndexStatsUpdate(-1);
                    }
                }

I delete all existing directories before I run the test suites.  I run the testOSReadOnly and it failed as I run it individually. I am attaching the error-stacktrace.out and derby.log and hope it is helpful to you.

With database status, I mean it allows us to know the state of the database. i.e. read-only status.


> Continue investigation of automatic creation/update of index statistics
> -----------------------------------------------------------------------
>
>                 Key: DERBY-4771
>                 URL: https://issues.apache.org/jira/browse/DERBY-4771
>             Project: Derby
>          Issue Type: Task
>            Reporter: Kristian Waagan
>         Attachments: derby-4771-1a-prototype_code_dump.diff, derby-4771-1a-prototype_code_dump.stat, derby-4771-1b-prototype_code_dump.diff, derby.log, error-stacktrace.out, rjall.out, rjall.out
>
>
> Work was started to improve Derby's handling of index statistics. This issue tracks further discussion and work for this task.

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