Re: Index corruption bug

Thanks, Thomas. 

- Andrew

On Tuesday, April 3, 2012 2:28:32 PM UTC-5, Thomas Mueller wrote:
>
> Hi,
>
> Thanks a lot for the great test case! I can reproduce the problem, it
> will be fixed in the next release.
>
> Regards,
> Thomas
>
>
> On Sat, Mar 31, 2012 at 12:30 AM, Andrew <[EMAIL PROTECTED]> wrote:
> > We have recently encountered an issue where updateRow() fails due to an
> > apparently corrupt H2 index.  This particular index is on a varchar 
> column
> > that can contain relatively large (1000-2000 characters is not uncommon)
> > values.  We have reproduced this on both 1.3.163 and 1.3.165.  The issue
> > appears to depend entirely upon the nature of the data stored in the 
> indexed
> > table -- in one deployment with 3000+ rows we have not experienced any
> > corruption, while in another deployment with approximately 1300 rows a
> > corrupted index occurred.
> >
> > Depending upon the data inserted into the table, and the order in which 
> rows
> > are updated, we have seen two different exceptions:
> >
> > 1.
> > Exception in thread "main" org.h2.jdbc.JdbcSQLException: Row not found 
> when
> > trying to delete from index "PUBLIC.IDX: ( /* key:226 */ 226,
> > '{""operation"":""ADD"",""keys"":[""21216384"", ... ""21299408""]}',
> > FALSE)"; SQL statement:
> > UPDATE "PUBLIC"."T" SET "ID"=? ,"S"=? ,"B"=?  WHERE "ID"=? [90112-163]
> >     at 
> org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> >     at org.h2.message.DbException.get(DbException.java:169)
> >     at org.h2.message.DbException.get(DbException.java:146)
> >     at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:224)
> >     at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
> >     ...
> >     at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
> >     at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:241)
> >     at org.h2.table.RegularTable.removeRow(RegularTable.java:361)
> >     at org.h2.table.Table.updateRows(Table.java:430)
> >     at org.h2.command.dml.Update.update(Update.java:128)
> >     at org.h2.command.CommandContainer.update(CommandContainer.java:73)
> >     at org.h2.command.Command.executeUpdate(Command.java:226)
> >     at
> > 
> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
> >     at
> > 
> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
> >     at org.h2.result.UpdatableRow.updateRow(UpdatableRow.java:285)
> >     at org.h2.jdbc.JdbcResultSet.updateRow(JdbcResultSet.java:2763)
> >     at Reproducer.main(Reproducer.java:55)
> >
> > 2.
> > Exception in thread "main" org.h2.jdbc.JdbcSQLException: General error:
> > "java.lang.ArrayIndexOutOfBoundsException: 2"; SQL statement:
> > UPDATE "PUBLIC"."T" SET "ID"=? ,"S"=? ,"B"=?  WHERE "ID"=? [50000-163]
> >     at 
> org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
> >     at org.h2.message.DbException.get(DbException.java:158)
> >     at org.h2.message.DbException.convert(DbException.java:281)
> >     at org.h2.table.RegularTable.removeRow(RegularTable.java:379)
> >     at org.h2.table.Table.updateRows(Table.java:430)
> >     at org.h2.command.dml.Update.update(Update.java:128)
> >     at org.h2.command.CommandContainer.update(CommandContainer.java:73)
> >     at org.h2.command.Command.executeUpdate(Command.java:226)
> >     at
> > 
> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
> >     at
> > 
> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
> >     at org.h2.result.UpdatableRow.updateRow(UpdatableRow.java:285)
> >     at org.h2.jdbc.JdbcResultSet.updateRow(JdbcResultSet.java:2763)
> >     at Reproducer.main(Reproducer.java:54)
> > Caused by: java.lang.ArrayIndexOutOfBoundsException: 2
> >     at org.h2.index.PageBtree.getRow(PageBtree.java:172)
> >     at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:222)
> >     at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
> >     ...
> >     at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
> >     at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:241)
> >     at org.h2.table.RegularTable.removeRow(RegularTable.java:361)
> >     ... 9 more
> >
> > I've attached a zip file containing the Java code for a standalone, 
> minimal
> > reproducer application along with two data files, one for each type of
> > exception seen.  I suspect some sort of unfortunate hash collision could 
> be
> > happening.  Please let me know if any additional information is needed to
> > track this issue down.
> >
> > thanks,
> > Andrew Olson
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> > "H2 Database" group.
> > To view this discussion on the web visit
> > https://groups.google.com/d/msg/h2-database/-/GIpAUvXRdPkJ.
> > To post to this group, send email to [EMAIL PROTECTED]
> > To unsubscribe from this group, send email to
> > [EMAIL PROTECTED]
> > For more options, visit this group at
> > http://groups.google.com/group/h2-database?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/KX9S-R_QwjoJ.
To post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.