[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello Everybody,

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

This is a patch release, and there are no incompatibilities with
on-disk format of v.2.2.222, so it can be used as drop in
replacement for 2.2.222. 

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

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

[Andreas Reichel]

Greetings!

I have run your test through all H2 versions and have not been able to
see any material performance deviation:

INFO: 1.3.176: 101681 ms
INFO: 1.4.196: 104554 ms
INFO: 1.4.197: 103474 ms
INFO: 1.4.198: 101421 ms
INFO: 1.4.199: 99655 ms
INFO: 1.4.200: 100125 ms
INFO: 2.0.201: 100645 ms
INFO: 2.0.202: 101761 ms
INFO: 2.0.204: 101122 ms
INFO: 2.0.206: 100877 ms
INFO: 2.1.210: 100627 ms
INFO: 2.1.212: 99316 ms
INFO: 2.1.214: 98967 ms
INFO: 2.2.220: 98540 ms
INFO: 2.2.222: 103886 ms
INFO: 2.2.229: 103005 ms

Those are very rough estimates based
on System.currentTimeMillis() without engaging the JMH benachmarking
tool.
I am still working on a generic Performance Test Framework, which can
read simply Test Case Scripts like the one attached.

In the meantime, please elaborate on your concern since I can't really
confirm it so far.

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/0b297f12b1eb881db8d30910d60742c79dec69cd.camel%40manticore-projects.com.
def String[] sqlStr = [
"CREATE TABLE IF NOT EXISTS A (number VARCHAR(128) not NULL, intent INT not NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL, PRIMARY KEY (number,intent,objID,objType));",
"CREATE INDEX IF NOT EXISTS A_IDX ON A(objType,objID,intent);",
"CREATE INDEX IF NOT EXISTS A_type_IDX ON A (objType);",
"DROP TABLE IF EXISTS B; ",
"CREATE TABLE IF NOT EXISTS B (number VARCHAR(128) not NULL, intent INT not NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL, PRIMARY KEY (number,intent,objID,objType));",
"CREATE INDEX IF NOT EXISTS B_IDX ON B(objType,objID,intent);",
"DELETE FROM A T WHERE EXISTS (SELECT NULL from A S WHERE T.objID=S.objID AND T.objType=S.objType AND T.intent=S.intent AND T.number<>S.number);",
"MERGE INTO A T USING (SELECT * FROM B) AS S ON T.objID=S.objID AND T.objType=S.objType AND T.intent=S.intent AND T.number=S.number WHEN NOT MATCHED THEN INSERT (objID, objType, number, intent) VALUES (S.objID, S.objType, S.number, S.intent);",
"DROP TABLE B CASCADE"
]

statement.execute(sqlStr[0]);
statement.execute(sqlStr[1]);
statement.execute(sqlStr[2]);

for (int loop = 0, number = 0; loop < 300; ++loop) {
statement.execute(sqlStr[3]);
statement.execute(sqlStr[4]);
statement.execute(sqlStr[5]);

for (int i = 0; i < 100; ++i) {
++number;
statement.execute("MERGE INTO B (number,intent,objID,objType) VALUES ('"
+ number
+ "',1, '"
+ number
+ "', 1);");
}
statement.execute(sqlStr[6]);
statement.execute(sqlStr[7]);
statement.execute(sqlStr[8]);

logger.info "loop = $loop"
}

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

[Noel Grandin]

On 8/29/2023 1:33 PM, Andreas Reichel wrote:

if not, would you like to accept such a basic test performance test suite?



Sure, sounds like a useful tool.

--
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/dc08123e-633e-baa9-860a-d2aacd8cdb3e%40gmail.com.

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

[Andreas Reichel]

H2 Team,

do you have any facility in place for running such performance tests
across various versions of H2 and comparing the outcome?
Something like:

1) load driver
2) run various test scripts 
3) write performance measures for this driver version as per script
4) unload driver

and repeat over all provided drivers.
if not, would you like to accept such a basic test performance test
suite?

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

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

[Andreas Reichel]

Greetings Juergen.

Unfortunately I can't reproduce your concern after implementing your
test in the quickest and dirtiest way, with lots of overhead.
It ran through in 1 minute and I did not see any slowdown while
iterating:

> Task :ETLBox:H2PerformanceTest.main()
Aug 29, 2023 6:13:20 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 0
Aug 29, 2023 6:13:20 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 1
Aug 29, 2023 6:13:20 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 2

Aug 29, 2023 6:14:07 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 296
Aug 29, 2023 6:14:07 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 297
Aug 29, 2023 6:14:07 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 298
Aug 29, 2023 6:14:08 PM com.manticore.etl.custom.H2PerformanceTest main
INFO: loop = 299

BUILD SUCCESSFUL in 1m 13s

What exactly means "after some seconds" vs. "after some minutes"?
Can you elaborate on the details please?

Best regards
Andreas



On Tue, 2023-08-29 at 03:53 -0700, Jürgen Pingel wrote:
> Thanks for the fix version 2.2.222.
> Don't know if it will work for me, because I run with that revision
> into a performance problem.
> One of my unit tests runs now extremely long and it seems that much
> memory get allocated.
> Can't send you the complete code but I isolate it to the SQL
> statements and looks like: 
> 
> CREATE TABLE IF NOT EXISTS A (number VARCHAR(128) not NULL, intent
> INT not NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL,
> PRIMARY KEY (number,intent,objID,objType)); 
> CREATE INDEX IF NOT EXISTS A_IDX ON A(objType,objID,intent);
> CREATE INDEX IF NOT EXISTS A_type_IDX ON A (objType);
> 
> for (int loop = 0, number = 0; loop < 300; ++loop){
>   DROP TABLE IF EXISTS B; 
>   CREATE TABLE IF NOT EXISTS B (number VARCHAR(128) not NULL, intent
> INT not NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL,
> PRIMARY KEY (number,intent,objID,objType)); 
>   CREATE INDEX IF NOT EXISTS B_IDX ON B(objType,objID,intent);
> 
>   for (int i = 0; i < 100; ++i) { 
>     ++number;
>     MERGE INTO B (number,intent,objID,objType) VALUES
> (Integer.toString(number),1, Integer.toString(number), 1) 
>   }
>   
>   DELETE FROM A T WHERE EXISTS (SELECT NULL from A S WHERE
> T.objID=S.objID AND T.objType=S.objType AND T.intent=S.intent AND
> T.number<>S.number)
>   MERGE INTO A T USING (SELECT * FROM B) AS S ON T.objID=S.objID AND
> T.objType=S.objType AND T.intent=S.intent AND T.number=S.number WHEN
> NOT MATCHED THEN INSERT (objID, objType, number, intent) VALUES
> (S.objID, S.objType, S.number, S.intent);
>   DROP TABLE B CASCADE
> }
> 
> If run with the previous versions 1.4, 2.1 and 2.2.220 it's finished
> after some seconds.
> With the 2.2.222 it takes longer with each loop; don't finish after
> some minutes.
> 
> Please take a look; thanks.
> 
> Thanks,
>   Jürgen
> Andreas Reichel schrieb am Mittwoch, 23. August 2023 um 14:12:42
> UTC+2:
> > 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/a9dde386-ec94-4beb-b13a-a2913f6e4311n%40googlegroups.com
> .

-- 
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/a7aba634cf7821a96bb648b63281a7043d3a7556.camel%40manticore-projects.com.
package com.manticore.etl.custom;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

public class H2PerformanceTest {
private final static Logger LOGGER = Logger.getLogger(H2PerformanceTest.class.getName());

public static void main(String[] args) throws ClassNotFoundException {
String[] sqlStr = {
"CREATE TABLE IF NOT EXISTS A (number VARCHAR(128) not NULL, intent INT not NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL, PRIMARY KEY (number,intent,objID,objType));",
"CREATE INDEX IF NOT EXISTS A_IDX ON A(objType,objID,intent);",

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

[Jürgen Pingel]

Thanks for the fix version 2.2.222.
Don't know if it will work for me, because I run with that revision into a 
performance problem.
One of my unit tests runs now extremely long and it seems that much memory 
get allocated.
Can't send you the complete code but I isolate it to the SQL statements and 
looks like: 

CREATE TABLE IF NOT EXISTS A (number VARCHAR(128) not NULL, intent INT not 
NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL, PRIMARY KEY 
(number,intent,objID,objType)); 
CREATE INDEX IF NOT EXISTS A_IDX ON A(objType,objID,intent);
CREATE INDEX IF NOT EXISTS A_type_IDX ON A (objType);

for (int loop = 0, number = 0; loop < 300; ++loop){
  DROP TABLE IF EXISTS B; 
  CREATE TABLE IF NOT EXISTS B (number VARCHAR(128) not NULL, intent INT 
not NULL, objID VARCHAR(30) not NULL, objType SMALLINT  not NULL, PRIMARY 
KEY (number,intent,objID,objType)); 
  CREATE INDEX IF NOT EXISTS B_IDX ON B(objType,objID,intent);

  for (int i = 0; i < 100; ++i) { 
++number;
MERGE INTO B (number,intent,objID,objType) VALUES 
(Integer.toString(number),1, Integer.toString(number), 1) 
  }
  
  DELETE FROM A T WHERE EXISTS (SELECT NULL from A S WHERE T.objID=S.objID 
AND T.objType=S.objType AND T.intent=S.intent AND T.number<>S.number)
  MERGE INTO A T USING (SELECT * FROM B) AS S ON T.objID=S.objID AND 
T.objType=S.objType AND T.intent=S.intent AND T.number=S.number WHEN NOT 
MATCHED THEN INSERT (objID, objType, number, intent) VALUES (S.objID, 
S.objType, S.number, S.intent);
  DROP TABLE B CASCADE
}

If run with the previous versions 1.4, 2.1 and 2.2.220 it's finished after 
some seconds.
With the 2.2.222 it takes longer with each loop; don't finish after some 
minutes.

Please take a look; thanks.

Thanks,
  Jürgen
Andreas Reichel schrieb am Mittwoch, 23. August 2023 um 14:12:42 UTC+2:

> 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/a9dde386-ec94-4beb-b13a-a2913f6e4311n%40googlegroups.com.

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.

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

[Jürgen Pingel]

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/809493cb-932d-4632-b1e5-239485e0f7f6n%40googlegroups.com.

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

['TheRaywell' via H2 Database]

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/2fad63eb-1048-464e-b05a-28b2939a0caen%40googlegroups.com.

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

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

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

[Vali Maties]

Hi.
 I've tried to update the driver used in my Maven project from 2.1.214 to 
2.2.220, and now it gives me some error:

"The write format 2 is smaller than the supported format 3 [2.2.220/5]".

Seems that I have to upgrade the database as well? 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!

Best regards,
Vali
Pe miercuri, 5 iulie 2023, la 03:59:56 UTC+3, and...@manticore-projects.com 
a scris:

> Thank you so much H2 Team!
> We have updated the H2 Migration Tool to reflect the new H2 Library. 
> https://manticore-projects.com/H2MigrationTool/index.html
>
> All the best
> Andreas
>
> On Tue, Jul 4 2023 at 01:07:51 PM -04:00:00, Andrei Tokar <
> andrei...@gmail.com> wrote:
>
> Hello, A new version 2.2.220 of H2 is available at 
> http://www.h2database.com (you may have to click 'Refresh') and 
> https://github.com/h2database/h2database/releases/tag/version-2.2.220 For 
> details, see the 'Change Log' at 
> http://www.h2database.com/html/changelog.html New artefacts will be 
> uploaded to maven repository shortly. 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...@googlegroups.com. To view 
> this discussion on the web visit 
> https://groups.google.com/d/msgid/h2-database/baa7598e652f5e0f469b2706f8e990dd4b32ac31.camel%40gmail.com.
>  
>
>
>

-- 
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/8d8d2fbb-977a-486f-b77c-1ef2a5c8f003n%40googlegroups.com.

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

[andreas]

Thank you so much H2 Team!
We have updated the H2 Migration Tool to reflect the new H2 Library. 



All the best
Andreas

On Tue, Jul 4 2023 at 01:07:51 PM -04:00:00, Andrei Tokar 
 wrote:


Hello,

A new version 2.2.220 of H2 is available at http://www.h2database.com 


(you may have to click 'Refresh') and



For details, see the 'Change Log' at


New artefacts will be uploaded to maven repository shortly.


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 
.


--
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/HFTAXR.6Q6DG8CIKJ5G2%40manticore-projects.com.

[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello,

A new version 2.2.220 of H2 is available at http://www.h2database.com
(you may have to click 'Refresh') and
https://github.com/h2database/h2database/releases/tag/version-2.2.220


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

New artefacts will be uploaded to maven repository shortly.


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

[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello,

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

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

[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello,

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

It contains a patch for H2 console security issue:
https://github.com/h2database/h2database/security/advisories/GHSA-h376-j262-vhq6

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

[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello,

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

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

[h2] H2 Database Engine: New version released

[Andrei Tokar]

Hello,

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

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,
Thomas




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

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

[Noel Grandin]

Lots of great improvements in this release, performance and reliability is 
definitely much better,
and a ton of thanks to Evgenij Ryazanov  and Andrei Tokar  for all their hard 
work.

--
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/6edbe836-2b0e-9282-305f-cb93b43400e2%40gmail.com.

[h2] H2 Database Engine: New version released

[Thomas Mueller Graf]

Hello,

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

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

Please note the jar file may not yet be available in the
Maven central repository (synchronizing usually takes a few hours).

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

Have fun,
Thomas

-- 
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/CAKpgiBY6HQ5r0UpjBOKV%2BXsTPtUjDEz8jXXChX4YnYf3%3D9FKaA%40mail.gmail.com.

[h2] H2 Database Engine: New version released

[Thomas Mueller Graf]

Hello,

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

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

Please note the jar file may not yet be available in the
Maven central repository (synchronizing usually takes a few hours).

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

Have fun,
Thomas

-- 
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 post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] H2 Database Engine: New version released

[Thomas Mueller Graf]

Hello,

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

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

Please note the jar file may not yet be available in the
Maven central repository (synchronizing usually takes a few hours).

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

Have fun,
Thomas

-- 
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 post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] H2 Database Engine: New version released

[Thomas Mueller Graf]

Hello,

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

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

For future plans, see the 'Roadmap' page at
http://www.h2database.com/html/roadmap.html

Please note the jar file may not yet be available in the
Maven central repository (synchronizing usually takes a few hours).

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

Have fun,
Thomas

-- 
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 post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.