JDBC upgrade fails from 3.4.5 to 4.0.2

Setup, Configuration and Use Migration
1

I have openhab in a docker container, and upgraded it from 3.4.0 to 3.4.4.
When upgrading from 3.4.4 to 3.4.5 mariadb persistence was lost, so I ended up dumping the database and renaming it from items to Items and item0001 to Item1 and so on… (search and replace long sql file).
Now it works correct on 3.4.5 but when upgrading to 4.0.2 old data is lost (graphs are empty in basic UI).
I thing I have something messed up from my mysql binding when upgrading to jdbc, but I cannot see what it is.

My jdbc.cfg is:

url=jdbc:mysql://192.168.1.7:3306/openhab3
user=openhab3
password=********
itemsManageTable=Items
tableNamePrefix=Item
tableUseRealItemNames=false
tableIdDigitCount=0

Is there any extra step to migrate to 4.x?

2

What’s the default persistence? That is what gets used for charting.

3

It’s JDBC, but after upgrading it is not listed in settings. I believe the problem comes from my previous mysql persistence usage, and by some cause it fails to work.

4

After testing again, I had to install manually again JBDC after upgrade, just to get a “flat line”. I selected a bigger date range and discovered that at some point I restored and old backup and last 3 days are “lost somewhere”, so everything was working ok :face_with_raised_eyebrow:

I will check backups later to get missing info.

Thanks for your time.

5

I have checked again, and I cannot see where the problem is, are some screenshots (using the same database.table):

With openhab3

Screenshot_20230905-181847
Screenshot_20230905-181847720×1560 102 KB

With openhab4

Screenshot_20230905-182000
Screenshot_20230905-182000720×1560 59.2 KB

with openhab4 extending date range

Screenshot_20230905-182009
Screenshot_20230905-182009720×1560 51.6 KB

6

All I can recommend is checking your persistence config. Watch the logs for errors. Consider putting the jdbc add-on into debug or trace level logging.

1 Like