You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <ji...@apache.org> on 2010/07/09 18:07:50 UTC

[jira] Updated: (DERBY-4211) 'derbyall/encryptionAll/storemats.fail:store/updatelocksJDBC30.sql' fails with unexpected locks

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

Mike Matrigali updated DERBY-4211:
----------------------------------


The row that shows up as extra locks is a committed deleted row.  I think the problem is that this row, which in this phase of the test is the only row on the page, is usually cleaned up by the background post commit thread.  Sometimes do to timing it sticks around for a few queries.  If it is there, then even though it is deleted the system needs to get locks on it.

> 'derbyall/encryptionAll/storemats.fail:store/updatelocksJDBC30.sql' fails with unexpected locks
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4211
>                 URL: https://issues.apache.org/jira/browse/DERBY-4211
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.6.1.0
>         Environment: OS:
> Solaris 10 5/08 s10x_u5wos_10 X86 64bits - SunOS 5.10 Generic_127128-11
> JVM:
> Sun Microsystems Inc.
> java version "1.6.0_06"
> Java(TM) SE Runtime Environment (build 1.6.0_06-b02)
> Java HotSpot(TM) Client VM (build 10.0-b22, mixed mode)
>            Reporter: Ole Solberg
>            Assignee: Mike Matrigali
>
> See http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/771180-derbyall_diff.txt
> ********* Diff file derbyall/encryptionAll/storemats/storemats/updatelocksJDBC30.diff
> *** Start: updatelocksJDBC30 jdk1.6.0_06 storemats:storemats 2009-05-04 11:56:42 ***
> 9184a9185
> > APP     |UserTran|ROW     |1   |U   |A           |(2,6)     |GRANT|ACTIVE  
> 9194a9196
> > APP     |UserTran|ROW     |1   |U   |A           |(2,6)     |GRANT|ACTIVE  
> 9205a9208
> > APP     |UserTran|ROW     |1   |U   |A           |(2,6)     |GRANT|ACTIVE  
> 9215a9219
> > APP     |UserTran|ROW     |1   |U   |A           |(2,6)     |GRANT|ACTIVE  
> 9224a9229
> > APP     |UserTran|ROW     |1   |U   |A           |(2,6)     |GRANT|ACTIVE  
> Test Failed.
> *** End:   updatelocksJDBC30 jdk1.6.0_06 storemats:storemats 2009-05-04 11:57:00 ***

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