Hello,

I recently updated our H2 to version 1.4.197. After the update we observed 
that sometimes out application cannot execute some of the SQL statement, 
terminating with the following error:

2018-08-19 16:26:25,969 INFO  - running processor 388

2018-08-19 16:26:54,713 ERROR - General error: 
"java.lang.IllegalStateException: Chunk 2408 not found [1.4.197/9]"; SQL 
statement:

org.h2.jdbc.JdbcSQLException: General error: 
"java.lang.IllegalStateException: Chunk 2408 not found [1.4.197/9]"; SQL 
statement:

UPDATE TABLE_NAME

       SET columnName = ....

            at 
org.h2.message.DbException.getJdbcSQLException(DbException.java:357)

            at org.h2.message.DbException.get(DbException.java:168)

            at org.h2.message.DbException.convert(DbException.java:307)

            at org.h2.command.Command.executeUpdate(Command.java:274)

            at 
org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:233)

            at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205)

            ... 4 more

Caused by: java.lang.IllegalStateException: Chunk 2408 not found [1.4.197/9]

            at 
org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:875)

            at org.h2.mvstore.MVStore.getChunk(MVStore.java:993)

            at org.h2.mvstore.MVStore.readPage(MVStore.java:2034)

            at org.h2.mvstore.MVMap.readPage(MVMap.java:547)

            at org.h2.mvstore.Page$NonLeaf.getChildPage(Page.java:943)

            at org.h2.mvstore.Cursor.hasNext(Cursor.java:52)

            at 
org.h2.mvstore.tx.TransactionMap$1.fetchNext(TransactionMap.java:567)

            at 
org.h2.mvstore.tx.TransactionMap$1.next(TransactionMap.java:609)

            at 
org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.next(MVSecondaryIndex.java:511)

            at org.h2.index.IndexCursor.next(IndexCursor.java:315)

            at org.h2.table.TableFilter.next(TableFilter.java:502)

            at org.h2.command.dml.Update.update(Update.java:112)

            at 
org.h2.command.CommandContainer.update(CommandContainer.java:102)

            at org.h2.command.Command.executeUpdate(Command.java:261)

            ... 6 more


Previously, we used a very old version of H2 (1.2) and we haven't 
experienced such problems. Can anyone help me and maybe explain in which 
circumstances does this error occur?


Thanks a lot in advance!


Greetings


Ivaylo Dobrikov


-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to