db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4849) Re-compilation may cause duplicate entries in the XPLAIN table
Date Sat, 30 Oct 2010 10:16:20 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12926556#action_12926556

Knut Anders Hatlen commented on DERBY-4849:

The new test case failed because of a deadlock in one of the nightly tests: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.5/testing/testlog/sparc/1028816-suitesAll_diff.txt

Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and
waiters is:
Lock : ROW, SYSSTATISTICS, (11,622)
  Waiting XID : {292152, X} , APP, alter table "APP"."COUNTRIES" all update statistics 
  Granted XID : {292143, S} 
Lock : ROW, SYSSTATISTICS, (11,623)
  Waiting XID : {292143, S} , APP, SELECT country from countries WHERE region = 'Central America'
  Granted XID : {292152, X} 
. The selected victim is XID : 292152.

> Re-compilation may cause duplicate entries in the XPLAIN table
> --------------------------------------------------------------
>                 Key: DERBY-4849
>                 URL: https://issues.apache.org/jira/browse/DERBY-4849
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:,
>            Reporter: Kristian Waagan
>            Assignee: Kristian Waagan
>            Priority: Minor
>         Attachments: derby-4849-1a-narrow_fix.diff, derby-4849-2a-broad_fix.diff, derby-4849-2b-broad_fix_with_test.diff,
derby-4849-2b-broad_fix_with_test.stat, derby-4849-2c-broad_fix_with_test.diff, derby-4849-xplain_duplicate_stacktrace.txt
> If happening at the right moment, a re-compilation request may cause duplicate entries
in the XPLAIN statement tables.
> I have only confirmed this for the SYSXPLAIN_STATEMENTS table, and I do not know if the
other XPLAIN tables are affected.
> The error is highly intermittent, and so far I have only been able to trigger it when
testing the automatic index statistics update prototype.
> See the attached stack-trace for some more details.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message