Missing Database entries with JDBC MariaDB Binding since OH3.3/3.4.M1

Add-ons Persistence Services
1

Hey there,

i’ve seen some weird behavour regarding the JDBC MariaDB Binding since 3.3.

grafik
grafik1575×473 25.9 KB

The Modbus Binding is polling the data from several devices every 5s. This works as expected and I see the updates every 5s in the logfile.

I’m using the JDBC MariaDB Binding as Persistence, but there are gaps of around 45s in the Database. With 2.5.12 everything has worked es expected. It like its working for a few seconds and there’s no more update in the database.

grafik
grafik958×76 3.7 KB

events.log

grafik
grafik1247×455 11.7 KB

mariadb
grafik

The described behaviour is in OH3.3 and OH3.4M1.

Platform information:
    Hardware: Intel/16GB
    OS: Debian via Docker
    Java Runtime Environment: 
         openjdk version "11.0.16" 2022-07-19
         OpenJDK Runtime Environment Temurin-11.0.16+8 (build 11.0.16+8)
         OpenJDK 64-Bit Server VM Temurin-11.0.16+8 (build 11.0.16+8, mixed mode)
    openHAB version: 3.4.0M1
2

Looking at stored database entries you seem to have duplicated values, even if your modbus poller did nit report them. There might be a small time shift between log and database, but values should be more or less consistent.
I suppose that you might be having multiple inserts but item state is not updated yet or seen by persistence service (for some reason), effectively you get same state two or three times.

3

A “small” time shift is no problem.
But there are missing 45sec in the database every 1-2 minutes.

I think I try to downgrade the JDBC persistence maybe this helps.

4

I’ve digged a bit deeper …

After removal of the RRD4J Persistence Binding everythings work as expected.
Looks like the Persistence Bindings interfere with each other…

grafik
grafik2186×580 22.2 KB