Dashboards in Metabase Collection Losing Linked Questions Without Trace

Hello Community,

We are experiencing a critical issue in Metabase. Below is a detailed description of the problem:

Issue Description:
In a specific collection within Metabase, all dashboards have unexpectedly lost their linked questions. This has significantly impacted the functionality and integrity of the dashboards.

Affected Components:

  • Dashboards: The issue is confined to dashboards within a particular collection. All dashboards in this collection are affected. (Thankfully, it was our internal BI collection, for the time being…)
  • Questions: The questions linked to these dashboards have been unlinked. These questions are neither archived nor deleted; they simply no longer appear in the dashboards.

Database Sources Involved:
The problem involves questions created from two different databases:

  • Snowflake
  • PostgreSQL

Observations:

  • Dashboard History: There are no recent edits in the dashboard history, indicating that the unlinking of questions occurred without any logged modifications.
  • Logs and API Calls: We have checked the logs and, after the last confirmed viewing of the full dashboard, there are no logs or API calls mentioning the dashboard ID, the questions that were unlinked, or the dashcard IDs. This was confirmed by examining one dashboard in detail.
  • Database Inconsistencies: No relevant rows were found in the Report Dashboardcard table. Additionally, searching for the affected dashcard IDs yields no results.
  • Text Boxes: Interestingly, text boxes within these dashboards were not affected.

Scope:
As far as I am aware, this issue has not impacted any other collections or dashboards outside the affected collection.

If anyone has experienced a similar issue or has knowledge about potential causes or solutions, your input would be invaluable. I am also concerned about the possibility of this being a broader bug within Metabase that could affect others. Any insights into the nature of this issue and its potential scope would be greatly appreciated.

Thank you in advance for your assistance and support in this matter.

Diagnostic Info

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.20.1+1",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.20.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.20.1+1",
    "os.name": "Linux",
    "os.version": "5.15.108",
    "user.language": "en",
    "user.timezone": "UTC"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "snowflake"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.19"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.4"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-09-18",
      "tag": "v0.47.2",
      "branch": "release-x.47.x",
      "hash": "536c24c"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

hi, please upgrade to the latest version, we saw this issue in some customers, but all questions kept working fine

Thanks Luis!

Indeed, we are planning to update; that was one us, we just neglected and we were waiting for 48

But If I understand correctly, this is not an identified issue that is patched in the following versions, so there is no guarantee that it will not happen again ( this is important in terms of stakeholder expectation management ).

I am not sure I am following up here

but all questions kept working fine

Indeed, no question is corrupted, and everything works fine in terms of questions. It's just that they disappeared from the dashboards and rendered them useless.