Grafana log error: "SHOW RETENTION POLICIES on

olliecampbell · June 15, 2023, 8:24am

Hi,

Just posting this here to see if the community might have any insight into this problem:

github.com/grafana/grafana

InfluxDB Datasource: Undefined identifier RETENTION and POLICIES after upgrading to Grafana 9.5.x

opened 02:42AM - 02 May 23 UTC

closed 01:01PM - 03 May 23 UTC

ikogan

datasource/InfluxDB

### # What went wrong? **What happened**: - Upgraded to Grafana 9.5.1 …from 9.4.x. - Have InfluxDB plugin configured to use Flux queries - Lots of error logs that look like this begin to appear: ``` logger=tsdb.influx_flux t=2023-05-02T02:34:47.392159245Z level=warn msg="Flux query failed" err="invalid: error @1:1-1:5: undefined identifier SHOW\n\nerror @1:6-1:15: undefined identifier RETENTION\n\nerror @1:16-1:24: undefined identifier POLICIES\n\nerror @1:25-1:27: undefined identifier on" query="SHOW RETENTION POLICIES on \"undefined\"" ``` - There doesn't seem to be any visible issues when actually using Grafana **What did you expect to happen**: - No repeated constant errors. ### # How do we reproduce it? I'm not 100% sure how to reproduce this but I believe the issue is that [this change](https://github.com/grafana/grafana/pull/66466) is applying to datasources using Flux on InfluxDB 2.x when it should only apply to InfluxQL on 1.x. If that's the case, the following steps should work: **Step 1**: Setup an InfluxDB 2.x instance. I'm currently using 2.7.0. **Step 2**: Setup Influx DB datasource using Flux as the query language. **Step 3**: Setup some dashboards from data in the datasource. **Step 4**: Observe errors in the log about retention policies. ### # What Grafana version are you using? v9.5.1 ### ## Optional Questions: ### Is the bug inside a Dashboard Panel? No, unless being in a query that a dashboard panel uses counts. ### Grafana Platform? Kubernetes ### User's OS? Ubuntu 22.04 ### User's Browser? Chrome Version 112.0.5615.165 (Official Build) (64-bit) ### Is this a Regression? Yes ### Are Datasources involved? InfluxDB 5.0.0 ### Anything else to add? _No response_

Thanks

olliecampbell · June 23, 2023, 12:59pm

This has now been resolved in v10.0.1

Topic		Replies	Views
"undefined identifier policies" warning after migration from Grafana OSS 9.4.3 to 9.5.1 InfluxDB	20	2030	June 19, 2023
Redundant queries made: SHOW RETENTION POLICIES Dashboards influxdb , influxql	8	351	September 25, 2023
Grafana browser query timeout InfluxDB influxdb , dashboard	11	4490	July 7, 2023
Influx/Grafana : Getting - InfluxDB Error: retention policy not found Grafana	2	7418	July 16, 2020
Query error with docker stack InfluxDB	0	1025	September 16, 2022

Grafana log error: "SHOW RETENTION POLICIES on

Related topics