Invalid: compilation failed: error at :@xx:xx-xx:xx expected comma in property list, got LPAREN

I am trying to use grafana + influxdb + telegraf to monitor my vCenter 6.5 and 7.0 platform.
Using the latest version of all these products:

grafana: v7.5.4
influxdb: 2.0.4
telegraf: 1.18.1

I can see data in the influxDB but grafana is unable to load the data and giving the following error:

invalid: compilation failed: error at :@xx:xx-xx:xx expected comma in property list, got LPAREN

This seems like a bug with grafana and its unable to query the data.
My datasource has been configured correctly:

Any chance you can show us the query? Kind of hard to say much without it.

Please find the query for various objects in the overview page:

If I am trying to query the same in the influxdb, getting the same error:

But if I am selecting the bucket, I can see the correct data in it:

So not sure where its going wrong.

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.

1 Like

Initially I was also suspected that but its not allowing me to use InfluxQL. Its giving bad gateway error.

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.

1 Like

Thank you @jorgedelacruz and @svetb

After using InfluxDB 1.8, I am able to configure data source with InfluxQL language.
Now things are working well and able to see the data.

Waiting for your update on Flux query in the near future :slight_smile:

Ah yeah good point - I forgot that Influx 2.0 doesn’t (yet) support InfluxQL. Anyway, great to hear you got it sorted :+1:

i have downloaded 1.8.10 version influx db . but i cant able to open through chrome.Could you guide me plz??

Welcome

What OS have you downloaded it to and have you installed it?

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)”

Thanks,
Yazhdevi S

i am using 64 bit .
Thanks,
Yazhdevi

what operating system are you running this in? Windows,Linux?
Also what is the query you are using in grafana that is erroring.

We dont have access to your computer so we cannot see :wink:

The more clearer details you give the easier for us to help you. Help us help you.

This integration new to me :expressionless: .

i am using Windows .

SELECT sum(“count”) FROM “jmeter” WHERE (“application” =~ /^$/ AND “transaction” = ‘all’) AND $timeFilter GROUP BY time(5s) fill(null)

Thanks,
Yazhdevi S

Hi Yosiasz,
which query exactly u want ?? i already posted query ,if thats wrong ,dont scold me .can you tell me little briefly, which one u want.

can you asnswer quickly please .
one more question :-1: i have downloaded 2 grafana ,how can i open 2 version of grafana through chrome ??

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?

Operating System is Linux Ubuntu 20.04.

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.