I use a cache size of H2_CACHE_SIZE = 1000000, could that be the reason. After I run a query over all databases, forcing a DATABASE DEFRAG and DATABASE COMPACT, it is followed with some missing records.
Could this be related? Rinse Op zondag 20 april 2025 om 15:04:24 UTC+2 schreef Noel Grandin: > > Normally this happens because someone opens a transaction and then forgets > to commit it > > -- 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 visit https://groups.google.com/d/msgid/h2-database/53fef108-7e9f-411d-af5a-b6d697fb8132n%40googlegroups.com.