Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 72639 invoked from network); 11 Feb 2011 18:23:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Feb 2011 18:23:21 -0000 Received: (qmail 10918 invoked by uid 500); 11 Feb 2011 18:23:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 10829 invoked by uid 500); 11 Feb 2011 18:23:19 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 10808 invoked by uid 99); 11 Feb 2011 18:23:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Feb 2011 18:23:18 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Feb 2011 18:23:17 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 6F4021A0C1E for ; Fri, 11 Feb 2011 18:22:57 +0000 (UTC) Date: Fri, 11 Feb 2011 18:22:57 +0000 (UTC) From: "Mamta A. Satoor (JIRA)" To: derby-dev@db.apache.org Message-ID: <803299943.11116.1297448577436.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] Issue Comment Edited: (DERBY-4291) Intermittent failure in 'store/updatelocks.sql' on Windows Vista MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-4291?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1299= 3620#comment-12993620 ]=20 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 tinde= rbox http://dbtg.foundry.sun.com/derby/test/tinderbox_trunk16/jvm1.6/testin= g/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= =20 < ij> next scan_cursor; < A |B |C = = =20 < -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- < 3 |-30 |-three = = =20 < ij> update a set b=3D30,c=3D'three' where current of scan_cursor; < 1 row inserted/updated/deleted < ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 < -------------------------------------------------------------------------= -- 2857a2848,2857 > ij> next scan_cursor; > A |B |C = = =20 > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- > 3 |-30 |-three = = =20 > ij> update a set b=3D30,c=3D'three' where current of scan_cursor; > 1 row inserted/updated/deleted > ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; > USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 > -------------------------------------------------------------------------= -- > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 2867 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 2867a2867 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 2874 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 2874a2874 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 14688,14697d14687 < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE= =20 < ij> next scan_cursor; < A |B |C = = =20 < -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- < 3 |-30 |-three = = =20 < ij> update a set b=3D30,c=3D'three' where current of scan_cursor; < 1 row inserted/updated/deleted < ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 < -------------------------------------------------------------------------= -- 14698a14689,14698 > ij> next scan_cursor; > A |B |C = = =20 > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- > 3 |-30 |-three = = =20 > ij> update a set b=3D30,c=3D'three' where current of scan_cursor; > 1 row inserted/updated/deleted > ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; > USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 > -------------------------------------------------------------------------= -- > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 14708 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 14708a14708 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 14716 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 14716a14716 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 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 t= inderbox *** 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= =20 < ij> next scan_cursor; < A |B |C = = =20 < -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- < 3 |-30 |-three = = =20 < ij> update a set b=3D30,c=3D'three' where current of scan_cursor; < 1 row inserted/updated/deleted < ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 < -------------------------------------------------------------------------= -- 2857a2848,2857 > ij> next scan_cursor; > A |B |C = = =20 > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- > 3 |-30 |-three = = =20 > ij> update a set b=3D30,c=3D'three' where current of scan_cursor; > 1 row inserted/updated/deleted > ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; > USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 > -------------------------------------------------------------------------= -- > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 2867 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 2867a2867 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 2874 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 2874a2874 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 14688,14697d14687 < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE= =20 < ij> next scan_cursor; < A |B |C = = =20 < -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- < 3 |-30 |-three = = =20 < ij> update a set b=3D30,c=3D'three' where current of scan_cursor; < 1 row inserted/updated/deleted < ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 < -------------------------------------------------------------------------= -- 14698a14689,14698 > ij> next scan_cursor; > A |B |C = = =20 > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---- > 3 |-30 |-three = = =20 > ij> update a set b=3D30,c=3D'three' where current of scan_cursor; > 1 row inserted/updated/deleted > ij> select * from lock_table order by tabname, type desc, mode, cnt, lock= name; > USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS= =20 > -------------------------------------------------------------------------= -- > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 14708 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 14708a14708 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 14716 del < APP |UserTran|TABLE |2 |IX |A |Tablelock |GRANT|ACTIVE= =20 14716a14716 > APP |UserTran|TABLE |3 |IX |A |Tablelock |GRANT|ACTIVE= =20 Test Failed. *** End: updatelocks jdk1.6.0_18 storemats:storemats 2011-02-11 14:11:35 = *** ------------------------------------------------------ =20 > 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=C2=A9 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:0= 0 *** > 23201 del > < APP |UserTran|ROW |1 |X |A |(2,6) |GRANT|ACTI= VE =20 > 23201a23201 > > APP |UserTran|ROW |2 |X |A |(2,6) |GRANT|ACTI= VE =20 > Test Failed. > *** End: updatelocks jdk1.6.0_06 storemats:storemats 2009-06-24 23:16:2= 7 *** > See http://dbtg.thresher.com/derby/test/Daily/jvm1.6/testing/testlog/vist= a/788063-derbyall_diff.txt --=20 This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira