Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 95419 invoked from network); 5 Jun 2007 21:55:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Jun 2007 21:55:57 -0000 Received: (qmail 84543 invoked by uid 500); 5 Jun 2007 21:55:59 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 84521 invoked by uid 500); 5 Jun 2007 21:55:58 -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 84510 invoked by uid 99); 5 Jun 2007 21:55:58 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2007 14:55:58 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [64.224.219.80] (HELO mail6.atl.registeredsite.com) (64.224.219.80) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2007 14:55:53 -0700 Received: from mail2.referentia.com (mail2.referentia.com [216.122.129.145]) by mail6.atl.registeredsite.com (8.12.11.20060308/8.12.11) with ESMTP id l55LtVWH031406 for ; Tue, 5 Jun 2007 17:55:31 -0400 Received: from EETHKOTH (corp1.referentia.com [64.128.15.194]) by mail2.referentia.com (8.11.6/8.11.0) with ESMTP id l55LtUD78137 for ; Tue, 5 Jun 2007 11:55:30 -1000 (HST) (envelope-from jnewsham@referentia.com) From: "Jim Newsham" To: "'Derby Discussion'" Subject: deadlock while preparing statement Date: Tue, 5 Jun 2007 11:55:21 -1000 Message-ID: <005501c7a7bc$3a28c870$8700a8c0@referentia.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0056_01C7A768.687CB870" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcenvDaZuttfLhP9SmyP0BbRRxnNvA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_0056_01C7A768.687CB870 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Some of our developers are reporting deadlock in our application which seemed to be related to derby. Sure enough, it just happened to me. It turns out that calling Connection.prepareStatement() simultaneously from two separate threads (and using two different connection objects) is resulting in deadlock. This is a pretty severe problem, as it brings our application to a halt (or prevents it from shutting down). I found and commented on the following JIRA entry which is identical to what we are seeing. Is this being actively looked at? https://issues.apache.org/jira/browse/DERBY-2689 Regards, Jim Newsham ------=_NextPart_000_0056_01C7A768.687CB870 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

Some of our developers are reporting deadlock in our application which seemed to be related to derby.  Sure enough, it = just happened to me.  It turns out that calling Connection.prepareStatement() = simultaneously from two separate threads (and using two different connection objects) is = resulting in deadlock.  This is a pretty severe problem, as it brings our = application to a halt (or prevents it from shutting down).  =

 

I found and commented on the following JIRA entry = which is identical to what we are seeing.  Is this being actively looked = at?

 

https://issues.= apache.org/jira/browse/DERBY-2689

 

Regards,

Jim Newsham

------=_NextPart_000_0056_01C7A768.687CB870--