Bug in timestamp persistence?

Add-ons Persistence Services
1

Hello,
I want to do some regular queries with the openhab API but I ran into a problem and I don’t understand why.

In request i have:

  "date": [
         {
             "time": 1651615125318,
             "state": "475.2"
         }
]

Translating “time” into human language, I receive: Tuesday, May 3, 2022 21: 58: 45.318

But in InfluxDB I can’t find the date for the value 475.2.
only: 22-05-03 22:41:58

I thought it might be the time zone difference but the difference is too big for the Bucharest time zone.

2

Is there only a ‘single’ occurence of the value 475.2 ?
As far as I understand the conversion of the since epoch value to date/time is in GMT/UTC format.

1651615125318 => GMT: Tuesday, 3. May 2022 21:58:45.318
that would => EEST: Wednesday, 4. May 2022 0:58:45.318

Did you search for the value on that day ?

3

nope, there are more events like that.

1651615125318 => GMT : Tuesday, 3. May 2022 21:58:45.318
that would => EEST : Wednesday, 4. May 2022 0:58:45.318

I agree with you, but the time difference should be 3 hours. (we have summer time).
21: 58 - 22:41 = 1.38 hours difference. it should be 3 hours?

I was thinking maybe is the esp that sends the date wrong?

4

This

"date": [
         {
             "time": 1651615125318,
             "state": "475.2"
         }
]

is coming form the ESP and to be stored in influxdb ?

5

it from influxdb via Openhab API…but the data is send from ESP32 → Openhab → influxdb

6

So the ESP part is irrelevant - you have an Item in openHAB that gets persisted.
Do you understand exactly when openHAB is persisting it? i.e. what persist strategy are you using.

7

I question that you do compare the data correctly.
The output of the REST API request to the influxDB shows a time and a value. You converted this time from msec to an human readable time in UTC.
How did you get the other time, in what format was it stored and what data is stored for this datapoint ( maybe an additional time and a value?).