Sudden error: "Query does not contain a valid source identifier"

Grafana InfluxDB
1

Hi all,

  • What Grafana version and what operating system are you using?

  • Grafana Cloud

  • What are you trying to achieve?

My dashboards were working perfectly for months. Now without changing anything, some panels are working and some are showing an error “Query does not contain a valid source identifier”… All panels use the same data source and have similar requests, just different display options.

  • How are you trying to achieve it?

To fix the panels that are not working, even though they worked 2 days back. All panels use the same datasource - InfluxDB (FlightSQL).

  • What happened?

No idea. It was working, then stopped working 2 days ago. I’ve attached a picture.

  • Can you copy/paste the configuration(s) that you are having problems with?

See pictures.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

In the panel title. Picture attached.

Grafana_error
Grafana_error1895×796 103 KB

2

These panels here all use FlightSQL queries and exhibited no issues when Grafana Cloud was updated. Can you share the queries for those panels that show the error?

3

Thanks for your reply Grant. Here is the code for 2 panels.
Panel 1 - Working - See Pic A
Datasource: Influx DB
SQL: Edited directly (Not using Builder view)
Code: SELECT time, energy_pos_balanced,serial FROM "Sensor Data" WHERE serial = '10000000ea20043b' and time BETWEEN '${__from:date:iso}' AND '${__to:date:iso}' ORDER BY time

Panel 2 - NOT Working - See Pic B
Datasource: Influx DB
SQL: Using Builder view
Code: SELECT time,energy_pos_1 FROM "Sensor Data" WHERE serial = '10000000ea20043b' and $__timeRange(time) ORDER BY time

The only difference between the SQL is ‘$__timeRange(time)’ - But ‘$__timeRange(time)’ has worked without issues since I started using Grafana and so I’m concluding there are no issues there.

I do notice that my main date picker has moved on the screen from it’s original position - Something I did not change.

Pic A:

grafana2a
grafana2a1416×721 56.4 KB

Pic B:

Grafana2_b
Grafana2_b1411×682 43.4 KB

4

Even though you are using FlightSQL, I wonder if this bug is related? I believe a patch is coming next week.

5

I don’t think they are related Grant. My issues does not co-incide with a release and when I hard code the date values like below, I still receive the no data error.

I have multiple dashboards, all mirrors of each other for different sites. They all replicated this error at the same time.

Should I report this Grafana bug team? Thanks for all your help.

SELECT time,energy_pos_balanced FROM "Sensor Data" WHERE serial = '10000000ea20043b' 
and time BETWEEN '2024-07-18T01:00:00Z' AND '2024-07-19T01:00:00Z'
ORDER BY time
6

From Grafana support. This might be useful for someone.

Hi,

Thank you for contacting Grafana Support.

We are aware of the issue you described, which was introduced by a bug in the latest release of our stable version on Monday. As a temporary workaround, we recommend switching from the steady version to the slow version.
I have already implemented this change on our end, so your panels should now be available again. Please let us know if they are not working however.

Please note that this is a temporary fix. Our engineering team is actively working on a permanent solution, and I will keep you updated on their progress. Once the fix is ready, I will revert your instance back to the steady version.

I apologize for any inconvenience this has caused.

2 Likes