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

Reply via email to