Grafana dashboard panel error shows invalid interval string after major version upgrade

Written by - 0 comments

Published on - Listed in Monitoring Grafana Observability


After Grafana was upgraded to 12.0.2 from a previously installed 9.x version, some panels in dashboards showed an error icon.

Panel in Grafana dashboard showing error: invalid interval string

Panel error: Invalid interval string

In this particular example, the "Users logged in" panel showed an error icon and "No data". With the mouse hovering over the error icon, the following error message popped up:

Invalid interval string, has to be either unit-less or end with one of the following units: "y, M, w, d, h, m, s, ms"

I first suspected a problem with the "unit" setting of this panel, however it was set to a simple number. Changing the unit did not work either, no data was presented. The panel's (InfluxQL) query was verified multiple times - the fields did not change.

As the error mentioned time units, such as "y, M, w" etc, I also changed the time range at the top right - without a change in the panel.

What am I missing? Did I run into a bug of the new Grafana version?

Interval setting in the panel query options

A research for a particular bug ended indeed in Grafana issue #95320 on GitHub. However after reading through the comments it doesn't look like a bug - but rather an incompatible change in the newer version. 

Each panel has so-called "Query options". These options are rarely used and therefore collapsed. By expanding the query options, the different options need to be verified. 

In the case of my "Users logged in" panel, the "Min interval" option was set to a value of "> 20s". This worked in the previously installed Grafana version (9.2.4) but, according to comments in the mentioned issue, stopped working since Grafana 11.6.x. 

Now with the newest Grafana 12.0.2 installed, I emptied the "Min interval" completely (as it's actually not needed, at least not for this panel) and the data showed up immediately again. The panel is fixed! 

Grafana panel fixed after adjusting query options

With that knowledge added in the back of the head, the panel's previous error message now makes sense, too! The difficult part is just to find the missing link to the query options! 

The error comes as kind of a surprise, too. The breaking changes of v11 (on which the error was first reported) and v12 don't mention any major (behaviour) change of the interval units inside the panel query options.

Managed servers with fancy Grafana dashboards

If you were wondering, the screenshots of the four panels above was taken from a managed server dashboard, available for our managed servers customers at Infiniroot. Customers with multiple managed dedicated servers have access to a customized dashboard with live and historic data, showing the performance and usage of the servers. Besides server performance, the dashboards also show application responsiveness, database query spikes, blocked access and much more. 


Add a comment

Show form to leave a comment

Comments (newest first)

No comments yet.

RSS feed

Blog Tags:

  AWS   Android   Ansible   Apache   Apple   Atlassian   BSD   Backup   Bash   Bluecoat   CMS   Chef   Cloud   Coding   Consul   Containers   CouchDB   DB   DNS   Database   Databases   Docker   ELK   Elasticsearch   Filebeat   FreeBSD   Galera   Git   GlusterFS   Grafana   Graphics   HAProxy   HTML   Hacks   Hardware   Icinga   Influx   Internet   Java   KVM   Kibana   Kodi   Kubernetes   LVM   LXC   Linux   Logstash   Mac   Macintosh   Mail   MariaDB   Minio   MongoDB   Monitoring   Multimedia   MySQL   NFS   Nagios   Network   Nginx   OSSEC   OTRS   Observability   Office   OpenSearch   PGSQL   PHP   Perl   Personal   PostgreSQL   Postgres   PowerDNS   Proxmox   Proxy   Python   Rancher   Rant   Redis   Roundcube   SSL   Samba   Seafile   Security   Shell   SmartOS   Solaris   Surveillance   Systemd   TLS   Tomcat   Ubuntu   Unix   VMWare   VMware   Varnish   Virtualization   Windows   Wireless   Wordpress   Wyse   ZFS   Zoneminder