Flight SQL Connection to InfluxDB v2.7.9 Failing with "frame too large" Error

Grafana Data Links
1

Hi everyone,

I’m facing an issue trying to connect InfluxDB (v2.7.5) to the Flight SQL plugin in Grafana. Even during the initial connection setup, I’m getting the following error:

ERROR: flightsql: rpc error: code = Unavailable desc = connection error: desc = "error reading server preface: http2: frame too large"

I’ve already tried the following:

  • Double-checked my Flight SQL plugin configuration to ensure the connection details are correct.(i have already connected influxdb alone already and i have removed if in any ocassion was causing the problem)
  • Verified that my InfluxDB and Flight SQL versions are up-to-date.
  • Temporarily disabled other plugins and configurations in Grafana and InfluxDB.
  • Checked my network configuration (firewall, proxy) and Docker network setup.(same docker network etc.)

I’m not performing any large data uploads or complex queries at this point; I’m simply trying to establish the initial connection.

Here are some additional details about my setup:

  • InfluxDB version: 2.7.9
  • Flight SQL version: doesnt mention it anywhere im just adding it so its up to date.
  • Grafana version: Grafana v11.1.3 (da5a557b6e)
  • Deployment: InfluxDB is running in a Docker container.As grafana and all my applications.

I’d appreciate any insights or suggestions on how to resolve this issue. Has anyone else encountered a similar problem?

All this is really needed for me cause i cant writing query to make my graphs on grafana,i used to have a “query builder” that old influx had and someone mentioned that this plug in Will do the job.

Thanks in advance for your help!

2

Welcome @stefos941 to the Grafana forum.

InfluxDB OSS v2.7.5 does not support SQL queries. SQL queries are currently only available on InfluxDB v3.

Furthermore, the FlightSQL tool was originally needed because Grafana needed a way to interact with the SQL database. In Jan 2024, Grafana integrated it and now, when setting up your InfluxDB v3 data source, there should be a prompt for the SQL query language. In the past it was just Flux or InfluxQL, but now there should be an option for SQL.

Full instructions here: Grafana Unleashes Official InfluxDB V3 Data Source: A Quick-start Guide to Configuration and Usage | InfluxData

Can you (at least temporarily) set up InfluxDB v3 (Cloud) and try to connect Grafana to it? There

3

I dont know why i miss spelled on the first sentence but my version is of influx is 2.7.9,Is there a version 3 because i just update it and i went from 2.7.5 to 2.7.9? I assume for the big changes there is not an easy way to upgrade.
If i get it clear there is a Query builder “like” the older versions of grafana in the (v3) influx ? im confused.

4

You are not the only one to be confused. The product matrix for InfluxDB is confusing, as are the permissible query languages for each version.

Influx v2.x only supports InfluxQL or Flux. Influx v2.x is an OSS (locally installed) product and free. There is no upgrade path to move from v2 to v3.
Influx v3 (currently Cloud only) natively uses SQL. There is a free Cloud version, but they cap you at the data usage. There is supposed to be a locally installed (free?) version of this product eventually. SQL queries are currently only available on InfluxDB v3.

Both versions above have the query builder, but IMO the v2 one is better / more robust.

2 Likes