Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AADAB7E4D for ; Tue, 20 Sep 2011 18:46:42 +0000 (UTC) Received: (qmail 96824 invoked by uid 500); 20 Sep 2011 18:46:42 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 96802 invoked by uid 500); 20 Sep 2011 18:46:42 -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 96795 invoked by uid 99); 20 Sep 2011 18:46:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Sep 2011 18:46:42 +0000 X-ASF-Spam-Status: No, hits=-1.6 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [32.97.182.137] (HELO e7.ny.us.ibm.com) (32.97.182.137) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Sep 2011 18:46:33 +0000 Received: from d01relay01.pok.ibm.com (d01relay01.pok.ibm.com [9.56.227.233]) by e7.ny.us.ibm.com (8.14.4/8.13.1) with ESMTP id p8KHPP4H026872 for ; Tue, 20 Sep 2011 13:25:25 -0400 Received: from d01av02.pok.ibm.com (d01av02.pok.ibm.com [9.56.224.216]) by d01relay01.pok.ibm.com (8.13.8/8.13.8/NCO v10.0) with ESMTP id p8KIkA13175990 for ; Tue, 20 Sep 2011 14:46:10 -0400 Received: from d01av02.pok.ibm.com (loopback [127.0.0.1]) by d01av02.pok.ibm.com (8.14.4/8.13.1/NCO v10.0 AVout) with ESMTP id p8KIk8Ki027071 for ; Tue, 20 Sep 2011 15:46:08 -0300 Received: from [9.65.8.101] (sig-9-65-8-101.mts.ibm.com [9.65.8.101]) by d01av02.pok.ibm.com (8.14.4/8.13.1/NCO v10.0 AVin) with ESMTP id p8KIk72I027016 for ; Tue, 20 Sep 2011 15:46:07 -0300 Message-ID: <4E78DF67.2020608@sbcglobal.net> Date: Tue, 20 Sep 2011 11:45:59 -0700 From: Kathey Marsden User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: [VOTE] 10.8.2.1 release References: <32462975.post@talk.nabble.com> <4E78CB3F.7040109@sbcglobal.net> <4E78DAEB.6090504@oracle.com> In-Reply-To: <4E78DAEB.6090504@oracle.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 9/20/2011 11:26 AM, Rick Hillegas wrote: > I have linked DERBY-5423 to DERBY-4437. This error can now appear as a > result of the work done on DERBY-4437. It is possible that the error > will go away if the default preallocation range for > sequences/identities is boosted from 20 values to something bigger > like 200. You might try re-running the test with this property setting: > > derby.language.sequence.preallocator=200 > > If that does fix the problem, then we may want to consider whether 20 > is too low a default for this setting. > Thank you Rick. Once an appropriate default is determined, I think it would be good to update the release note to include a specific reference to this error and actions to avoid it if it occurs on upgrade. Sadly, I think it is something that users are not likely to hit until they are in a heavily loaded production environment. Is there a way to acheive the prior behavior where there is not a risk of the error occurring?