Re: [h2] H2 Database Engine: New version released

[Andreas Reichel]

On Wed, 2023-08-23 at 08:09 -0400, Andrei Tokar wrote:
> This is a patch release, and AFAIK there are no incompatibilities
> with
> on-disk format of v.2.2.220, so hopefully it can be used as drop in
> replacement for 2.2.220 (and only 2.2.220!).


Thank you very much.
Just in case: We have amended H2MigrationTool for support of H2 2.2.222
already.

http://h2migrationtool.manticore-projects.com/

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/e8a3da3143988c31b65accf1ada090f57150d457.camel%40manticore-projects.com.

[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello Everybody,

A new version 2.2.222 of H2 is available at http://www.h2database.com
(you may have to click 'Refresh').

This is a patch release, and AFAIK there are no incompatibilities with
on-disk format of v.2.2.220, so hopefully it can be used as drop in
replacement for 2.2.220 (and only 2.2.220!). 

It will be available in Maven repository shortly.

For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html

P.S. If you reply to this message please use a different subject.

Have fun,
Andrei Tokar

-- 
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/a474a189bdf421aeb5807360e8e483a31ccb2acc.camel%40gmail.com.

Re: [h2] H2 Database Engine: New version released

[t603]

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]" [5-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]" [5-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/cbf955cf-1ac1-4f1b-8fd2-31643e588990n%40googlegroups.com.

[h2] Re: 2.2.220: File corrupted in chunk 17, expected page length 4..1536, got -1711276031 [2.2.220/6]

[t603]

Hi, Andrei, I run my code just now with h2-2.2.222.jar released yesterday 
evening for public and I can confirm, that it works OK without any error. 
Thank You again, Stepan 

Dne středa 23. srpna 2023 v 0:50:51 UTC+2 uživatel Andrei Tokar napsal:

> Thanks a lot t603 for a quick turnaround. Since it fixes your issue, test 
> case is not really needed, Now we are good to issue a new release.
> -- Andrei
>
> On Tuesday, August 22, 2023 at 2:01:53 PM UTC-4 t603 wrote:
>
>> Hi, Andrei, 
>> You are great, *You have fixed the problem*! I have built the 
>> h2-2.2.229-SNAPSHOT.jar with Adoptium OpenJDK 17 (the same Java, which I 
>> use for my app), run my code twice and it works both times without error!
>> Unfortunately I can not share data, because all data are taken runtime 
>> from external linked tables mostly to another databases and from CSV and 
>> JSON a XML datasources. 
>> Thank You very much, Stepan 
>>
>> Dne úterý 22. srpna 2023 v 16:36:52 UTC+2 uživatel Andrei Tokar napsal:
>>
>>> Hi t603,
>>> I think I have a fix for corruption problem, but since I can not 
>>> reproduce it myself, and you are claiming that you have a reproducible test 
>>> case, it will be extremely helpful if you can build H2 from master branch, 
>>> as outlined here  and 
>>> confirm the fix (or not), so we can accordingly plan the patch or keep 
>>> digging.
>>> If you, on the other hand, can share your test case with mangled data 
>>> (if sensitive), that would be even better, especially if my fix is not good 
>>> enough.
>>> --
>>> Thank You,
>>> Andrei Tokar
>>>
>>

-- 
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/7e352aea-58fa-4f03-ad10-8a7a82982321n%40googlegroups.com.