Hi,
i upgraded last my dockerized openhab installation from openhab2 to openhab3. Most things are running correctly.
i have for most items influxdb persistence with a special retentionpolicy i named “2year” which was former on oh2 working correctly.
some rules i have getting such errormessages in openhab.log:
2021-01-07 19:51:01.419 [ERROR] [internal.handler.ScriptActionHandler] - Script execution of rule with UID ‘wind-1’ failed: error parsing query: found 2year, expected identifier at line 1, char 19 in wind
2021-01-07 19:46:02.117 [ERROR] [internal.handler.ScriptActionHandler] - Script execution of rule with UID ‘wind-1’ failed: error parsing query: found 2year, expected identifier at line 1, char 19 in wind
It appears every time in script something like averagesince is queried.
influxdb tells the query:
[httpd] 192.168.2.244 - openhab [07/Jan/2021:19:04:37 +0000] “GET /query?db=openhab&epoch=ms&q=SELECT+value+FROM+2year.TemperaturTiefkuehler+WHERE+time+%3E%3D+%272021-01-07T18%3A04%3A37.700488Z%27+ORDER+BY+time+ASC%3B HTTP/1.1” 400 85 “-” “okhttp/3.14.4” 300ccaeb-511b-11eb-832c-0242ac1b0002 69391
Influx is version 1.8.2
If im urldecoding the sql and asking influxdb with the by openhab generated url:
Connected to http://localhost:8086 version 1.8.2
InfluxDB shell version: 1.8.2
use openhab
Using database openhab
SELECT value FROM 2year.TemperaturTiefkuehler WHERE time >= ‘2021-01-07T18:04:37.700488Z’ ORDER BY time ASC;
ERR: error parsing query: found 2year, expected identifier at line 1, char 19
then im getting exactly the message im seeing in the openhab log.
Is it possible to avoid this or is this a bug?