Hello, I'm also experiencing these random data losses very often with h2 2.3.232. It looks similar to issue #4123 <https://github.com/h2database/h2database/issues/4123> I recently spent hours investigating the issue, and I may have identified a potential root cause in #4247 <https://github.com/h2database/h2database/issues/4247>. I'm waiting for a maintainer to confirm or invalidate my analysis.
Hope this will get solved soon. Le vendredi 20 juin 2025 à 13:53:31 UTC+2, Rinse Lemstra a écrit : The applicationlog is also available: http://www.xso.nl/media/downloads/Application.zip Op vrijdag 20 juni 2025 om 13:30:43 UTC+2 schreef Rinse Lemstra: Hello, For several weeks we now try to find a situation where records get lost. I finaly managed to isolate one such an event in a trace-file ( TRACE_LEVEL_FILE=3 ) Attached you will find the application log and the trace-file. Could someone help us reading the trace-file and explain why the record is no longer in the database. We are using h2-2.2.224 The database is opened with the URL: timestamp=2025-06-20 11:16:02:373 | type=DEBUG | thread=qtp893591815-87061 {DATABASE_DIR=Philly Yacht Equipment/default, REMOTE_IP=/77.171.76.62, User=finance} | class=xso.timewriter.businesslayer.rules.RulesSession$1 | message=Connecting: jdbc:h2:file:D:\std\TimeWriter\lib\..\Databases\Philly Yacht Equipment\default\Data.std;DB_CLOSE_DELAY=5;TRACE_LEVEL_FILE=3;NON_KEYWORDS=VALUE,INTERVAL,KEY,TABLE,DEFAULT,MONTH,USER;QUERY_TIMEOUT=60000;IGNORECASE=TRUE;MODE=REGULAR;CACHE_SIZE=1000;DATABASE_TO_UPPER=TRUE;DEFRAG_ALWAYS=FALSE;MV_STORE=TRUE;AUTOCOMMIT=ON;LOCK_TIMEOUT=5000;FILE_LOCK=FILE; at 11:16:26:011 a new record is added with unique key 1750372121987000018 at 11:16:26:03 (and many times after ) the record is checked and found in the database at 12:16:59:075 the record is no longer in the database. Thanks in advance, -- 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/67574f76-3a86-402f-a40d-1825114c8e96n%40googlegroups.com.
