db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-5038) updatelocks test failing in tinderbox when background update statistics are enabled.
Date Mon, 14 Feb 2011 17:47:57 GMT
updatelocks test failing in tinderbox when background update statistics are enabled.
------------------------------------------------------------------------------------

                 Key: DERBY-5038
                 URL: https://issues.apache.org/jira/browse/DERBY-5038
             Project: Derby
          Issue Type: Bug
          Components: Test
    Affects Versions: 10.8.0.0
            Reporter: Mike Matrigali


updatelocks is failing consistently in tinderbox since checkin 1069598 for DERBY-4939: Enable
istat daemon and tests

http://dbtg.foundry.sun.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1070190-derbyall_diff.txt

********* Diff file derbyall/encryptionAll/storemats/storemats/updatelocks.diff
*** Start: updatelocks jdk1.6.0_18 storemats:storemats 2011-02-13 09:28:29 ***
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-13 09:28:40 ***


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

        

Mime
View raw message