db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4211) 'derbyall/encryptionAll/storemats.fail:store/updatelocksJDBC30.sql' fails with unexpected locks
Date Fri, 11 Feb 2011 18:24:57 GMT

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

Mamta A. Satoor commented on DERBY-4211:
----------------------------------------

Saw the failure on tinderbox with Sun's jdk 1.6 on trunk at http://dbtg.foundry.sun.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1069761-derbyall_diff.txt
********* Diff file derbyall/storeall/storemats/storemats/updatelocksJDBC30.diff
*** Start: updatelocksJDBC30 jdk1.6.0_18 storemats:storemats 2011-02-11 14:02:48 ***
4983,4992d4982
< APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
< ij> next scan_cursor;
< A          |B          |C                                                           
                                                                   
< --------------------------------------------------------------------------------------------------------------------------------------------------------
< 3          |-30        |-three                                                      
                                                                   
< ij> update a set b=30,c='three' where current of scan_cursor;
< 1 row inserted/updated/deleted
< ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
< USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
< ---------------------------------------------------------------------------
4993a4984,4993
> ij> next scan_cursor;
> A          |B          |C                                                           
                                                                   
> --------------------------------------------------------------------------------------------------------------------------------------------------------
> 3          |-30        |-three                                                      
                                                                   
> ij> update a set b=30,c='three' where current of scan_cursor;
> 1 row inserted/updated/deleted
> ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
> USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
> ---------------------------------------------------------------------------
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
5003 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
5003a5003
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
5010 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
5010a5010
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
Test Failed.
*** End:   updatelocksJDBC30 jdk1.6.0_18 storemats:storemats 2011-02-11 14:02:55 ***
********* Diff file derbyall/derbynetclientmats/DerbyNetClient/encodingTests/TestEnc.diff
*** Start: TestEnc jdk1.6.0_18 DerbyNetClient derbynetclientmats:encodingTests 2011-02-11
14:08:04 ***
derbyTesting.encoding can only be used with jdk15, skipping test
*** End:   TestEnc jdk1.6.0_18 DerbyNetClient derbynetclientmats:encodingTests 2011-02-11
14:08:04 ***
********* Diff file derbyall/encryptionAll/storemats/storemats/updatelocksJDBC30.diff
*** Start: updatelocksJDBC30 jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:15 ***
2504,2513d2503
< APP     |UserTran|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
< ij> next scan_cursor;
< A          |B          |C                                                           
                                                                   
< --------------------------------------------------------------------------------------------------------------------------------------------------------
< 3          |-30        |-three                                                      
                                                                   
< ij> update a set b=30,c='three' where current of scan_cursor;
< 1 row inserted/updated/deleted
< ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
< USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
< ---------------------------------------------------------------------------
2514a2505,2514
> ij> next scan_cursor;
> A          |B          |C                                                           
                                                                   
> --------------------------------------------------------------------------------------------------------------------------------------------------------
> 3          |-30        |-three                                                      
                                                                   
> ij> update a set b=30,c='three' where current of scan_cursor;
> 1 row inserted/updated/deleted
> ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
> USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
> ---------------------------------------------------------------------------
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
2524 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
2524a2524
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
2531 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
2531a2531
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
Test Failed.
*** End:   updatelocksJDBC30 jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:23 ***


> '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
>             Fix For: 10.5.3.1, 10.6.2.1, 10.7.1.1
>
>
> 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message