Please help understanding the trace-file

[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,

[Rinse Lemstra]

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:

[Arthur POIRET]

Hello,

I'm also experiencing these random data losses very often with h2 2.3.232. It looks similar to issue #4123

I 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.

[Stephane BARBARAY]

The root cause looks very promising, nice job

--

Stéphane BARBARAY

Le 22 juil. 2025 à 12:30, Arthur POIRET <drop...@gmail.com> a écrit :



--
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...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/h2-database/67574f76-3a86-402f-a40d-1825114c8e96n%40googlegroups.com.