Persisted data not shown in charts

Setup, Configuration and Use Beginners
, ,
1

I’m currently in the process of switching from version 2.4 to 3.2.
openHAB is running in a docker container and using JDBC (mariaDB) as persistence.

jdbc.persist files looks like

Strategies {    
	everyMinute : "0 * * * * ?"
	
	default = everyChange
}

Items {
   persistenzSpeichern*	: strategy = everyChange
}

I verified that the data is stored in the database and data is retrieved as you can see in the network tab:

grafik
grafik1208×668 23.3 KB

However the charts do not show any data.
Also when clicking on analyze on the item, nothing is shown.

Is there a known issue with the charts and jdbc?
I found only some old bug reports which seemed not directly related to this or mostly the issues have been related to the rrd4j persistence which I do not use.

2

Where are the charts trying to fetch their data from? You haven’t mentioned setting “system default persistence” to steer that, which will not be jdbc by default.

3

If you are referring to the “System Services > Persistence” settings tab:
I set this one already to JDBC - forgot to mention that.

4

And I think I found the issue. Had a look in the log files and realized that the timezone of the log entries has been wrong. I added a new environment variable to my docker deployment

variable: TZ
value: Europe/Vienna

Now the log timestamps are correct and the chart is showing some data.

So looks to me like a bug in openHAB because the chart itself showed the correct time-frame on the axis and the data from the database had the correct timestamp. Only the chart has not been drawn.