search

hassio-addons / addon-grafana

Grafana - Home Assistant Community Add-ons
https://addons.community
MIT License
228 stars 64 forks source link

After upgrading supervisor to 246 - getting "InfluxDB Error: error parsing query: found %, expected identifier, string, number, bool at line 1, char 13" #78

Closed slavik73 closed 3 years ago

slavik73 commented 4 years ago

Problem/Motivation

Grafana stopped to get data after upgrade to supervisor 246

Expected behavior

(What you expected to happen)

Actual behavior

(What actually happened)

Steps to reproduce

(How can someone else make/see it happen)

Proposed changes

(If you have a proposed change, workaround or fix, describe the rationale behind it)

I think '"' was replaced by %2522 somehow.

From the log: [06/Oct/2020:20:06:46 +0300] 400 192.168.5.132, 172.30.32.1(172.30.32.2) GET /api/datasources/proxy/1/query?db=homeassistant&q=SELECT+mean(%2522value%2522)+FROM+%2522Lux%2522+WHERE+(%2522entity_id%2522+%253D+'salon_lux')+AND+time+%253E%253D+now()+-+6h+GROUP+BY+time(30s)+fill(previous)%253BSELECT+mean(%2522value%2522)+FROM+%2522Lux%2522+WHERE+(%2522entity_id%2522+%253D+'cond_lux')+AND+time+%253E%253D+now()+-+6h+GROUP+BY+time(30s)+fill(previous)%253BSELECT+mean(%2522value%2522)+FROM+%2522lx%2522+WHERE+(%2522entity_id%2522+%253D+'apir_1_illuminance')+AND+time+%253E%253D+now()+-+6h+GROUP+BY+time(30s)+fill(previous)&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)

callap commented 4 years ago

As the supervisor is updated automatically (which can not been avoided as far as i know), this is pretty harmful.

Update Found the solution: Go to configuration--> data sources Change the query language to flux, click save (of course a error will occur, ignore it) Change the query language back to InfluxQL

Found here https://community.home-assistant.io/t/influx-and-grafana-issue/231707/5

Regards

SeByDocKy commented 4 years ago

As the supervisor is updated automatically (which can not been avoided as far as i know), this is pretty harmful.

Update Found the solution: Go to configuration--> data sources Change the query language to flux, click save (of course a error will occur, ignore it) Change the query language back to InfluxQL

Found here https://community.home-assistant.io/t/influx-and-grafana-issue/231707/5

Regards

Big thumbs !!!!!!

slavik73 commented 4 years ago

Thanks a lot. The workaround worked for me ;-)

bttfw commented 4 years ago

As the supervisor is updated automatically (which can not been avoided as far as i know), this is pretty harmful.

Update Found the solution: Go to configuration--> data sources Change the query language to flux, click save (of course a error will occur, ignore it) Change the query language back to InfluxQL

Found here https://community.home-assistant.io/t/influx-and-grafana-issue/231707/5

Regards

Thank you so much

github-actions[bot] commented 3 years ago

There hasn't been any activity on this issue recently, so we clean up some of the older and inactive issues. Please make sure to update to the latest version and check if that solves the issue. Let us know if that works for you by leaving a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thanks!