Mixed Datasource Query Aborted Error

Grafana Configuration
,
1

  • What Grafana version and what operating system are you using?
    Grafana v10.2.2 (161e3cac5075540918e3a39004f2364ad104d5bb)

  • What are you trying to achieve?
    We’re trying to write a dashboard panel that queries two different Amazon Athena datasources and then merges the results using the “Merge” transform

  • How are you trying to achieve it?
    We can demonstrate our issue using simple queries such as this:

    • Query A: SELECT 'Hello world a' from Athena Datasource A
    • Query B: SELECT 'Hello world b' from Athena Datasource B
      More complex queries show the same behavior.

  • What happened?
    Only query B returns and shows its results, and this error is displayed:
    Status: -1. Message: Query error: -1 Request was aborted

  • What did you expect to happen?
    We expect to see both queries succeed.
    NOTE: If we disable query B, query A succeeds. We can then reenable query B and both queries will succeed. However if we refresh the query with both enabled, then the error occurs again.

  • Can you copy/paste the configuration(s) that you are having problems with?
    Here is the json for the panel in question:

{
  "datasource": {
    "uid": "-- Mixed --",
    "type": "datasource"
  },
  "fieldConfig": {
    "defaults": {
      "custom": {
        "align": "auto",
        "cellOptions": {
          "type": "auto"
        },
        "inspect": false
      },
      "mappings": [],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "green",
            "value": null
          },
          {
            "color": "red",
            "value": 80
          }
        ]
      },
      "color": {
        "mode": "thresholds"
      }
    },
    "overrides": [
      {
        "matcher": {
          "id": "byName",
          "options": "data_catalog_link"
        },
        "properties": [
          {
            "id": "links",
            "value": [
              {
                "title": "${__data.fields.data_catalog_link:raw}",
                "url": "${__data.fields.data_catalog_link:raw}"
              }
            ]
          }
        ]
      },
      {
        "matcher": {
          "id": "byName",
          "options": "foxglove_link"
        },
        "properties": [
          {
            "id": "links",
            "value": [
              {
                "title": "${__data.fields.data_catalog_link:raw}",
                "url": "${__data.fields.data_catalog_link:raw}"
              }
            ]
          }
        ]
      },
      {
        "matcher": {
          "id": "byName",
          "options": "trrc_link"
        },
        "properties": [
          {
            "id": "links",
            "value": [
              {
                "title": "${__data.fields.data_catalog_link:raw}",
                "url": "${__data.fields.data_catalog_link:raw}\n\n"
              }
            ]
          }
        ]
      }
    ]
  },
  "gridPos": {
    "h": 15,
    "w": 23,
    "x": 0,
    "y": 15
  },
  "id": 2,
  "options": {
    "showHeader": true,
    "cellHeight": "sm",
    "footer": {
      "show": false,
      "reducer": [
        "sum"
      ],
      "countRows": false,
      "fields": ""
    },
    "frameIndex": 1
  },
  "pluginVersion": "10.2.2",
  "targets": [
    {
      "datasource": {
        "type": "grafana-athena-datasource",
        "uid": "<datasource_A>"
      },
      "connectionArgs": {
        "catalog": "__default",
        "database": "__default",
        "region": "__default",
        "resultReuseEnabled": false,
        "resultReuseMaxAgeInMinutes": 60
      },
      "format": 1,
      "hide": false,
      "rawSQL": "SELECT 'Hello world a'\n\n",
      "refId": "A"
    },
    {
      "format": 1,
      "rawSQL": "SELECT 'hello world b'",
      "connectionArgs": {
        "region": "__default",
        "catalog": "__default",
        "database": "athena_b",
        "resultReuseEnabled": false,
        "resultReuseMaxAgeInMinutes": 60
      },
      "datasource": {
        "type": "grafana-athena-datasource",
        "uid": "<datasource_b>"
      },
      "hide": false,
      "refId": "B"
    }
  ],
  "title": "Panel Title",
  "transformations": [
    {
      "id": "merge",
      "options": {}
    }
  ],
  "type": "table"
}
2

Try the query inspector and see what that says?