Hello, I have also this problem using the same H2 version - get a corrupted database. Do you have any solution or fix? Because without any fix that version is unusable for me.
Thanks, Jürgen TheRaywell schrieb am Donnerstag, 20. Juli 2023 um 03:36:29 UTC+2: > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/809493cb-932d-4632-b1e5-239485e0f7f6n%40googlegroups.com.
