Re: [h2] Compact on db close does not shrink db file size

, from my point of view H2 is a very good database especially in embedded context! Thanks! Ulrich -- 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-databas

[h2] Compact on db close does not shrink db file size

has no effect to the database size? Why doesn't it fully use the MAX_COMPACT_TIME setting? Why dosen't it touch the CHUNKS_FILL_RATE? Can you give an hint how to restrict the database file size? Thanks! Ulrich -- You received this message because you are subscribed to the Google Groups "H2

Re: [h2] Automatic COMPACT does not seem to work

ible anymore. > > On Wednesday, June 22, 2022 at 9:17:39 AM UTC-4 Ulrich wrote: > >> The documentation says: >> Using a lower value might be dangerous, unless the file system and hard >> disk flush the buffers earlier. >> >> Is it safe to use RETENTION_TIME

Re: [h2] Automatic COMPACT does not seem to work

The documentation says: Using a lower value might be dangerous, unless the file system and hard disk flush the buffers earlier. Is it safe to use RETENTION_TIME=0? What are the consequences? Do I have to fear that the database file becomes corrupted or that transactions are not consistent? I

Re: [h2] Automatic COMPACT does not seem to work

My URL parameters are: LOCK_TIMEOUT=8640;WRITE_DELAY=1;MAX_MEMORY_ROWS=100;MAX_OPERATION_MEMORY=5000;ANALYZE_AUTO=0 I'll check if the compact algorithm works (better) with the default parameters. andrei...@gmail.com schrieb am Donnerstag, 16. Juni 2022 um 03:31:05 UTC+2: > I

Re: [h2] Automatic COMPACT does not seem to work

Thanks for the clarification! I will try to pause operations on the database and see what happens. What do you mean with "while you run the compacter"? Is there a specific command to start the compacter. I thought it would start automatically or if I run SHUTDOWN COMPACT. Noel Grandin

Re: [h2] Automatic COMPACT does not seem to work

n the > defined shutdown time period (longer will give more time to compact). > > And yes, H2 database consumes a lot of file space, especially when data > are constantly written and deleted. I made exactly the same observation. > > Best regards > Andreas > > On Mon, 2022-0

[h2] Automatic COMPACT does not seem to work

4916121600 info.CHUNK_COUNT 490 info.PAGE_COUNT 1594967 info.PAGE_COUNT_LIVE 440730 info.PAGE_SIZE 4096 info.CACHE_MAX_SIZE 16 info.CACHE_SIZE 15 info.CACHE_HIT_RATIO 85 info.TOC_CACHE_HIT_RATIO 99 info.LEAF_RATIO 44 Thanks! Ulrich -- You received this message because you are subscribed

Re: [h2] Database corrupted after SHUTDOWN COMPACT

UTC+2: > Use the UI I sent to you. It takes care of those challenges. > > > > Sent from my Galaxy > > > Original message > From: Ulrich > Date: 10/06/2022 12:21 (GMT+01:00) > To: H2 Database > Subject: Re: [h2] Database corrupted after SH

Re: [h2] Database corrupted after SHUTDOWN COMPACT

Stop, I am silly. It overlooked that the file created by the BACKUP command is a zip file. I tried to use it as database file... -- 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,

Re: [h2] Database corrupted after SHUTDOWN COMPACT

I think it has something to do with the BACKUP TO command. I have done the following tests: 1) "Offline copy" * Shutdown my application (using 2.1.212) * copy the mv.db to my PC * open it with the H2 console (2.2.219) * run "SHUTDOWN COMPACT" => the database file shrinked and could be opened

Re: [h2] Database corrupted after SHUTDOWN COMPACT

I tried with the latest 219. The problem that the database corrupts when running SHUTDOWN COMPACT still exist. The compact is finished very fast but a .temp file remains in the database folder. Here is the content of the trace file: 2022-06-10 10:24:30 database: close

Re: [h2] Database corrupted after SHUTDOWN COMPACT

; Sent from my Galaxy > > > Original message > From: Ulrich > Date: 10/06/2022 09:34 (GMT+01:00) > To: H2 Database > Subject: [h2] Database corrupted after SHUTDOWN COMPACT > > Hi all, > I am migrating my application from H2 1.4.199 to H2 2

[h2] Database corrupted after SHUTDOWN COMPACT

ng the H2 console without any parameter. If you need a copy of the database please let me know. Thanks! Ulrich -- 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

[h2] Re: 2.0.202 and hibernate: boolean field regression?

Small update: Not working: Predicate predicate = criteriaBuilder.isFalse(itemRoot.get("testFlag")); Working: Predicate predicate = criteriaBuilder.equal(itemRoot.get("testFlag"), Boolean.FALSE); Ulrich schrieb am Dienstag, 30. November 2021 um 17:23:40 UTC+1: >

[h2] 2.0.202 and hibernate: boolean field regression?

ression or if I made a mistake? Thanks! Ulrich -- 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 disc