The root cause looks very promising, nice job
Hello,
I'm also experiencing these random data losses very often with h2 2.3.232. It looks similar to issue #4123I recently spent hours investigating the issue, and I may have identified a potential root cause in #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 [email protected].
To view this discussion visit https://groups.google.com/d/msgid/h2-database/67574f76-3a86-402f-a40d-1825114c8e96n%40googlegroups.com.
--
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 [email protected].
To view this discussion visit https://groups.google.com/d/msgid/h2-database/6F47F207-9B81-46EB-BDB6-2845C87859D5%40gmail.com.
|
