2022-05-09 08:37:53.051 - debug: influxdb.0 (1552) History-queries to execute: from(bucket: "iobroker")
|> range(start: 2020-05-02T06:37:52.451Z, stop: 2022-05-02T06:37:52.450Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.NEQ0863718.1.POWER")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1),from(bucket: "iobroker") |> range(start: 2022-05-02T06:37:52.451Z, stop: 2022-05-09T06:37:52.451Z) |> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.NEQ0863718.1.POWER") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group() |> sort(columns:["_time"], desc: false) |> limit(n: 9999999) |> mean(column: "value"),from(bucket: "iobroker")
|> range(start: 2022-05-09T06:37:52.452Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.NEQ0863718.1.POWER")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2022-05-09 08:37:53.051 - debug: influxdb.0 (1552) Query to execute: from(bucket: "iobroker")
|> range(start: 2020-05-02T06:37:52.451Z, stop: 2022-05-02T06:37:52.450Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.NEQ0863718.1.POWER")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2022-05-09 08:37:53.863 - debug: influxdb.0 (1552) Bool check error: runtime error @4:12-4:163: filter: type conflict: bool != string
2022-05-09 08:37:53.864 - debug: influxdb.0 (1552) History-queries to execute: from(bucket: "iobroker")
|> range(start: 2020-05-02T06:37:52.451Z, stop: 2022-05-02T06:37:52.450Z)
|> filter(fn: (r) => r["_measurement"] == "mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1),from(bucket: "iobroker") |> range(start: 2022-05-02T06:37:52.451Z, stop: 2022-05-09T06:37:52.451Z) |> filter(fn: (r) => r["_measurement"] == "mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group() |> sort(columns:["_time"], desc: false) |> limit(n: 9999999) |> mean(column: "value"),from(bucket: "iobroker")
|> range(start: 2022-05-09T06:37:52.452Z)
|> filter(fn: (r) => r["_measurement"] == "mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2022-05-09 08:37:53.865 - debug: influxdb.0 (1552) Query to execute: from(bucket: "iobroker")
|> range(start: 2020-05-02T06:37:52.451Z, stop: 2022-05-02T06:37:52.450Z)
|> filter(fn: (r) => r["_measurement"] == "mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2022-05-09 08:37:54.016 - debug: influxdb.0 (1552) Query to execute: from(bucket: "iobroker") |> range(start: 2022-05-02T06:37:52.451Z, stop: 2022-05-09T06:37:52.451Z) |> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.NEQ0863718.1.POWER") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group() |> sort(columns:["_time"], desc: false) |> limit(n: 9999999) |> mean(column: "value")
2022-05-09 08:37:54.114 - debug: influxdb.0 (1552) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-05-09T06:37:52.452Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.NEQ0863718.1.POWER")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2022-05-09 08:37:54.155 - debug: influxdb.0 (1552) Parsing retrieved rows:[[{"result":"_result","table":0,"_start":"2020-05-02T06:37:52.451Z","_stop":"2022-05-02T06:37:52.45Z","_time":"2022-05-02T06:36:45.874Z","_measurement":"hm-rpc.0.NEQ0863718.1.POWER","ack":true,"from":"system.adapter.hm-rpc.0","q":0,"value":378,"time":"2022-05-02T06:36:45.874Z"}],[{"result":"_result","table":0,"value":548.0187384534178}],[]]
2022-05-09 08:37:54.156 - debug: influxdb.0 (1552) Beautify: 2 results
2022-05-09 08:37:54.156 - debug: influxdb.0 (1552) Send: 1 of: 2 in: 1698ms
2022-05-09 08:37:55.356 - debug: influxdb.0 (1552) PING OK
2022-05-09 08:37:55.964 - debug: influxdb.0 (1552) Query to execute: from(bucket: "iobroker") |> range(start: 2022-05-02T06:37:52.451Z, stop: 2022-05-09T06:37:52.451Z) |> filter(fn: (r) => r["_measurement"] == "mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group() |> sort(columns:["_time"], desc: false) |> limit(n: 9999999) |> mean(column: "value")
2022-05-09 08:37:56.407 - debug: influxdb.0 (1552) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-05-09T06:37:52.452Z)
|> filter(fn: (r) => r["_measurement"] == "mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2022-05-09 08:37:56.441 - debug: influxdb.0 (1552) Parsing retrieved rows:[[{"result":"_result","table":0,"_start":"2020-05-02T06:37:52.451Z","_stop":"2022-05-02T06:37:52.45Z","_time":"2022-05-02T06:37:25.548Z","_measurement":"mqtt-client.0.Sensoren.Wohnwagen.Wohnwagenbatterie.Spannung","ack":true,"from":"system.adapter.mqtt-client.0","q":0,"value":13.49,"time":"2022-05-02T06:37:25.548Z"}],[{"result":"_result","table":0,"value":13.353873378509196}],[]]
2022-05-09 08:37:56.442 - debug: influxdb.0 (1552) Beautify: 2 results
2022-05-09 08:37:56.442 - debug: influxdb.0 (1552) Send: 1 of: 2 in: 3963ms