[
https://issues.apache.org/jira/browse/DERBY-5038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mike Matrigali resolved DERBY-5038.
-----------------------------------
Resolution: Fixed
Fix Version/s: 10.8.0.0
Assignee: Mike Matrigali
> 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
> Assignee: Mike Matrigali
> Fix For: 10.8.0.0
>
> Attachments: derby.log
>
>
> 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
