Persistence stopped working for some items

[Bredmich (Michael)]

I did another restart of openHAB because now the rule engine stopped working partially.
Basic timer rules were still running but thing based rules didn´t started or simple doesn´t received their trigger.

@Dim

put the addon in TRACE log level to see what the OH2 side has to say

I changed the log level through the console and checked with log:get
Also changed the smarthome and openhab log level to DEBUG.

Logger                                             │ Level
───────────────────────────────────────────────────┼──────
org.eclipse.smarthome                              │ DEBUG
org.openhab                                        │ DEBUG
org.openhab.persistence.mysql                      │ TRACE

It seems like the logging for mysql doesn´t work, as i don´t get any TRACE logs.

@Dim

double check that the MySQL server is up and running and listening to incoming connections

The mySQL Server is running on my HP MicroServer Gen8 with Windows Server 2016 and is up, running and listening for connections.
The error log had no entries for external events like broken connections or something similiar.
The general log is now enabled so it just started to log everything.

@Dim

try also to transition to the better version: persistence-jdbc-mysql instead of persistence-mysql

Is it possible to migrate?
There´s a topic in the docs but no information HOW to migrate…
Do i just need to uninstall the old one, install the new one and change the config file?

Migration from MySQL to JDBC Persistence Services - JDBC - Persistence Services

@Dim

did you recently modify the tags to the affected items?

I changed some group memberships for the battery channels.
The groups are defined at the beginning of my .items files and then used.
Some are starting with an uppercase letter and some with an lowercase letter, does this matter?

@Dim

you may have duplicate Items and/or Links in your system

I had a problem with my homematic items a while back.

oH2 doesn´t get updates from homegear

No real solution… I choosed the option to unpair and do a factory reset for my 8 homematic devices, cleared the homegear installation, cleared the oH2 installation from everything that relates to homematic and started from scratch. After that i had no problems and oH2 is now getting every update for the configured Things and Items.

As i´m coming from oH1 i choosed to still work with files instead of the json based PaperUI.
So i´m working with .things and .items files for everything i use in oH.
When initially setting up oH2 with Homegear for homematic all items were linked to things through the channels.
But a while back this links didn´t worked anymore so i had to link them through PaperUI.
Now i´m running with items that are linked to things through channels and the items are linked to things through PaperUI.
Maybe this could cause some problems?
The problem is that my items didn´t received any updates with the channel based linking to things…

openhab> items list |grep itmHeizung_Schlafzimmer_IST
itmHeizung_Schlafzimmer_IST (Type=NumberItem, State=21.40, Label=Temperatur Schlafzimmer, Category=heating, Tags=[CurrentTemperature], Groups=[Schlafzimmer, Temperatur, gPersist])
openhab> links list |grep itmHeizung_Schlafzimmer_IST                                                                                                                                                                                                                                                  
itmHeizung_Schlafzimmer_IST -> homematic:HM-CC-RT-DN:default:<SERIALNUMBER>:4#ACTUAL_TEMPERATURE
itmHeizung_Schlafzimmer_IST -> homematic:HG-HM-CC-RT-DN:default:<SERIALNUMBER>:4#ACTUAL_TEMPERATURE

So yes, i have duplicate links

I removed the PaperUI links through the JSON file org.eclipse.smarthome.core.thing.link.ItemChannelLink.json
and double checked the homematic.items file.

Now i just have one link for my oH items

openhab> items list |grep itmHeizung_Schlafzimmer_IST
itmHeizung_Schlafzimmer_IST (Type=NumberItem, State=21.40, Label=Temperatur Schlafzimmer, Category=heating, Tags=[CurrentTemperature], Groups=[Schlafzimmer, Temperatur, gPersist])
openhab> links list |grep itmHeizung_Schlafzimmer_IST                                                                                                                                                                                                                                       
itmHeizung_Schlafzimmer_IST -> homematic:HG-HM-CC-RT-DN:default:<SERIALNUMBER>:4#ACTUAL_TEMPERATURE

I don´t know if this caused the persistence to stop.
I´ll have a look at the stability in the next days and let the logs stay in DEBUG/TRACE for a while.

Last thing would be the migration from mySQL to JDBC with mySQL.

Thanks!