Migrating from older version of grafana (v9.5.7 jail on TRUENAS Core) to newer version (V12.4.0 app on TRUENAS SCALE))

  • What Grafana version and what operating system are you using? Migrating from v9.5.7 to v12.4.0

  • What are you trying to achieve? Importing dashboard into v12.4.0 from V9.5.7

  • How are you trying to achieve it? share→export to JSON then import upload JSON

  • What happened? Sort of worked had various issues with databases which i fixed, however some of the gauge visualisations are not working FAIL instead of number. If I inspect the data behind the gauge it has a valid number.

  • What did you expect to happen? Expected the gauges to work okay after import

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

  • {

    “id”: 174,

    “type”: “gauge”,

    “title”: “LOFT TEMPERATURE”,

    “gridPos”: {

    "x": 0,
    
    "y": 5,
    
    "h": 5,
    
    "w": 2
    

    },

    “fieldConfig”: {

    "defaults": {
    
      "mappings": \[\],
    
      "thresholds": {
    
        "mode": "absolute",
    
        "steps": \[
    
          {
    
            "color": "blue",
    
            "value": null
    
          },
    
          {
    
            "color": "green",
    
            "value": 18
    
          },
    
          {
    
            "color": "red",
    
            "value": 21
    
          }
    
        \]
    
      },
    
      "color": {
    
        "mode": "thresholds"
    
      },
    
      "max": 30,
    
      "min": -5,
    
      "noValue": "FAIL",
    
      "unit": "celsius"
    
    },
    
    "overrides": \[\]
    

    },

    “pluginVersion”: “12.4.0”,

    “targets”: [

    {
    
      "datasource": {
    
        "type": "influxdb",
    
        "uid": "effheouhuwtmoe"
    
      },
    
      "groupBy": \[\],
    
      "measurement": "home/room/loft/temp",
    
      "orderByTime": "ASC",
    
      "policy": "autogen",
    
      "refId": "A",
    
      "resultFormat": "table",
    
      "select": \[
    
        \[
    
          {
    
            "params": \[
    
              "value"
    
            \],
    
            "type": "field"
    
          }
    
        \]
    
      \],
    
      "tags": \[\]
    
    }
    

    ],

    “datasource”: {

    "type": "influxdb",
    
    "uid": "effheouhuwtmoe"
    

    },

    “interval”: “1m”,

    “options”: {

    "reduceOptions": {
    
      "values": false,
    
      "calcs": \[
    
        "lastNotNull"
    
      \],
    
      "fields": ""
    
    },
    
    "orientation": "auto",
    
    "showThresholdLabels": true,
    
    "showThresholdMarkers": true,
    
    "sizing": "auto",
    
    "minVizWidth": 75,
    
    "minVizHeight": 75
    

    }

    }

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

  • Did you follow any online instructions? If so, what is the URL? No

  • I have started going through the changelogs between v9.5.7 and v12.4.0 but it is a lot to wade through

How many dashboards do you have are you using the default sqlite backend for grafana?

Hi,

I only have one dashboard at present and i am pulling data from influxdb.

rest of the install is vanilla

1 Like

I would upgrade one full version at a time

9, 10, 11, 12

Also you reuse the same grafana.db in the data folder to migrate without have to export and import json dashboard

okay i will ty the step by step upgrade if i can figure out how on TRUENAS scale apps.

To clarify, i still have the TRUENAS CORE grafana running v9.5.7 in parallel

okay so i found the issue.

In my v9.5.7 gauge visualisation which worked,

under gauge panel options,

under fields, The dropdown was selected to “numeric fields”

to get V12.4.0 to work I had to change

“Numeric fields”

to

“value”

just in case anyone was interested

1 Like