[DERBY-3947] Cannot insert 994 character long string into indexed column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.2.0
• Fix Version/s: 10.6.1.0
• Component/s: Store
• Urgency: Normal
• Issue & fix info: High Value Fix, Repro attached, Workaround attached
• Bug behavior facts: Seen in production
• Assignee: Bryan Pendleton
• Reporter: Knut Anders Hatlen
• Created: 13/Nov/08 13:57
• Updated: 02/Feb/10 09:54
• Resolved: 02/Dec/09 14:50

Description

Inserting a 994 character string into a varchar(1000) column with an index fails.

These steps

1. "create table t (x varchar(1000) primary key)"
2. "insert into t values " where ? holds a 994 character string

produce the following error:

ERROR XSCB6: 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.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:276)
at org.apache.derby.impl.store.access.btree.BTreeController.doIns(BTreeController.java:845)
at org.apache.derby.impl.store.access.btree.BTreeController.insert(BTreeController.java:1264)
at org.apache.derby.impl.store.access.btree.index.B2IController.insert(B2IController.java:210)
at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(IndexChanger.java:439)
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java:383)
at org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java:589)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(IndexSetChanger.java:268)
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java:453)
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1011)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:487)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:372)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)

The page size should be set sufficiently high at index creation time to hold columns with the specified maximum size.