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] Issue Comment Edited: (DERBY-4291) Intermittent failure in 'store/updatelocks.sql' on Windows Vista
Date Fri, 11 Feb 2011 18:22:57 GMT

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

Mamta A. Satoor edited comment on DERBY-4291 at 2/11/11 6:21 PM:
-----------------------------------------------------------------

Saw following on trunk at revision 1069761 with Sun's jvm 1.6.0_18 on tinderbox http://dbtg.foundry.sun.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1069761-derbyall_diff.txt

*** Start: updatelocks jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:23 ***
2847,2856d2846
< 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  
< ---------------------------------------------------------------------------
2857a2848,2857
> 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  
2867 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
2867a2867
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
2874 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
2874a2874
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
14688,14697d14687
< 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  
< ---------------------------------------------------------------------------
14698a14689,14698
> 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  
14708 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
14708a14708
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
14716 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
14716a14716
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
Test Failed.
*** End:   updatelocks jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:35 ***
------------------------------------------------------


      was (Author: mamtas):
    Saw following on trunk at revision 1069761 with Sun's jvm 1.6.0_18 on tinderbox

*** Start: updatelocks jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:23 ***
2847,2856d2846
< 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  
< ---------------------------------------------------------------------------
2857a2848,2857
> 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  
2867 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
2867a2867
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
2874 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
2874a2874
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
14688,14697d14687
< 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  
< ---------------------------------------------------------------------------
14698a14689,14698
> 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  
14708 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
14708a14708
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
14716 del
< APP     |UserTran|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
14716a14716
> APP     |UserTran|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
Test Failed.
*** End:   updatelocks jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:35 ***
------------------------------------------------------

  
> Intermittent failure in 'store/updatelocks.sql' on Windows Vista
> ----------------------------------------------------------------
>
>                 Key: DERBY-4291
>                 URL: https://issues.apache.org/jira/browse/DERBY-4291
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.6.1.0
>         Environment: OS:
> Microsoft© Windows VistaT Ultimate - 6.0.6002 Service Pack 2
> WindowsNT 0 6
> 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 32-bit)
>            Reporter: Ole Solberg
>            Priority: Minor
>
> *** Start: updatelocks jdk1.6.0_06 storemats:storemats 2009-06-24 23:16:00 ***
> 23201 del
> < APP     |UserTran|ROW     |1   |X   |A           |(2,6)     |GRANT|ACTIVE  
> 23201a23201
> > APP     |UserTran|ROW     |2   |X   |A           |(2,6)     |GRANT|ACTIVE  
> Test Failed.
> *** End:   updatelocks jdk1.6.0_06 storemats:storemats 2009-06-24 23:16:27 ***
> See http://dbtg.thresher.com/derby/test/Daily/jvm1.6/testing/testlog/vista/788063-derbyall_diff.txt

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message