Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 52081 invoked from network); 17 Sep 2007 20:59:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Sep 2007 20:59:50 -0000 Received: (qmail 32168 invoked by uid 500); 17 Sep 2007 20:59:41 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 32145 invoked by uid 500); 17 Sep 2007 20:59:41 -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 32134 invoked by uid 99); 17 Sep 2007 20:59:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Sep 2007 13:59:41 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of k.huwig@iku-ag.de designates 212.88.142.131 as permitted sender) Received: from [212.88.142.131] (HELO sponts.iku-ag.de) (212.88.142.131) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Sep 2007 20:59:39 +0000 Received: from macwalk (80.185.251.122 [80.185.251.122]) by sponts.iku-ag.de (SPONTS v7.2.2) with ESMTP id 111515447F4D-0 for ; Mon, 17 Sep 2007 22:59:13 +0200 From: Kurt Huwig Organization: iKu Systemhaus AG To: "Derby Discussion" Subject: SELECT + INSERT deadlock Date: Mon, 17 Sep 2007 22:59:10 +0200 User-Agent: KMail/1.9.6 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200709172259.11104.k.huwig@iku-ag.de> X-SPONTS-Version: 7.2.2 X-Virus-Checked: Checked by ClamAV on apache.org Hi there, can someone with knowledge of the index-split and locking code have a look at http://issues.apache.org/jira/browse/DERBY-2991 It contains a reproducing example that deadlocks Derby with simple INSERT and SELECT statements due to a race condition in the b-tree split. If someone points me in the right direction, I could start looking. Greetings, Kurt