Hi all, i have a problem and i don’t know what to do. The problem startet whith trying to get rid of some error messages in the MySQL log. So i had to change the connectionparameter for the jdbc persistence. I changed everything restartet openhab but first there was a permission error in mysql. I …

Today i tried to downgrade back to 3.2. After the downgrade was finished no things where shown but all items where there. After upgrading back to 3.3 everything was like before the downgrade. Is this behaviour after the downgrade as expected?

Might be related [image] OH3.3 - Semantic Model mess Beginners Comment, for info only - invalid Item names beginning with digits have been seen to cause “mysterious” problems with DSL rule triggers, old-style sitemaps, and persistence services. All of those ar…

good idea but i can’t find any item or thing starting with a digit. checked the schemantic model and rules also but nothing.

Today i tried to downgrade back to 3.2. After the downgrade was finished no things where shown but all items where there. After upgrading back to 3.3 everything was like before the downgrade. Is this behaviour after the downgrade as expected? shouldn’t it be possible to simply downgrade in minor…

ok c’mon. there must be a possibility to debug this. Why are there no errormessages if there obviously are some errors?

and another bump no errors in the logfiles. What am i missing? :ghost:

You might have to give us a bit more detail. What version of OH are you currently running? What OH add-on have you installed, to use with your MySQL? How did you configure that? Thread title talks about “not all data”, does that mean some Items are persisted? How do you know? And some aren’t - h…

At the moment i’m running OH 3.3.0-1 the last release from the repo( JFrog stable/main). MySQL(mysqld Ver 5.7.39-0ubuntu0.18.04.2) is used with JDBC Persistence MySQL(3.3.0) configured through configfile(/etc/openhab/services/jdbc.conf) This is an old installation from 2.X. But all items, things …

Did you check if data is persisted with API Explorer or did you simply conclude some items are not persisted because no values are shown on Grafana?

nothing of those two. grabbed my mysql cli checked the items lookuptable for the right tablenumber und did a “select * from item0340 order by time desc limit 5;” but maybe you lead me to something brb need to check that

Not all Data in Persistence

Add-ons Persistence Services

rossko57 (Rossko57) August 4, 2022, 5:01pm 3

Might be related