Error creating variable for dashboard after upgrade

Grafana
1

Good afternoon!

I upgraded to the latest version of grafana today and apparently broke some dashboards.

Whenever i try to load a dashboard with a variable i get the error

"Templating

Template variables could not be initialized: Invalid interval string, expecting a number followed by one of “Mwdhmsy”"

Capture
Capture693×228 16.3 KB

– EDIT –

The variable settings looks like this.

Capture1
Capture11099×714 32.3 KB

Any ideas of how to resolve this?

Best regards
Henrik

2

Downgraded back to previously installed version (5.2.1-1) and it works again.

All ideas to get this working on latest release are welcome.

3

Hey. What version was that? We just released v5.3.2.

4

The one that broke the variables was 5.3.2, installed today.

5

Cannot reproduce based on the screenshot you’ve shared. Could you please use chrome developer tools can check console for any errors plus if possible include your dashboard json model that is failing. Thanks

6

Console:

Capture2

JSON:

{
“annotations”: {
“list”: [
{
“builtIn”: 1,
“datasource”: “-- Grafana --”,
“enable”: true,
“hide”: true,
“iconColor”: “rgba(0, 211, 255, 1)”,
“name”: “Annotations & Alerts”,
“type”: “dashboard”
}
]
},
“editable”: true,
“gnetId”: null,
“graphTooltip”: 0,
“id”: 7,
“iteration”: 1540394453971,
“links”: ,
“panels”: [
{
“gridPos”: {
“h”: 1,
“w”: 24,
“x”: 0,
“y”: 0
},
“id”: 16,
“title”: “Row title”,
“type”: “row”
},
{
“aliasColors”: {},
“bars”: false,
“dashLength”: 10,
“dashes”: false,
“datasource”: “w-v-prometheus-1”,
“fill”: 1,
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 0,
“y”: 1
},
“id”: 12,
“interval”: “1s”,
“legend”: {
“avg”: false,
“current”: false,
“max”: false,
“min”: false,
“show”: true,
“total”: false,
“values”: false
},
“lines”: true,
“linewidth”: 1,
“links”: ,
“nullPointMode”: “null”,
“percentage”: false,
“pointradius”: 5,
“points”: false,
“renderer”: “flot”,
“seriesOverrides”: ,
“spaceLength”: 10,
“stack”: false,
“steppedLine”: false,
“targets”: [
{
“expr”: “jnxOperating1MinLoadAvg{instance=~"$switch",jnxOperatingContentsIndex="9",jnxOperatingL1Index="1",jnxOperatingL2Index="0",jnxOperatingL3Index="0",job=~"snmp"}”,
“format”: “time_series”,
“interval”: “1s”,
“intervalFactor”: 1,
“legendFormat”: “1min Load Avg”,
“refId”: “C”
},
{
“expr”: “jnxOperating5MinLoadAvg{instance=~"$switch",jnxOperatingContentsIndex="9",jnxOperatingL1Index="1",jnxOperatingL2Index="0",jnxOperatingL3Index="0",job=~"snmp"}”,
“format”: “time_series”,
“interval”: “1s”,
“intervalFactor”: 1,
“legendFormat”: “5min Load Avg”,
“refId”: “A”
},
{
“expr”: “jnxOperating15MinLoadAvg{instance=~"$switch",jnxOperatingContentsIndex="9",jnxOperatingL1Index="1",jnxOperatingL2Index="0",jnxOperatingL3Index="0",job=~"snmp"}”,
“format”: “time_series”,
“interval”: “1s”,
“intervalFactor”: 1,
“legendFormat”: “15min Load Avg”,
“refId”: “B”
}
],
“thresholds”: ,
“timeFrom”: null,
“timeShift”: null,
“title”: “$switch CPU Usage”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “individual”
},
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”:
},
“yaxes”: [
{
“format”: “percent”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: false,
“alignLevel”: null
}
},
{
“cacheTimeout”: null,
“colorBackground”: false,
“colorValue”: false,
“colors”: [
“#299c46”,
“rgba(237, 129, 40, 0.89)”,
“#d44a3a”
],
“datasource”: “w-v-prometheus-1”,
“format”: “timeticks”,
“gauge”: {
“maxValue”: 100,
“minValue”: 0,
“show”: false,
“thresholdLabels”: false,
“thresholdMarkers”: true
},
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 12,
“y”: 1
},
“id”: 14,
“interval”: “1s”,
“links”: ,
“mappingType”: 1,
“mappingTypes”: [
{
“name”: “value to text”,
“value”: 1
},
{
“name”: “range to text”,
“value”: 2
}
],
“maxDataPoints”: 100,
“nullPointMode”: “connected”,
“nullText”: null,
“postfix”: “”,
“postfixFontSize”: “50%”,
“prefix”: “”,
“prefixFontSize”: “50%”,
“rangeMaps”: [
{
“from”: “null”,
“text”: “N/A”,
“to”: “null”
}
],
“sparkline”: {
“fillColor”: “rgba(31, 118, 189, 0.18)”,
“full”: false,
“lineColor”: “rgb(31, 120, 193)”,
“show”: false
},
“tableColumn”: “”,
“targets”: [
{
“expr”: “jnxOperatingUpTime{instance=~"$switch",jnxOperatingContentsIndex="1",jnxOperatingL1Index="1",jnxOperatingL2Index="0",jnxOperatingL3Index="0",job=~"snmp"}”,
“format”: “time_series”,
“interval”: “”,
“intervalFactor”: 1,
“legendFormat”: “$switch Uptime”,
“refId”: “A”
}
],
“thresholds”: “”,
“title”: “$switch Uptime”,
“type”: “singlestat”,
“valueFontSize”: “80%”,
“valueMaps”: [
{
“op”: “=”,
“text”: “N/A”,
“value”: “null”
}
],
“valueName”: “avg”
},
{
“gridPos”: {
“h”: 1,
“w”: 24,
“x”: 0,
“y”: 10
},
“id”: 10,
“title”: “Row title”,
“type”: “row”
},
{
“aliasColors”: {},
“bars”: false,
“dashLength”: 10,
“dashes”: false,
“datasource”: “w-v-prometheus-1”,
“fill”: 1,
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 0,
“y”: 11
},
“id”: 2,
“interval”: “10s”,
“legend”: {
“avg”: false,
“current”: true,
“hideEmpty”: false,
“hideZero”: false,
“max”: true,
“min”: true,
“show”: true,
“total”: false,
“values”: true
},
“lines”: true,
“linewidth”: 1,
“links”: ,
“nullPointMode”: “null”,
“percentage”: false,
“pointradius”: 5,
“points”: false,
“renderer”: “flot”,
“seriesOverrides”: ,
“spaceLength”: 10,
“stack”: false,
“steppedLine”: false,
“targets”: [
{
“expr”: "jnxOperatingTemp{instance=~"$switch",jnxOperatingContentsIndex=~"7",jnxOperatingL1Index=~"1",jnxOperatingL2Index=~"0",jnxOperatingL3Index=~"0",job=~"snmp"} ",
“format”: “time_series”,
“hide”: false,
“instant”: false,
“interval”: “10s”,
“intervalFactor”: 1,
“legendFormat”: “$switch Temp1”,
“refId”: “A”
},
{
“expr”: "jnxOperatingTemp{instance=~"$switch",jnxOperatingContentsIndex=~"7",jnxOperatingL1Index=~"1",jnxOperatingL2Index=~"0",jnxOperatingL3Index=~"0",job=~"snmp"} ",
“format”: “time_series”,
“interval”: “10s”,
“intervalFactor”: 1,
“legendFormat”: “$switch Temp2”,
“refId”: “B”
}
],
“thresholds”: ,
“timeFrom”: null,
“timeShift”: null,
“title”: “Temperatures”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “individual”
},
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”:
},
“yaxes”: [
{
“format”: “celsius”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: false,
“alignLevel”: null
}
},
{
“cacheTimeout”: null,
“colorBackground”: true,
“colorValue”: false,
“colors”: [
“#299c46”,
“rgba(237, 129, 40, 0.89)”,
“#d44a3a”
],
“datasource”: “w-v-prometheus-1”,
“decimals”: 0,
“format”: “celsius”,
“gauge”: {
“maxValue”: 100,
“minValue”: 0,
“show”: false,
“thresholdLabels”: false,
“thresholdMarkers”: true
},
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 12,
“y”: 11
},
“id”: 4,
“interval”: “1s”,
“links”: ,
“mappingType”: 1,
“mappingTypes”: [
{
“name”: “value to text”,
“value”: 1
},
{
“name”: “range to text”,
“value”: 2
}
],
“maxDataPoints”: 100,
“nullPointMode”: “connected”,
“nullText”: null,
“postfix”: “”,
“postfixFontSize”: “50%”,
“prefix”: “”,
“prefixFontSize”: “50%”,
“rangeMaps”: [
{
“from”: “null”,
“text”: “N/A”,
“to”: “null”
}
],
“sparkline”: {
“fillColor”: “rgba(31, 118, 189, 0.18)”,
“full”: false,
“lineColor”: “rgb(31, 120, 193)”,
“show”: false
},
“tableColumn”: “”,
“targets”: [
{
“expr”: "jnxOperatingTemp{instance=~"$switch",jnxOperatingContentsIndex=~"7",jnxOperatingL1Index=~"1",jnxOperatingL2Index=~"0",jnxOperatingL3Index=~"0",job=~"snmp"} ",
“format”: “time_series”,
“interval”: “”,
“intervalFactor”: 1,
“legendFormat”: “$switch Temp”,
“refId”: “A”
}
],
“thresholds”: “50,60”,
“title”: “$switch Temp”,
“type”: “singlestat”,
“valueFontSize”: “80%”,
“valueMaps”: [
{
“op”: “=”,
“text”: “N/A”,
“value”: “null”
}
],
“valueName”: “current”
},
{
“columns”: ,
“datasource”: “w-v-prometheus-1”,
“fontSize”: “100%”,
“gridPos”: {
“h”: 16,
“w”: 24,
“x”: 0,
“y”: 20
},
“id”: 8,
“interval”: “1s”,
“links”: ,
“pageSize”: null,
“scroll”: true,
“showHeader”: true,
“sort”: {
“col”: 0,
“desc”: true
},
“styles”: [
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “name”,
“thresholds”: ,
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “instance”,
“thresholds”: ,
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “job”,
“thresholds”: ,
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “Time”,
“thresholds”: ,
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“decimals”: 0,
“pattern”: “/./",
“thresholds”: [],
“type”: “number”,
“unit”: “short”
}
],
“targets”: [
{
“expr”: “jnxOperatingDescr{instance=~"$switch",job=~"snmp"}”,
“format”: “table”,
“interval”: “1s”,
“intervalFactor”: 1,
“legendFormat”: “”,
“refId”: “A”
}
],
“timeFrom”: “1s”,
“timeShift”: null,
“title”: “$switch Operating Description”,
“transform”: “table”,
“type”: “table”
},
{
“collapsed”: false,
“gridPos”: {
“h”: 1,
“w”: 24,
“x”: 0,
“y”: 36
},
“id”: 6,
“panels”: [],
“title”: “Row title”,
“type”: “row”
},
{
“columns”: [],
“datasource”: “w-v-prometheus-1”,
“fontSize”: “100%”,
“gridPos”: {
“h”: 61,
“w”: 24,
“x”: 0,
“y”: 37
},
“hideTimeOverride”: false,
“id”: 18,
“interval”: “1s”,
“links”: [],
“pageSize”: 25,
“scroll”: true,
“showHeader”: true,
“sort”: {
“col”: 0,
“desc”: true
},
“styles”: [
{
“alias”: “Time”,
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“pattern”: “Time”,
“type”: “hidden”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “jnxVlanMacAddress”,
“sanitize”: true,
“thresholds”: [],
“type”: “string”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “instance”,
“thresholds”: [],
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “name”,
“thresholds”: [],
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “job”,
“thresholds”: [],
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“decimals”: 2,
“mappingType”: 1,
“pattern”: “Value”,
“thresholds”: [],
“type”: “hidden”,
“unit”: “short”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“decimals”: 2,
“pattern”: "/./”,
“thresholds”: ,
“type”: “number”,
“unit”: “short”
}
],
“targets”: [
{
“expr”: “jnxVlanMacAddress{instance=~"$switch",job=~"snmp"}”,
“format”: “table”,
“instant”: true,
“interval”: “1s”,
“intervalFactor”: 1,
“legendFormat”: “”,
“refId”: “A”
}
],
“timeFrom”: “1s”,
“timeShift”: null,
“title”: “Connected Mac-addresses $switch”,
“transform”: “table”,
“type”: “table”
}
],
“refresh”: “15m”,
“schemaVersion”: 16,
“style”: “dark”,
“tags”: ,
“templating”: {
“list”: [
{
“allValue”: null,
“current”: {
“isNone”: true,
“text”: “None”,
“value”: “”
},
“datasource”: “w-v-prometheus-1”,
“hide”: 0,
“includeAll”: false,
“label”: null,
“multi”: false,
“name”: “switch”,
“options”: ,
“query”: “up{job=~‘snmp’}”,
“refresh”: 1,
“regex”: “.instance="(.?)".*”,
“skipUrlSync”: false,
“sort”: 0,
“tagValuesQuery”: “”,
“tags”: ,
“tagsQuery”: “”,
“type”: “query”,
“useTags”: false
}
]
},
“time”: {
“from”: “now-6h”,
“to”: “now”
},
“timepicker”: {
“refresh_intervals”: [
“5s”,
“10s”,
“30s”,
“1m”,
“5m”,
“15m”,
“30m”,
“1h”,
“2h”,
“1d”
],
“time_options”: [
“5m”,
“15m”,
“1h”,
“6h”,
“12h”,
“24h”,
“2d”,
“7d”,
“30d”
]
},
“timezone”: “”,
“title”: “Switch status overview”,
“uid”: “AEsabbxmk”,
“version”: 20
}

7

Thanks. Still unable to replicate. Can you please share the full url in your browser when you receive this error. Thanks

8

http://w-v-grafana-0:3000/d/AEsabbxmk/switch-status-overview?editview=templating&refresh=15m&orgId=1&var-switch=w-d110005-a-7

tried on a new dashboard as well

http://w-v-grafanaclone-0:3000/dashboard/new?editview=templating&orgId=1&panelId=&fullscreen=&edit=

That’s the full url, going to try exporting the dashboard to another test-server and to see if i can replicate this.

Thanks

EDIT:

The query looks like this:

jnxOperating15MinLoadAvg{instance=~"$switch",jnxOperatingContentsIndex=“9”,jnxOperatingL1Index=“1”,jnxOperatingL2Index=“0”,jnxOperatingL3Index=“0”,job=~“snmp”}

10

I cannot access the links you’ve included. Based on your last post which you withdraw - did you resolve the problem?

If not, the query you’ve included is that what causing your problem? In general, I would recommend that you open a bug report on Grafana github repository if your problem isn’t resolved .

11

I actually ended up installing a fresh grafana on a new server with all the same settings which ended up working just fine. No idea as to why i got that error but it’s solved now anyhow.

Thank you for the help!

1 Like
12

Hello,
I got same issue.
Please refer: https://localhost:3000/t/grafana-with-influxdb-issues-with-choosing-fields-for-graph/6333/2?u=thachnv92
This is solution:
Go to Data Source config => change “Min time interval” to great than 60s

image
image1106×727 51.6 KB

Good luck ^^