[
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
