Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A3B85CC85 for ; Fri, 1 Jun 2012 23:26:29 +0000 (UTC) Received: (qmail 782 invoked by uid 500); 1 Jun 2012 23:26:29 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 725 invoked by uid 500); 1 Jun 2012 23:26:29 -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 717 invoked by uid 99); 1 Jun 2012 23:26:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jun 2012 23:26:29 +0000 X-ASF-Spam-Status: No, hits=-5.0 required=5.0 tests=RCVD_IN_DNSWL_HI,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dag.wanvik@oracle.com designates 141.146.126.227 as permitted sender) Received: from [141.146.126.227] (HELO acsinet15.oracle.com) (141.146.126.227) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jun 2012 23:26:20 +0000 Received: from ucsinet22.oracle.com (ucsinet22.oracle.com [156.151.31.94]) by acsinet15.oracle.com (Sentrion-MTA-4.2.2/Sentrion-MTA-4.2.2) with ESMTP id q51NPuOc024742 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Fri, 1 Jun 2012 23:25:57 GMT Received: from acsmt358.oracle.com (acsmt358.oracle.com [141.146.40.158]) by ucsinet22.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id q51NPtTU011551 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Fri, 1 Jun 2012 23:25:56 GMT Received: from abhmt112.oracle.com (abhmt112.oracle.com [141.146.116.64]) by acsmt358.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id q51NPtQH020382 for ; Fri, 1 Jun 2012 18:25:55 -0500 Received: from localhost (/10.175.51.179) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Fri, 01 Jun 2012 16:25:55 -0700 From: dag.wanvik@oracle.com (Dag H. Wanvik) To: "Derby Discussion" Subject: Re: Derby Locks - best practices References: <619F13B2042F204E8E8E93D73870255809D07231@EXJSQUSDAG04.ad.jefco.com> Date: Sat, 02 Jun 2012 01:25:53 +0200 In-Reply-To: <619F13B2042F204E8E8E93D73870255809D07231@EXJSQUSDAG04.ad.jefco.com> (Pavel Bortnovskiy's message of "Fri, 1 Jun 2012 19:16:12 +0000") Message-ID: User-Agent: Gnus/5.110017 (No Gnus v0.17) Emacs/24.0.96 (usg-unix-v) MIME-Version: 1.0 Content-Type: text/plain X-Source-IP: ucsinet22.oracle.com [156.151.31.94] Pavel Bortnovskiy writes: > Besides best practices to avoid timeouts and deadlocks, I would like > to ask the following questions: > > 1) What's the default length of lock timeouts? According to http://db.apache.org/derby/docs/10.8/ref/rrefproper10607.html derby.locks.deadlockTimeout default is 20 seconds. This setting should be seen in conjunction with that of derby.locks.waitTimeout (usually deadlockTimeout is lower), cf advice here: http://db.apache.org/derby/docs/10.8/devguide/cdevconcepts16400.html