db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4771) Continue investigation of automatic creation/update of index statistics
Date Fri, 08 Oct 2010 15:27:31 GMT

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

Kristian Waagan updated DERBY-4771:

    Attachment: derby-4771-2b-prototype_lcc_code_dump.diff

I've taken a look at the test failures:
 o failures in OrderByAndSortAvoidance were taken care of by DERBY-4833 patch 1a.
 o the failure UpdateStatisticsTest.testUpdateStatistics will continue to happen for the time
being (see DERBY-4837). The failure surfaced because the statistics are automatically generated
faster now (written to the dd as soon as they are computed).
 o the failure UpdateStatisticsTest.testNoExclusiveLockOnTable failed due to a bug in the
prototype. It left the dd in write-mode, and that causes at least one path in the dd to take
an exclusive lock instead of a shared lock when looking up stuff in the system table.
 o I suspect the failure in AutoIncrementTest.testsyslocks may have been caused by the same
bug in the prototype, but I'm not sure. It doesn't reproduce again on my machine, but it could
be timing-dependent.

I have also seen an intermittent test failure in XplainStatisticsTest, which I'm unable to
explain. Seems like there are two rows in one of the XPLAIN tables where there is supposed
to be only one.
Today I also saw the old harness test store/updatelocks.sql fail, but I haven't looked into
it yet.

I'm attaching the latest revision (patch 2b).

> 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
>            Assignee: 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-4771-2a-prototype_lcc_code_dump.diff, derby-4771-2b-prototype_lcc_code_dump.diff,
derby.log, error-stacktrace.out, rjall.out, rjall.out, rjall.rar, rjone.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