Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 31967 invoked from network); 27 Sep 2006 12:32:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 27 Sep 2006 12:32:09 -0000 Received: (qmail 77150 invoked by uid 500); 27 Sep 2006 12:32:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 76931 invoked by uid 500); 27 Sep 2006 12:32:08 -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 76922 invoked by uid 99); 27 Sep 2006 12:32:08 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Sep 2006 05:32:08 -0700 Authentication-Results: idunn.apache.osuosl.org header.from=m.v.lunteren@gmail.com; domainkeys=good Authentication-Results: idunn.apache.osuosl.org smtp.mail=m.v.lunteren@gmail.com; spf=pass X-ASF-Spam-Status: No, hits=0.5 required=5.0 tests=DNS_FROM_RFC_ABUSE Received-SPF: pass (idunn.apache.osuosl.org: domain gmail.com designates 66.249.82.228 as permitted sender) DomainKey-Status: good X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 Received: from [66.249.82.228] ([66.249.82.228:32838] helo=wx-out-0506.google.com) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id D4/21-25968-44F6A154 for ; Wed, 27 Sep 2006 05:32:05 -0700 Received: by wx-out-0506.google.com with SMTP id i27so190397wxd for ; Wed, 27 Sep 2006 05:32:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ehaXXVHB+cMDA2B4OgTrT3PJLSv5r52p3GriZnzWvw4beCHnF/5s/9uFxPgc2ASAnTwDWfEV31CeKswEodpQBV5Oa71recZOuhiKFBImX8/96hC5l2Q4R0N0VU1+dI97SQR88dlu54k86A0qsuQwsd7U7SDSfNRCTLYSxX2yCHE= Received: by 10.90.68.15 with SMTP id q15mr117186aga; Wed, 27 Sep 2006 05:32:01 -0700 (PDT) Received: by 10.90.93.11 with HTTP; Wed, 27 Sep 2006 05:32:01 -0700 (PDT) Message-ID: Date: Wed, 27 Sep 2006 05:32:01 -0700 From: "Myrna van Lunteren" To: derby-dev@db.apache.org Subject: Re: q re XA transactions and test checkDataSource In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <58ed70f50609250943o4d8c294dldf5d657e89d5a6b@mail.gmail.com> X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 9/26/06, Mamta Satoor wrote: > Hi Myrna, > > I spent some time on this and found that the global transaction started on > line 471 in checkDataSource.java ends up having locks on table ru when it > does select from ru. > > Those locks are not getting released because the global transaction is never > finished with a commit/rollback. You can release these locks by committing > the global transaction after line 531, using xar2.commit(xid, true); > > The drop table after the global transaction commit should work fine. I had > following after the global transaction commit and didn't get any locking > errors for it. > sruState.executeUpdate("drop table ru"); > > Hope this helps, > Mamta > Hi, Mamta, that helped, thank you... I have a follow-up problem, though... And this is only with DerbyNetClient (not embedded). If I do as mamta suggested - i.e. sruState.executeUpdate("drop table ru"); I see the test PASS, however, in the DerbyNetClient/checkDataSource/derby.log I see a failed select pop up because the table does not exist. So something must still be trying to select. Or one of the statements is being deferred? It seems to only get executed when the test is practically done. Any suggestions on how to tell which statement that is? (I looked at it some more but I can't see it). Or tell me how I could find out... Thx, Myrna