Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 83247 invoked from network); 2 Feb 2007 05:20:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Feb 2007 05:20:03 -0000 Received: (qmail 35460 invoked by uid 500); 2 Feb 2007 05:20:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 35432 invoked by uid 500); 2 Feb 2007 05:20:08 -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 35421 invoked by uid 99); 2 Feb 2007 05:20:08 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Feb 2007 21:20:08 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of mcintyre.a@gmail.com designates 64.233.182.184 as permitted sender) Received: from [64.233.182.184] (HELO nf-out-0910.google.com) (64.233.182.184) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Feb 2007 21:19:59 -0800 Received: by nf-out-0910.google.com with SMTP id m19so1124281nfc for ; Thu, 01 Feb 2007 21:19:38 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ncgm2AhWvnQBGC2+9HquNImOu3s9Q245s+URhc3viwi4pLjp6x08aZ/phKA3af3q968UHbCh2qLqbsotKIhtr+0dXPw/ejOIGJtLKvM89TcbqqM9sgVjrTi6eyo9Ry6OuCnHdDFe/8PBoG9O/d8y3O2J35QcWOl0hKKPZX2HJP0= Received: by 10.49.93.13 with SMTP id v13mr5914497nfl.1170393578135; Thu, 01 Feb 2007 21:19:38 -0800 (PST) Received: by 10.49.75.19 with HTTP; Thu, 1 Feb 2007 21:19:38 -0800 (PST) Message-ID: <54ac72d70702012119x1bef6b92ndfe18649bf9b0039@mail.gmail.com> Date: Thu, 1 Feb 2007 21:19:38 -0800 From: "Andrew McIntyre" To: "Derby Discussion" Subject: Re: Exception ("nospc:nospc.U") thrown during batch updates In-Reply-To: <20070131165447.230840@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070131165447.230840@gmx.net> X-Virus-Checked: Checked by ClamAV on apache.org On 1/31/07, Hannes Grund wrote: > > I'm using Derby 10.2.1.6,Java 1.6 on some linux box, > during the execution of some batched prepared stamtenents, > the following exception was thrown: > > 2007-01-31 11:35:08.310 GMT > Thread[Thread] (XID =27813), (SESSIONID = 12), (DATABASE = /tmp/acc/2/DIR/var/home2/dir/db), (DRDAID = null), Failed Statement is: UPDATE Table SET a=?, b=?, c=?, d=?, e=?, f=? WHERE g=? > > ERROR nospc: nospc.U :at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown Source) > at > org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown > Source) Hi Hannes, At the very least you've discovered an exception that doesn't return a SQLState and without any text to explain the exception. In this case, I'm thinking it should probably be XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation. I'll file a bug for the exception's lack of content. Is this error consistently reproducible? If so, can you provide at the minimum the stack trace with the line numbers, and if possible, the complete list of columns in the table that was being updated along with their types and note which columns were being updated, and whether or not you were using the default values for page size and reserved space. If you can post a code snippet that reproduces the problem, that would be ideal. Thanks for the report, andrew