H2 last release (220): after insert /delete command : In runtime, after a few inserts and deletions to the database version 2.2.220, our database was damaged, and we observe such a picture on several servers. Before that, we used version 2.1.214 for over 4 months without problem. The database version 220 was created from 0 and data was entered into it by sql commands. 2023-07-17 12:19:52 database: flush org.h2.message.DbException: General error: "org.h2.mvstore.MVStoreException: File corrupted in chunk 134, expected page length 4..768, got 200383807 [2.2.220/6]" [50000-220] at org.h2.message.DbException.get(DbException.java:212) at org.h2.message.DbException.convert(DbException.java:407) at org.h2.mvstore.db.Store.lambda$new$0(Store.java:122) at org.h2.mvstore.MVStore.handleException(MVStore.java:1547) at org.h2.mvstore.MVStore.panic(MVStore.java:371) at org.h2.mvstore.MVStore.tryExecuteUnderStoreLock(MVStore.java:940) at org.h2.mvstore.RandomAccessStore.doHousekeeping(RandomAccessStore.java:721) at org.h2.mvstore.FileStore.writeInBackground(FileStore.java:1838) at org.h2.mvstore.FileStore$BackgroundWriterThread.run(FileStore.java:2249) Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error: "org.h2.mvstore.MVStoreException: File corrupted in chunk 134, expected page length 4..768, got 200383807 [2.2.220/6]" [50000-220] at org.h2.message.DbException.getJdbcSQLException(DbException.java:566) at org.h2.message.DbException.getJdbcSQLException(DbException.java:489) ... 9 more Caused by: org.h2.mvstore.MVStoreException: File corrupted in chunk 134, expected page length 4..768, got 200383807 [2.2.220/6] at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:996) at org.h2.mvstore.Page.read(Page.java:590) at org.h2.mvstore.Page.read(Page.java:262) at org.h2.mvstore.FileStore.readPage(FileStore.java:1969) at org.h2.mvstore.MVStore.readPage(MVStore.java:1022) at org.h2.mvstore.MVMap.readPage(MVMap.java:632) at org.h2.mvstore.MVMap.rewritePage(MVMap.java:682) at org.h2.mvstore.FileStore.rewriteChunks(FileStore.java:1921) at org.h2.mvstore.FileStore.compactRewrite(FileStore.java:1897) at org.h2.mvstore.FileStore.rewriteChunks(FileStore.java:1858) at org.h2.mvstore.RandomAccessStore.lambda$doHousekeeping$4(RandomAccessStore.java:726) at org.h2.mvstore.MVStore.tryExecuteUnderStoreLock(MVStore.java:938) ... 3 more 2023-07-17 12:28:41 database: close
среда, 12 июля 2023 г. в 08:30:44 UTC+3, Andreas Reichel: > Greetings! > > On Tue, 2023-07-11 at 10:20 -0700, Vali Maties wrote: > > How do I upgrade it to be able to use the latest driver, as long as this > one seems to be no more warnings in it! > > > You could use the H2 Migration Tool > https://manticore-projects.com/H2MigrationTool/index.html > > Best regards > Andreas > > -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/2fad63eb-1048-464e-b05a-28b2939a0caen%40googlegroups.com.