The Grafana add-on on my Home Assistant has suddenly broken:
As the screenshot shows, the error is: “InfluxDB Error: error parsing query: found %, expected identifier, string, number, bool at line 1, char 13”
Having a look at the Grafana add-on logs, we have, e.g.
[06/Oct/2020:17:42:28 +0100] 400 192.168.1.108, 172.30.32.1(172.30.32.2) GET /api/datasources/proxy/1/query?db=homeassistant&q=SELECT+mean(%2522value%2522)+FROM+%2522%25C2%25B5g/m%25C2%25B3%2522+WHERE+(%2522entity_id%2522+%253D+'luftdaten_50321_p2')+AND+time+%253E%253D+now()+-+6h+GROUP+BY+time(30s)+fill(linear)%253BSELECT+mean(%2522value%2522)+FROM+%2522%25C2%25B5g/m%25C2%25B3%2522+WHERE+(%2522entity_id%2522+%253D+'luftdaten_50321_p1')+AND+time+%253E%253D+now()+-+6h+GROUP+BY+time(5m)+fill(linear)&epoch=ms HTTP/1.1 (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36)
t=2020-10-06T17:42:28+0100 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/datasources/proxy/1/query status=400 remote_addr="192.168.1.108, 172.30.32.1" time_ms=7 size=103 referer="http://homeassistant:8123/api/hassio_ingress/O8QAbIJPrQQi_yQvU33oXkPgHCUuyFgSRBek7B5Qyo0/d/-9IdvviRk/environment?orgId=1"
note the "%2522"s in the URL - which looks as though it’s trying to escape double quotes twice - which correlates with a “%” at char 13 in the SELECT query.
Bizarrely, Grafana has been fine for months now, and has only just started doing this since I tried logging on just after 5 this evening.
So I’m wondering what’s changed to cause this? I’ve tried restarting HassOS but that did not make any difference.
1 Like
BTW, I fixed this by going to the “Configuration - Data Sources” section in Grafana, and changing the connection settings to InfluxDB to use POST instead of GET.
14 Likes
Hi all. I just had the same issue and solved in a similar way. I entered the Grafana - Datasource configuration but I had to change the parameter “http method” to “POST”
15 Likes
DanneG
(Daniel)
October 6, 2020, 9:54pm
4
Tnx! This worked for me as well!
simtr
(Simon)
October 6, 2020, 10:13pm
5
Just had exactly the same issue. Googled the error and found this thread.
I had a look at my influxdb Datasource in Grafana, lo and behold my “HTTP method” was blank. I changed it to POST and it fixed the issue.
I don’t remember if this was always blank or not, but I had not updated or changed any configuration recently, but it just broke some point today.
3 Likes
NaduK
October 6, 2020, 10:27pm
6
I did the suggested “HTTP method” change and now all my graphs are filled with test data or something. it’s not the numbers I saw last night.
When I edit the graph I see this
I’m getting the error while adding the InfluxDB datasource in Graphana
Influxdb plugin: 3.7.6
Grafana: 5.3.0
LE: this fixed the issue for me
After upgrading to 0.115.6 and supervisor 246 grafana in combination with influxdb is not working anymore. I receive the following message:
error parsing query: found %, expected identifier, string, number, bool at line 1, char 13
When testing the grafana datasource (influxdb) i receive the following error:
InfluxDB Error: error parsing query: found %, expected identifier at line 1, char 28
Anyone else with the same problem?
Update: Fixed the problem. In the Grafana go to the datasource th…
joem
(Zsolt)
October 7, 2020, 2:42am
8
Setting HTTP to POST solved it.
Since is a breaking issue it should be mentioned from now on in the documentation or changelog/upgrade instructions.
4 Likes
Ah brilliant - that’ll have done it then! Yes - POST will have meant that the query string problem gets sorted.
ruko
(Ruud)
October 7, 2020, 8:10am
10
Same problem here. Setting HTTP to POST solved it.
rogerio
(Rogerio Mota)
October 7, 2020, 9:21am
11
Same problem here. Setting HTTP to POST fixed. Thanks @ruthdonna
Thank you thank you thank you all for posting this.
Wonderful, this works, no data lost! Thanks
tom_l
October 7, 2020, 12:44pm
14
This was caused by an update of the supervisor, not home assistant. The update will occur automatically, so you rarely see the change notes. Also this was an unintended issue, so not a breaking change.
osks
(Oskar Skoog)
October 7, 2020, 1:51pm
15
Version 247 of Supervisor was just released, it should fix the problem. It fixed a similar problem for me with broken URLs (bad percent-encoding) for Grafana and Prometheus (it was also was possible to work around by switching to POST, but now it works with GET).
gt4020
(Giovanni)
October 7, 2020, 7:51pm
16
Same issue and same solution for me! Thank you.
In my case upgrade HA to 0.116 yesterday solved the problem.
sender
November 10, 2024, 7:00pm
18
When I want to add a new “visualization”(pane) I suddenly get this error. Where to start investigating?
Duplicating a panel works well, but adding a new one throws the error.
I can’t click “+” after WHERE, then the browser locks.
I use POST:
The error:
Status: 500. Message: InfluxDB returned error: error parsing query: found FROM, expected identifier, string, number, bool at line 1, char 9
Sir_Goodenough
((SG) WhatAreWeFixing.Today)
November 11, 2024, 1:45am
19
Consider starting a new post. This one has been dead for 4 years and is hidden in a dead category.