What happened?
After updating my Grafana version from 10.1.5 to 10.2.0, my dashboards broke. I use InfluxDB + a MS SQL instance as data sources and this query works in the previous version, but in the new one I get nothing back:
My measurements name has a structure consisting in a customer name + underscore + a serial number. Something like “ABCDEFGH_123456789/001”. I suspect it has something to do with the forward slash “/” because this issue is not happening with measurements without a “/”. Any ideas?
grant2
November 11, 2023, 6:12pm
2
Hi @jonathanandresacaro
Does this match your problem?
opened 05:32PM - 31 Oct 23 UTC
### What happened?
After my upgrade from version 10.1.5 to version 10.2.0 tem… plate variables that contain IP address's are double escaped, as it they appear as 10\\.1\\.1\\.1 instead of 10\.1\.1\.1 I get bisected it down to this commit https://github.com/grafana/grafana/pull/75653
### What did you expect to happen?
That it works like in version 10.1.5 and variables not get double escaped.
### Did this work before?
Yes version 10.1.5
### How do we reproduce it?
1. Create variable that pulls information from InfluxDB via InfluxQL and the result is an IP address
select DISTINCT("vcenter") from (select "usage_average","vcenter" from "vsphere_host_cpu" WHERE $timeFilter)
2. Create second variable referencing the first
select DISTINCT("clustername") from (select "usage_average","clustername" from "vsphere_host_cpu" WHERE $timeFilter AND "vcenter" =~ /$vcenter/)
3. Won't probably pull the values as the $vcenter variable gets double escaped.
`http://someurl/query?db=somedatabase&q=select DISTINCT("clustername") from (select "usage_average","clustername" from "vsphere_host_cpu" WHERE time >= 1698751354270ms and time <= 1698772954270ms AND "vcenter" =~ /10\\.1\\.1\\.1/)&epoch=ms`
### Is the bug inside a dashboard panel?
_No response_
### Environment (with versions)?
Grafana: 10.2.0
OS: Arch Linux
Browser: Firefox 119
### Grafana platform?
A package manager (APT, YUM, BREW, etc.)
### Datasource(s)?
InfluxDB
It does! The solution provided there also works for me. Many thanks