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