paveldanilin / grafana-csv-plugin

CSV datasource for Grafana 6.x.x / 7.x.x
MIT License
36 stars 12 forks source link

Query throwing error after adding DS successfully #18

Closed Jithu2015 closed 4 years ago

Jithu2015 commented 4 years ago

We have the DS as Linux local file, permissions all looks good. We have added the linux distribution to the plugin directory already, not sure what is wrong.

Error: Logs just shows 400error and nothing else

Logs: t=2020-06-30T01:04:03-0400 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/tsdb/query status=400 remote_addr=XX.XX.XX.XXX time_ms=32 size=293 referer="http://XXXXXXXXXXXXXXXX:3000/d/xLK9PiMGz/hsm-dashboard?inspect=23763571993&inspectTab=query&editPanel=2&tab=error&orgId=1"

image

Plugin Dir:

image

I can see my CSV contents in explore, but not executing the query.

image

If i run query, it throws error.

image

DS Details:

image

Grafana Version: 7.0.3

paveldanilin commented 4 years ago

@Jithu2015 are you using win platform?

Jithu2015 commented 4 years ago

@Jithu2015 are you using win platform?

Initially tested in windows, but we wanted to move it to Linux VM. We have the grafana installation there. The above error is in Linux issue.

paveldanilin commented 4 years ago

Sorry, I missed it. Could you download again executable from develop branch and try it? I updated executable a couple of hours ago.

Jithu2015 commented 4 years ago

Is it the same file from 1.0.0 branch or updated one? becasue i have moved them from 1.0.0 branch and tried after that only DS was added successfully.

No issues. i can try again as well.

paveldanilin commented 4 years ago

No, they are different

paveldanilin commented 4 years ago

By the way, 1.0.0 and 1.1.0 versions do not support SQL, they use an expression library for filtering. I am currently working on new version 2.0.0 (the latest code in develop branch) and that version does support SQL.

Jithu2015 commented 4 years ago

Yeah that was the issue bro, i downloaded the latest one and tried and its working fine now :)

image