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 Mon, 04 Oct 2010 17:16: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: rjone.out

With more tracking and specific tracing in the JDBC.java and RuntimeStatisticsParser.java,
I generate rjone.out for 'java -Dderby.tests.trace=true -Dderby.language.disableIndexStatsUpdate=false
-Dd
erby.language.logIndexStatsUpdate=true -Dderby.language.traceIndexStatsUpdate=bo
th junit.textui.TestRunner org.apache.derbyTesting.functionTests.tests.lang.Upda
teStatisticsTest' Form looking by the output, the unexpected result row come from 'SELECT
* FROM SYS.STATISTICS'for 'Index Scan ResultSet for T2 using index T2I1'. And, it gets error
'A lock could not be obtained within the time requested' was thrown while evaluating an expression.'
 The test did ask to lock table t with share mode.  I am not really familiar with locking
for Derby. Could we need more concurrency control for StatementNode and RAMTransactionContext?
I am including rjone.out for reference.


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


Mime
View raw message