OH3 Will not persisting all items

Setup, Configuration and Use Beginners
, ,
1

Good Evening,

I really help someone can help me out here.
I have just set up persistence on my OH3 box and configured the .persist file to only store 2x groups but it is still happily storing all of my items.

I am running 3.0.1 on a Ubuntu Server VM.
The database is MySQL also running on a Ubuntu Server VM.

My myopenhab.persist is as follows, I have tried removing this file as well

Strategies {
    default = everyChange
}
Items {
    
}

My mysql.persist is:

Strategies {
    default = everyUpdate
}
Items {
    Sensors_Battery*, Sensors_Temperature* : strategy = everyUpdate
}

A snip from the first table in the database show it storing the uptime for a Switch:

| 2021-03-24 22:18:23.023 | 162 days, 15:02:25.62 |
| 2021-03-24 22:19:23.024 | 162 days, 15:03:25.62 |
| 2021-03-24 22:20:23.024 | 162 days, 15:04:25.62 |
| 2021-03-24 22:21:23.024 | 162 days, 15:05:25.61 |
| 2021-03-24 22:22:23.024 | 162 days, 15:06:25.61 |
| 2021-03-24 22:23:23.025 | 162 days, 15:07:25.61 |
| 2021-03-24 22:24:23.030 | 162 days, 15:08:25.61 |
| 2021-03-24 22:25:23.022 | 162 days, 15:09:25.61 |
| 2021-03-24 22:26:23.021 | 162 days, 15:10:25.61 |
| 2021-03-24 22:27:23.021 | 162 days, 15:11:25.61 |
| 2021-03-24 22:28:23.025 | 162 days, 15:12:25.61 |
| 2021-03-24 22:29:23.029 | 162 days, 15:13:25.61 |
+-------------------------+-----------------------+

The Items table shows a growing range of items being added to the database, most are not from the 2x groups shown in the MySQL.persist

+--------+-------------------------------------+
| ItemId | itemname                            |
+--------+-------------------------------------+
|      1 | AccessSwitch2_UpTime                |
|      2 | FF_Study_Sensor_Geiger              |
|      3 | Sensors_Geiger                      |
|      4 | Dyson475_Request                    |
|      5 | Dyson475_Topic_Status_Current       |
|      6 | GF_Hallway_Sensor_Temp              |
|      7 | Sensors_Temperature                 |
|      8 | AccessSwitch1_UpTime                |
|      9 | AccessSwitch1_Temp                  |
|     10 | GF_Toilet_Sensor_Temp               |
|     11 | AccessSwitch2_Temp                  |
|     12 | Dyson475_Pact                       |
|     13 | Home_General_Sensor_Temperature     |
|     14 | FF_MasterBedroom_Sensor_Temperature |
|     15 | OctoprintEvent                      |
|     16 | MQTTOctoPrint_Event                 |
|     17 | Home_General_Sensor_Lux             |
|     18 | GF_Lounge_Sensor_LightLevel         |
|     19 | GF_Lounge_Sensor_Temperature        |
|     20 | FF_Study_Sensor_Temperature         |
|     21 | FF_HenrysBedroom_Sensor_Temperature |
|     22 | OU_BackGarden_Sensor_Temperature    |
|     23 | OU_BackGarden_Sensor_BattPercentage |
|     24 | GF_Toilet_Sensor_Battery            |
|     25 | GF_Hallway_Sensor_Battery           |
|     26 | Home_General_Sensor_BattPercentage  |
|     27 | Dyson475_Vact                       |
|     28 | OctoprintConnected                  |
|     29 | MQTTOctoPrint_State                 |
|     30 | OctoprintState                      |
|     31 | MQTTOctoPrint_Connected             |
|     32 | OctoprintJobFileName                |
|     33 | MQTTOctoPrint_FileName              |
|     34 | Node2_Title3                        |
|     35 | Node2_Title1                        |
|     36 | Node2_Status                        |
|     37 | Node2_Title2                        |
|     38 | GF_Lounge_Light_Lounge_Color        |
|     39 | GF_Hallway_Light_Hall               |
|     40 | GF_Toilet_Sensor_LightLevel         |
|     41 | GF_Hallway_Sensor_LightLevel        |
|     42 | Sensors_lightLevel                  |
+--------+-------------------------------------+

I have read everything I can find on this, restarted the service, and rebooted the server all to no avail.
Thank you in advance for your help.

2

Which persistence service did you install? (That’s a hint to check your xxx.persist filename)

3

Hi @rossko57

Thanks for your answer but I am not sure I follow.
I Installed the MySQL service and my file is named as such!?

Are you implying that it should be other than it is?
If this is indeed the case can you elaborate for me, please?

Regards.

4

It will be a good start point.

“Persistence Strategies are configured in a file named .persist, stored in $OPENHAB_CONF/persistence. Replace “persistenceservice” with the name of your persistence add-on (e.g. rrd4j.persist).”

5

Hi @kristofejro

I have re-read that document and as instructed my .persist file is named as my addon mysql.persist.
Is there some additional naming element not mentioned such as jdbc-mysql.persist?

Thank you for your time.

6

I am not an expert but I think you can find an answer here:

7

Hi @kristofejro,

Thanks for that, I now see the file should be jdbc.persist.
I have made that change and it is working, thank you kindly.

When I get a moment I may see about submitting an update to reference the other document.

Cheers.