Re: [h2] DB regression when exiting with SHUTDOWN COMPACT?

2021-12-09 Thread torlpedo
Hi all, Thank you Andreas for confirming. This is strange... With h2 version 1.4.200, although having the size creep, the database file ended up well formed and a posterior re-connection allowed DML changes on data... BR, Ivan On Thursday, December 9, 2021 at 3:09:42 PM UTC+1 and...@mantic

Re: [h2] DB regression when exiting with SHUTDOWN COMPACT?

2021-12-09 Thread Andreas Reichel
Greetings! Unfortunately, this seems to be a kind of normal: As long as the DB is running, it will keep "leaking" file space . Our virgin 2 GByte DB grew to 400 GB eventually, after running for months. "Shutdown defrag" frees a lot of the claimed file space, but not all and it depends on a restart

[h2] DB regression when exiting with SHUTDOWN COMPACT?

2021-12-09 Thread torlpedo
Hi all, Creating a medium sized database (300MB with 800MB disk usage) and then exiting with SHUTDOWN COMPACT makes the database read-only, making impossible to modify the data via DML commands. I tried opening the DB in read-write mode in the connection string using ACCESS_MODE_DATA without s