Iâm pretty sure the issue is that youâve selected the Flux datasource, but your query is written in âlegacyâ InfluxQL. You should switch to the InfluxQL datasource.
Hello, Jorge here / The creator of those Dashboards.
My work has done for InfluxQL, meaning your telegraf output should save the data into that format, not buckets or anything in 2.0.
I would move all of this to the new way of doing things, but for now, use Influx 1.x and all will work as expected.
i am using Grafana * v8.4.0 and influx db 2.2.0
i have used flux query inside grafana.
inside influx db ,traffic occured properly but grafana side getting 1 error:-
âinvalid: compilation failed: error @1:12-1:19: string literal key count must have a value error @1:36-1:91: expected comma in property list, got REGEXEQ error @1:43-1:90: string literal key application must have a value error @1:57-1:90: invalid expression @1:89-1:90: â error @1:57-1:90: unexpected token for property key: REGEXEQ (=~) error @1:96-1:97: invalid statement: $ error @1:122-1:124: unexpected token for property key: DURATION (5s)â
SELECT sum(âcountâ) FROM âjmeterâ WHERE (âapplicationâ =~ /^$/ AND âtransactionâ = âallâ) AND $timeFilter GROUP BY time(5s) fill(null)
Hello, I was hoping Jorge or some one could provide some direction. I am receiving the same error. I can make the vmware vshpere - overview dashboard work. My Grafana is version 8.1.8 and my influx version is 2.0.7. The query language in the datasource configuration is Flux. When I try and import version 41 of overview it errors. I choose my datasource as I import the dashboard but it doesnât connect to the datasource. If I then go through and edit each gauge and change the datasource to the correct datasource, the gauge will start working. So I can get that to work. When I try and import the vsphere -VMs or the - Datastore, or the - Hosts in each case selecting the 8.x and influx db 2.0 revision (such as revision 19 for vsphere - Hosts ) I get several errors: Failed to upgrade legacy queries e.replace is not a function. or Error updating options: e.replace is not a function. Then if I edit one of the gauges, it has the right bucket/datasource. If I exit that and click Explore for the gauge, I get invalid: compilation failed: error at @6:44-6:59: regex parse error: ${esxi:regex} error: repetition quantifier expects a valid decimal .
This thread suggests that the fix is to build a grafana system with influx version 1.8. But these vSphere dashboards explicitly now say they are built to use the flux language and Influx 2.0+. What am I missing here? What can I do to work around my problem?
Sorry, I didnât explain correctly. When I try and import vSphere - VMs , vSphere - Hosts, vSphere - Datastore setting the datastore as I import, I do have to go in and edit each gauge and set the datasource changing from [object] - not found to the correct datasource. But even after that I still have variable errors upon load of the dashboard or explore of the gauge.
I have also found that I can edit the variables and set the influx data source for each variable. This gets rid of the errors when you load the dashboard, but then each set of gauges (hundreds of them) still needs the data source fixed for each instance. And even then those gauges donât work after fixing the data source because of the repetition quantifier error (mentioned above) when I click explore on that gauge.
My entire issue seems to revolve around v.defaultbucket variable. I have the default bucket set in the datasource config. It is set and spelled correctly as best I can determine. The InfluxDB data source tests successfully with green check mark.