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/c7b6a740-e41d-417c-90f7-d70653556bd3n%40googlegroups.com.
