db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lily Wei (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4771) Continue investigation of automatic creation/update of index statistics
Date Tue, 14 Sep 2010 00:13:32 GMT

     [ 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

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) {
                    } else if (rows > 100) {
                        // Only create statistics if there are "enough" rows.

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

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

View raw message