Issues while migrating from Grafana v8.3.6 to latest(v9.1.6), especially from Elastic Search to OpenSearch

  • What Grafana version and what operating system are you using?
    We are currently using v8.3.6 in Ubuntu 20.04.4 LTS (Linux environment)

  • What are you trying to achieve?
    We are migrating to the latest grafana version v9.1.2.

  • How are you trying to achieve it?
    By following the same documentation where we take up the backup, copy-paste the current grafana.db file to the path /var/lib/grafana, update ini file.

  • What happened?
    We Can see the data on the Dashboard but when I go and try to edit the same, we get this issue

An unexpected error happened for EXISTING Dashboards.

TypeError: Cannot read properties of undefined (reading ‘label’)
at Fn (https://grafana-mumbai.coinswitch.co/public/plugins/grafana-opensearch-datasource/module.js:2:151059) at div at div at div at du …

  • What did you expect to happen?
    I was expecting this migration to run smoothly.

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

{
  "id": 6,
  "gridPos": {
    "h": 9,
    "w": 12,
    "x": 0,
    "y": 8
  },
  "type": "graph",
  "title": "Low logs on 1box",
  "alert": {
    "alertRuleTags": {},
    "conditions": [
      {
        "evaluator": {
          "params": [
            5
          ],
          "type": "lt"
        },
        "operator": {
          "type": "and"
        },
        "query": {
          "params": [
            "A",
            "2m",
            "now"
          ]
        },
        "reducer": {
          "params": [],
          "type": "sum"
        },
        "type": "query"
      }
    ],
    "executionErrorState": "alerting",
    "for": "0m",
    "frequency": "60s",
    "handler": 1,
    "name": "Low logs on 1box alert",
    "noDataState": "no_data",
    "notifications": [
      {
        "id": 4
      }
    ]
  },
  "datasource": {
    "type": "elasticsearch",
    "uid": "000000030"
  },
  "thresholds": [
    {
      "value": 5,
      "op": "lt",
      "visible": true,
      "fill": true,
      "line": true,
      "colorMode": "critical"
    }
  ],
  "pluginVersion": "9.1.6",
  "description": "Check if 1box traffic is disabled or not. It could be because of low peak hours as well",
  "links": [],
  "legend": {
    "avg": false,
    "current": false,
    "max": false,
    "min": false,
    "show": true,
    "total": false,
    "values": false
  },
  "aliasColors": {},
  "bars": false,
  "dashLength": 10,
  "dashes": false,
  "fill": 1,
  "fillGradient": 0,
  "hiddenSeries": false,
  "lines": true,
  "linewidth": 1,
  "nullPointMode": "null",
  "options": {
    "alertThreshold": true
  },
  "percentage": false,
  "pointradius": 5,
  "points": false,
  "renderer": "flot",
  "seriesOverrides": [],
  "spaceLength": 10,
  "stack": false,
  "steppedLine": false,
  "targets": [
    {
      "bucketAggs": [
        {
          "field": "@timestamp",
          "id": "2",
          "settings": {
            "interval": "auto",
            "min_doc_count": 0,
            "trimEdges": 0
          },
          "type": "date_histogram"
        }
      ],
      "datasource": {
        "type": "elasticsearch",
        "uid": "000000030"
      },
      "metrics": [
        {
          "field": "select field",
          "id": "1",
          "type": "count"
        }
      ],
      "query": "\"1box\"",
      "refId": "A",
      "timeField": "@timestamp"
    }
  ],
  "timeRegions": [],
  "tooltip": {
    "shared": true,
    "sort": 0,
    "value_type": "individual"
  },
  "transparent": true,
  "xaxis": {
    "mode": "time",
    "show": true,
    "values": [],
    "name": null,
    "buckets": null
  },
  "yaxes": [
    {
      "format": "short",
      "logBase": 1,
      "show": true
    },
    {
      "format": "short",
      "logBase": 1,
      "show": true
    }
  ],
  "yaxis": {
    "align": false
  },
  "timeFrom": null,
  "timeShift": null
}
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
An unexpected error happened
Details
TypeError: Cannot read properties of undefined (reading 'label')

    at Fn (https://grafana-mumbai.coinswitch.co/public/plugins/grafana-opensearch-datasource/module.js:2:151059)
    at div
    at div
    at div

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

Please note

  1. When I create a new dashboard or a new panel in the existing dashboard, it is working very fine. So, I wanted help in how to migrate the json_data(that has elastic search data) that is stored in dashboard table that can smoothly work with Opensearch.
  2. When I tried to migrate from v8.3.6 to v9.1.6(latest), alerts are also not compatible. Can you throw some light here please?

Much appreciated!