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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/809493cb-932d-4632-b1e5-239485e0f7f6n%40googlegroups.com.
