Database never reduce its file size until the connection is shut down in 2.1.214. Version 1.4.200 does

[Pierre-Olivier Lecomte]

Hello,

We faced issue with long running databases in H2 v2.1.214 which file size never goes down until all database connection are closed (with the same amount of data).

This leads to ever growing database that can reach problematic file size on the long term while the actual data inside is stable.

We were able to highlight a difference in the behavior of H2 V2.1.214 and H2 V1.4.200 in the auto compaction process while inserting and deleting over and over the same line within the database.

Details of the test case that highlights the difference can be found on the GitHub ticket : https://github.com/h2database/h2database/issues/3848

Is that change of behavior between the two version expected?

If so, with the current behavior, do you have any advices to ensure that the database file size stays stable on the long term when using the H2 V2.1.214? (we would like to avoid having to compact the database regularly)

Best regards,

Pierre-Olivier