Error saving question against Sample Database: value may be nil, or if non-nil, value must be an array of valid results column metadata maps

Get Help
1

Hello, after recently redeploying metabase through Docker I am unable to save new questions (including against the sample database). I am able to view existing dashboards and create new users.

image
image2064×1048 250 KB

Here is the error I am seeing

{
"errors": {
"result_metadata": "value may be nil, or if non-nil, value must be an array of valid results column metadata maps."
}
}

Our metabase service is backed by Postgres.

I tried rescanning the database. I am a relatively new user so not sure what to try next. Thanks!

2

Hi @alana
Please post “Diagnostic Info” from Admin > Troubleshooting.
And check the log for more detailed error - Admin > Troubleshooting > Logs.

3

Here are details from the log

[37a6c970-0364-4ce0-a1a6-dc56f4a4c954] 2020-12-23T08:01:20-08:00 ERROR metabase.sync.analyze.query-results Error generating insights for column: {:description The street address of the account’s billing address, :table_id 3, :special_type nil, :name ADDRESS, :settings nil, :source :fields, :field_ref [:field-id 21], :parent_id nil, :id 21, :visibility_type :normal, :display_name Address, :fingerprint {:global {:distinct-count 2490, :nil% 0.0}, :type {:type/Text {:percent-json 0.0, :percent-url 0.0, :percent-email 0.0, :percent-state 0.0, :average-length 20.85}}}, :base_type :type/Text}

...

[37a6c970-0364-4ce0-a1a6-dc56f4a4c954] 2020-12-23T08:01:29-08:00 DEBUG metabase.middleware.log POST /api/card 400 2.2 ms (0 DB calls)  {:errors {:result_metadata "value may be nil, or if non-nil, value must be an array of valid results column metadata maps."}}  

[37a6c970-0364-4ce0-a1a6-dc56f4a4c954] 2020-12-23T08:01:33-08:00 DEBUG metabase.middleware.log POST /api/dataset 400 744.7 µs (0 DB calls)  {:errors {:database "value must be an integer."}}

and the Diagnostic Info

{
  "browser-info": {
    "language": "en",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15",
    "vendor": "Apple Computer, Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.8+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.8",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.8+10",
    "os.name": "Linux",
    "os.version": "5.0.0-1036-azure",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "10.15 (Ubuntu 10.15-0ubuntu0.18.04.1)"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-08-04",
      "tag": "v0.36.3",
      "branch": "release-0.36.x",
      "hash": "a792f14"
    },
    "settings": {
      "report-timezone": "US/Pacific"
    }
  }
}
4

@alana Try upgrading to latest release, 0.37.4 - remember to backup first.

And make sure that you are not using a reverse-proxy that is filtering the requests:
https://www.metabase.com/docs/latest/troubleshooting-guide/proxies.html

I cannot reproduce, so if you are still experiencing this after upgrade, then please provide exact steps to reproduce (users, groups, permissions etc).

5

Thanks @flamber! The upgrade fixed the issue, at least for now. Thanks for the quick response, that was awesome. :clap: