Hi, Jurgen and TheRaywell, Andrei has released h2-2.2.222 yesterday evening for public. I had a same error like You and now my code works OK without any error. So You can try 2.2.222 version and send the result to the appropriate email thread https://groups.google.com/g/h2-database/c/yCIcidC0piA. Regards, Stepan
Dne úterý 15. srpna 2023 v 17:46:57 UTC+2 uživatel Jürgen Pingel napsal: > 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/cbf955cf-1ac1-4f1b-8fd2-31643e588990n%40googlegroups.com.
