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


Mime
View raw message