HabPanel, TimeLine, InfluxDB2, OH3

Setup, Configuration and Use Items & Sitemaps
, ,
1

OpenHab3 Build #2030
HabPanel, widget TimeLine does not display data from the database influxdb2.
image
chrome - developer tools:
image

image
image607×727 33.5 KB

REST API:

http://192.168.215.221:8080/rest/persistence/items/BlitzWOLF?serviceId=influxdb

result:

{
  "name": "BlitzWOLF",
  "datapoints": "31",
  "data": [
    {
      "time": 1606450611644,
      "state": "OFF"
    },
    {
      "time": 1606450797498,
      "state": "OFF"
    },
    {
      "time": 1606450797498,
      "state": "ON"
    },
    {
      "time": 1606451181570,
      "state": "ON"
    },
    {
      "time": 1606451181570,
      "state": "OFF"
    },
    {
      "time": 1606451534299,
      "state": "OFF"
    },
    {
      "time": 1606451534299,
      "state": "ON"
    },
    {
      "time": 1606451608255,
      "state": "ON"
    },
    {
      "time": 1606451608255,
      "state": "OFF"
    },
    {
      "time": 1606452727735,
      "state": "OFF"
    },
    {
      "time": 1606452727735,
      "state": "ON"
    },
    {
      "time": 1606452747728,
      "state": "ON"
    },
    {
      "time": 1606452747728,
      "state": "OFF"
    },
    {
      "time": 1606453780803,
      "state": "OFF"
    },
    {
      "time": 1606453780803,
      "state": "ON"
    },
    {
      "time": 1606455135148,
      "state": "ON"
    },
    {
      "time": 1606455135148,
      "state": "OFF"
    },
    {
      "time": 1606455292485,
      "state": "OFF"
    },
    {
      "time": 1606455292485,
      "state": "ON"
    },
    {
      "time": 1606455733298,
      "state": "ON"
    },
    {
      "time": 1606455733298,
      "state": "OFF"
    },
    {
      "time": 1606457498774,
      "state": "OFF"
    },
    {
      "time": 1606457498774,
      "state": "ON"
    },
    {
      "time": 1606457731316,
      "state": "ON"
    },
    {
      "time": 1606457731316,
      "state": "OFF"
    },
    {
      "time": 1606457785309,
      "state": "OFF"
    },
    {
      "time": 1606457785309,
      "state": "ON"
    },
    {
      "time": 1606457802849,
      "state": "ON"
    },
    {
      "time": 1606457802849,
      "state": "OFF"
    },
    {
      "time": 1606457888426,
      "state": "OFF"
    },
    {
      "time": 1606457888426,
      "state": "ON"
    }
  ]
}

Does anyone else have such problems?
Can anyone check with themselves?
Thanks!

2

So if I understand correctly, this request works:
http://192.168.215.221:8080/rest/persistence/items/BlitzWOLF?serviceId=influxdb

but this one doesn’t:
image

What if you include the starttime but not boundary=true? What do you have in the response tab to this call? Sometimes you have more information there.

3

I created this thread when I used InfluxDB2
but due to problems, I uninstalled it and installed InfluxDB1.

I can’t try it now, because I am currently working on Influx1 and now I have a different problem.

this request always returns OFF

{"name":"BlitzWOLF","datapoints":"25","data":[{"time":1607946980543,"state":"OFF"},{"time":1607946999402,"state":"OFF"},{"time":1607946999402,"state":"OFF"},{"time":1607947006525,"state":"OFF"},{"time":1607947006525,"state":"OFF"},{"time":1607948314356,"state":"OFF"},{"time":1607948314356,"state":"OFF"},{"time":1607948352002,"state":"OFF"},{"time":1607948352002,"state":"OFF"},{"time":1607948358067,"state":"OFF"},{"time":1607948358067,"state":"OFF"},{"time":1607952428174,"state":"OFF"},{"time":1607952428174,"state":"OFF"},{"time":1607952430200,"state":"OFF"},{"time":1607952430200,"state":"OFF"},{"time":1607952437535,"state":"OFF"},{"time":1607952437535,"state":"OFF"},{"time":1607952801915,"state":"OFF"},{"time":1607952801915,"state":"OFF"},{"time":1607953534319,"state":"OFF"},{"time":1607953534319,"state":"OFF"},{"time":1607989180790,"state":"OFF"},{"time":1607989180790,"state":"OFF"},{"time":1608010843134,"state":"OFF"},{"time":1608010843134,"state":"OFF"}]}

and the impact tracing shows that the values change from ON to OFF
here is my post about it.

4

By the way, I completely forgot that I have another setup and that InfluxDB2 is still working in it. I’ll take a look and give the answer.

Update:

http://192.168.215.231:8080/rest/persistence/items/Box_HeaterIR?boundary=true&starttime=2020-12-12T08:42:48.654Z&serviceId=influxdb

result:

"{\"error\":{\"message\":\"error in building plan while starting program: cannot query an empty range\",\"http-code\":500,\"exception\":{\"class\":\"com.influxdb.exceptions.BadRequestException\",\"message\":\"error in building plan while starting program: cannot query an empty range\",\"localized-message\":\"error in building plan while starting program: cannot query an empty range\"}}}"

and

http://192.168.215.231:8080/rest/persistence/items/Box_HeaterIR?starttime=2020-12-12T08:42:48.654Z&serviceId=influxdb

result:

{"name":"Box_HeaterIR","datapoints":"11","data":[{"time":1607770382301,"state":"OFF"},{"time":1607825001651,"state":"OFF"},{"time":1607825001651,"state":"ON"},{"time":1607855715531,"state":"ON"},{"time":1607855715531,"state":"OFF"},{"time":1607911899651,"state":"OFF"},{"time":1607911899651,"state":"ON"},{"time":1607952782902,"state":"ON"},{"time":1607952782902,"state":"OFF"},{"time":1608000847119,"state":"OFF"},{"time":1608000847119,"state":"ON"}]}

strange, for some reason 2-ON, then 2-OFF.

Update:

preview:

"{\"error\":{\"message\":\"error in building plan while starting program: cannot query an empty range\",\"http-code\":500,\"exception\":{\"class\":\"com.influxdb.exceptions.BadRequestException\",\"message\":\"error in building plan while starting program: cannot query an empty range\",\"localized-message\":\"error in building plan while starting program: cannot query an empty range\"}}}"

responce:

"{\"error\":{\"message\":\"error in building plan while starting program: cannot query an empty range\",\"http-code\":500,\"exception\":{\"class\":\"com.influxdb.exceptions.BadRequestException\",\"message\":\"error in building plan while starting program: cannot query an empty range\",\"localized-message\":\"error in building plan while starting program: cannot query an empty range\"}}}"
5

What does this mean? What can I do to get this to work?

6

That’s what you did above - when you have boundary=true in the request, it doesn’t work, you get this: error in building plan while starting program: cannot query an empty range.

It appears to be a bug in the influxdb persistence service, you should open an issue on GitHub to have it fixed.

7

Unfortunately, this is not clear to me.

My English is so bad, plus I don’t understand what the problem is, so I don’t know how to formulate the problem correctly. I found a similar problem and added links to my posts, not sure I did the right thing.
Thanks for the help!