Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Thu, 13 Nov 2008 14:28:53 +0100
From: Kristian Waagan <Kristian.Waagan@Sun.COM>
Subject: Re: btree overflow during insert
In-reply-to: <491C1C63.1010801@sun.com>
Sender: Kristian.Waagan@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <491C2B95.5000708@Sun.COM>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <491AE134.7090806@sun.com> <491C1C63.1010801@sun.com>
User-Agent: Thunderbird 2.0.0.6 (X11/20071119)

Alan Burlison wrote:
> This is an important issue for us, and is a potential risk to us 
> deploying on Derby.  Should I raise a bug?  I've looked at the source 
> where this error is coming from, and it's scattered with FIXME-type 
> comments that suggests it's a known problem.

Hi Alan,

I don't remember this issue coming up before.
If you can reproduce this, and maybe devote some time writing a repro, I 
would just log a bug right away.
If not, I would suggest you wait for some more days in hope of a person 
having a deeper knowledge about this issue pitching in.

FYI, issues/bug are logged at https://issues.apache.org/jira/browse/DERBY


regards,
-- 
Kristian

>
> Thanks,
>
>> We are doing inserts with Derby 10.4.2.0 into a table that has an 
>> index on it, and during the insert we get the following errors:
>>
>> *** Appending local Error for batch element #84: Limitation: Record 
>> of a btree secondary index 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.***
>> *** Next Exception java.sql.SQLException: Error for batch element 
>> #155: Limitation: Record of a btree secondary index 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.***
>> Appending nestedError for batch element #84: Limitation: Record of a 
>> btree secondary index 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.
>>
>> We've tried removing the index and re-adding it after the inserts, 
>> but the result is the same.  To stop this happening we have to up the 
>> derby.storage.pageSize parameter to 16k, which is too big for what is 
>> effectively an OLTP database, and the documentation for 
>> derby.storage.pageReservedSpace says that it only applies to tables, 
>> bot indexes.
>>
>> Is this a bug, and if not, what should we do to avoid it, other than 
>> increasing the DB page size to 16K?
>