Skip to content
This repository has been archived by the owner on Dec 11, 2020. It is now read-only.

InfluxDB 1.8 does no longer work since updating to grafana and plugin to 7.0 #101

Closed
disaster123 opened this issue May 20, 2020 · 29 comments

Comments

@disaster123
Copy link

While using this with Grafana 6 worked fine. It stopped working with Grafana 7 and plugin version 7.

Setting up the plugin now always fails with:

500 Internal Server Error: {"error":"panic: column retentionPeriod:int is not of type string"}
@lephisto
Copy link

Got the same issue, can't connect to the flux endpoint of a v1.x Influxdb.

@ryantxu
Copy link
Member

ryantxu commented May 20, 2020

Which version of influx? This is expected to work with 1.8+ and 2.0
https://github.com/influxdata/influxdb-client-go#influxdb-18-api-compatibility

@disaster123
Copy link
Author

Influx 1.8.0 here old plugin version works fine even with Grafana 7

@dsantaolalla
Copy link

dsantaolalla commented May 20, 2020

I have the same problem,

500 Internal Server Error: {"error":"panic: column retentionPeriod:int is not of type string"}

When using the following versions:

Grafana 7.0.0
Influxdb 1.8.0
influxdb-flux-datasource plugin 7.0.0

As a note, If I downgrade Influxdb and the plugin versions, works fine, the following combination:

Grafana 7.0.0
Influxdb 1.7.8
influxdb-flux-datasource plugin 5.4.1

@agolovenko
Copy link

same here

@germm
Copy link

germm commented May 23, 2020

i have the same problem

@jesjimher
Copy link

Same problem, flux doesn't work since update to v7, giving the same error.

@ext452
Copy link

ext452 commented May 26, 2020

same problem :(
grafana 7.0
influxdb 1.8.0
influxdb-flux-datasource plugin 7.0.0

@easthy-alterpost
Copy link

easthy-alterpost commented May 26, 2020

The same problem:
influxdb-1.8.0.x86_64
grafana-7.0.0-1.x86_64
Flux (InfluxDB) [BETA] v.7.0.0

@andig
Copy link

andig commented May 31, 2020

Sorry for the confusion. Same problem with #107

Working:
Grafana 6.4
Flux 5.4.1

Broken:
Grafana 7.0
Flux 7.0

Both running against InfluxDB 1.8.4 1.8.0

@andig
Copy link

andig commented Jun 2, 2020

I'm seeing this in the influxdb (v1.8.4 v1.8.0) logfile:

[httpd] 172.22.0.1 - - [02/Jun/2020:11:46:29 +0000] "GET /health HTTP/1.1" 200 106 "-" "influxdb-client-go/1.1.0  (linux; amd64)" b284b207-a4c6-11ea-859b-0242ac160002 21098
ts=2020-06-02T11:46:29.696143Z lvl=info msg="Execute source panic" log_id=0N0wkt60000 error="panic: column retentionPeriod:int is not of type string"

I cannot find the "Execute source panic" in either influxdb (1.8 branch), influxdb-client-go (master) nor grafana's influxdb-flux-datasource (master).

@andig
Copy link

andig commented Jun 2, 2020

The actual error message is in https://github.com/influxdata/influxdb/blob/1.8/patches/flux.patch#L1816 and has since been removed.

/cc @jsternberg who has upgraded flux in influxdata/influxdb@636a27e

@scurvy-dog
Copy link

Encountered the same error today when setting up a Flux datasource today. Datasource works fine in Chronograf with specifying the influx host with no authentication.

Grafana 7.0.1
Influx 1.8
Flux 7.0

@andig
Copy link

andig commented Jun 13, 2020

ping @jsternberg- this is still an issue:

Screenshot 2020-06-13 at 12 09 02

@korre73
Copy link

korre73 commented Jun 15, 2020

Same Problem on

Grafana 7.0.3
Influx 1.8.0
Flux 7.0

The Topic there "old Version works" means Flux 5.4.1 ???

How can i downgrade to this version????

@dsantaolalla
Copy link

dsantaolalla commented Jun 16, 2020

@korre73 you can downgrade with running the following where your grafana is running:

Uninstall first:
grafana-cli plugins uninstall grafana-influxdb-flux-datasource

Then install the specific version 5.4.1
grafana-cli plugins install grafana-influxdb-flux-datasource 5.4.1

@jesjimher
Copy link

But will old version work with Grafana 7? Plugin documentation seems to state that latest works with Grafana 7, and 5.4.1 works with Grafana 6.

@disaster123
Copy link
Author

Yes it does i'm stil using 5.4.1 since weeks with grafana 7

@andig
Copy link

andig commented Jun 29, 2020

I have given up on waiting for feedback and reverted to grafana 6.7.4 as 7.0.4 fix flux has become totally useless for me.

@lephisto
Copy link

Still not working with Grafana 7.1... are there any intentions to get Flux working again? I'm stuck with 6.7.4 on projects that require fluxlang..

@dswarbrick
Copy link

dswarbrick commented Jul 16, 2020

@lephisto Grafana 7.1 has support for Flux built-in. This plugin is essentially obsolete now (for users of Grafana 7.1+).

When setting up an InfluxDB data source, you now have the option to specify InfluxQL or Flux query language.

Note: I found that I had to specify an Organization, despite the docs suggesting that it's not necessary with InfluxDB 1.8. It seems that it was more to make Grafana happy, than InfluxDB.

@CharlesGodwin
Copy link

@dswarbrick can you send me a creen shot of the config for a FLUX and influxdb 1.8 setup. I can't get mine to work. thanks

an example URL, organiziation (how do I get that?) and Token

@ryantxu
Copy link
Member

ryantxu commented Jul 16, 2020

Check:
https://www.influxdata.com/blog/how-grafana-dashboard-influxdb-flux-influxql/

it looks like you need an empty org

@dswarbrick
Copy link

@CharlesGodwin The organization can be whatever - ACME Widgets, Inc., if you like.

The token is simply the concatenation of the InfluxDB 1.8 username and password, with a colon between, e.g. grafana:secretpw

@CharlesGodwin
Copy link

CharlesGodwin commented Jul 16, 2020 via email

@timhallinflux
Copy link

Now that Grafana 7.1 is out, the updated InfluxDB data source is much more straightforward to use and there is supporting documentation on the Grafana site and InfluxDB site as well. Let us know if there are still outstanding issues.

@andig
Copy link

andig commented Jul 17, 2020

Let us know if there are still outstanding issues.

@timhallinflux using 7.1 against Influx 1.8 datasource definition fails unless you define an organisation. Its also not obvious you need to define token as user:password. Both are without useful error message in the ui.

@jesjimher
Copy link

@timhallinflux using 7.1 against Influx 1.8 datasource definition fails unless you define an organisation. Its also not obvious you need to define token as user:password. Both are without useful error message in the ui.

In my case, it works just entering a random text as an organisation. Token may be left blank too, once you click Save/test it gets filled automatically.

@ryantxu
Copy link
Member

ryantxu commented Jul 17, 2020

See grafana/grafana#26397

random text in the org will work. We will improve that soon

@ryantxu ryantxu closed this as completed Jul 17, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests