Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 54947 invoked from network); 22 Sep 2010 21:22:28 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Sep 2010 21:22:28 -0000 Received: (qmail 90701 invoked by uid 500); 22 Sep 2010 21:22:27 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 90651 invoked by uid 500); 22 Sep 2010 21:22:27 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 90644 invoked by uid 99); 22 Sep 2010 21:22:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Sep 2010 21:22:26 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of david.vancouvering@gmail.com designates 209.85.216.179 as permitted sender) Received: from [209.85.216.179] (HELO mail-qy0-f179.google.com) (209.85.216.179) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Sep 2010 21:22:22 +0000 Received: by qyk9 with SMTP id 9so1310730qyk.10 for ; Wed, 22 Sep 2010 14:22:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received:from:date :x-google-sender-auth:message-id:subject:to:content-type; bh=yID2J2ZhwefljrThuLHkO2ecdCN5FDirItyKoqpOLRY=; b=PFGdmZLsWsMrIIQ2L4fTG0xWxLEnwREvkBHCHh05HIY3V5J09LmmhCk19kaNJDomnk xCpjyZ+CbJi1/iSL7L9GW3i8yWJC10qozJRd3jgYVfHK6K1lmXUUK1JumQ1ebcb08ZII FIDUQGTwafRxrk1ppNs9tms2QpEFSNti7Ilpg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:from:date:x-google-sender-auth:message-id :subject:to:content-type; b=gkLBltu444mOgOhIRMyPGnnJP7LANbMfxARG3T/FyweDbipCeZLK0IiiZ/kDMzVeMI rcoWn1PuGtnTNVDfZoQNqAHtGnPc8zGsmPPZtJ8413JlaqqbReSQtSIEURelU21wOlKs p0MaOR2GbjbmayyWwz5oZLFj/bk9gSwXDWo9U= Received: by 10.224.54.140 with SMTP id q12mr553758qag.319.1285190521750; Wed, 22 Sep 2010 14:22:01 -0700 (PDT) MIME-Version: 1.0 Sender: david.vancouvering@gmail.com Received: by 10.229.50.213 with HTTP; Wed, 22 Sep 2010 14:21:41 -0700 (PDT) From: David Van Couvering Date: Wed, 22 Sep 2010 14:21:41 -0700 X-Google-Sender-Auth: wMDM97NVP4Ho0qZalHn0TQ-E190 Message-ID: Subject: Deadlock XID with no SQL? To: Derby Discussion Content-Type: multipart/alternative; boundary=0015175cb0588489530490dfbcfe --0015175cb0588489530490dfbcfe Content-Type: text/plain; charset=ISO-8859-1 I am getting the following deadlock? One of the locks does not have a user or SQL associated with it. What should I be looking for when a lock is described in this way? Lock : ROW, FILTERS_FOR_DELIVERY, (3,1960) Waiting XID : {271243, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHERE ITEMSET_ID = ? AND FILTER_INDEX = ? AND SERVER_ID = ? Granted XID : {271250, X} Lock : ROW, FILTERS_FOR_DELIVERY, (3,1990) Waiting XID : {271250, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHERE ITEMSET_ID = ? AND FILTER_INDEX = ? AND SERVER_ID = ? Granted XID : {271243, X} . The selected victim is XID : 271243. Thanks, David -- David W. Van Couvering http://www.linkedin.com/in/davidvc http://davidvancouvering.blogspot.com http://twitter.com/dcouvering --0015175cb0588489530490dfbcfe Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I am getting the following deadlock?=A0 One of the locks does not have a us= er or SQL associated with it.=A0 What should I be looking for when a lock i= s described in this way?

Lock : ROW, FILTERS_FOR_DELIVERY, (3,1960)<= br> =A0 Waiting XID : {271243, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHE= RE ITEMSET_ID =3D ? AND FILTER_INDEX =3D ? AND SERVER_ID =3D ?
=A0 Grant= ed XID : {271250, X}
Lock : ROW, FILTERS_FOR_DELIVERY, (3,1990)
=A0 = Waiting XID : {271250, X} , VONTU, DELETE FROM FILTERS_FOR_DELIVERY WHERE I= TEMSET_ID =3D ? AND FILTER_INDEX =3D ? AND SERVER_ID =3D ?
=A0 Granted XID : {271243, X}
. The selected victim is XID : 271243.
Thanks,

David

--
David W. Van Couverin= g

http://www.linkedin= .com/in/davidvc
http://davidvancouvering.= blogspot.com
http://twitte= r.com/dcouvering
--0015175cb0588489530490dfbcfe--