Some items where stored with RRD4j even though I'm using JDBC MySQL

Setup, Configuration and Use Runtime
1

Hi,

  • Platform information:
    • Hardware: Intel x86-x64
    • OS: Windows 10 x64 Pro
    • Java Runtime Environment: Zulu JDK 11.54.23
    • openHAB version: openHAB 3.3.0.M1

I switched from RRD4j to JDBC MySQL as Persistence Service.

MySQL Persistance
MySQL Persistance734×348 5.6 KB

jdbc.perist:

Strategies {
  default = everyUpdate
}
Items {
  * : strategy = everyChange
  AnwesenheitModus,WetterUndZeitAnlass,ItemLueftungssteuerung : strategy = everyChange, restoreOnStartup
}

67 Items are stored and updated successfully in my MySQL DB:

MySQL Persistance 2
MySQL Persistance 21368×937 337 KB

All other items are still stored with RRD4j and I don’t know why this happens?!

For example:

2022-03-10 09:04:00.672 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'RollladeSchlafzimmerDoppel_Level' as value '0.95' in rrd4j database (again)
2022-03-10 09:04:00.672 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'RollladeSchlafzimmerDoppel_Level' as value '0.95' in rrd4j database
2022-03-10 09:04:00.688 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'BoschGeschirrspuler_Betrieb' as value '0.0' in rrd4j database (again)
2022-03-10 09:04:00.688 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'BoschGeschirrspuler_Betrieb' as value '0.0' in rrd4j database
2022-03-10 09:04:00.688 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'BoschMikrobackofen_BackofenTemperatur' as value '59.0' in rrd4j database
2022-03-10 09:04:00.703 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'Kellerheizung_Betrieb' as value '0.0' in rrd4j database (again)
2022-03-10 09:04:00.703 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'Kellerheizung_Betrieb' as value '0.0' in rrd4j database
2022-03-10 09:04:00.703 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'BoschMikrobackofen_TurStatus' as value '0.0' in rrd4j database (again)
2022-03-10 09:04:00.703 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'BoschMikrobackofen_TurStatus' as value '0.0' in rrd4j database
2022-03-10 09:04:00.719 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'WaschtrocknerWTH730_Tursignal' as value '0.0' in rrd4j database (again)
2022-03-10 09:04:00.719 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'FRITZDECTRepeater_Temperatur' as value '23.0' in rrd4j database
2022-03-10 09:04:00.735 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'NeffDunstabzugshaube_Functional_Light_Brightness_State' as value '0.02' in rrd4j database (again)
2022-03-10 09:04:00.735 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'NeffDunstabzugshaube_Functional_Light_Brightness_State' as value '0.02' in rrd4j database
2022-03-10 09:04:00.750 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'WetterstationSchlafzimmer_Temperatur' as value '18.899999618530273' in rrd4j database
2022-03-10 09:04:00.766 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'WetterstationWohnzimmer_NiedrigerBatteriestatus' as value '0.0' in rrd4j database (again)
2022-03-10 09:04:00.766 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'WetterstationWohnzimmer_NiedrigerBatteriestatus' as value '0.0' in rrd4j database
2022-03-10 09:04:00.766 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'LuftungObergeschoss_Stufe' as value '0.6' in rrd4j database (again)
2022-03-10 09:04:00.766 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'LuftungObergeschoss_Stufe' as value '0.6' in rrd4j database
2022-03-10 09:04:00.781 [DEBUG] [d4j.internal.RRD4jPersistenceService] - Stored 'WetterstationWohnzimmer_CO2Gehalt' as value '5.05E-4' in rrd4j database

Some of those logged items were already stored in my MySQL DB. Maybe sometimes openHAB / JDBC is unable to connect to the MySQL DB or to store values in the database, but then it is not ok to switch to another Peristance Service which the user has not selected.

MySQL (XAMPP) and openHAB are running on the same machine. MySQL is only used for openHAB.

Of course the whole server were already restarted.

Best regards,
Sascha

2

Unless you remove the RRD4J add-on, or actively prevent it storing by using a configuration file (rrd4j.persist), then RRD4J will continue to store data.

The default persistence service that you have selected does not turn off the others that are installed. Check here for more info.

1 Like