Questions with double summarisation not working anymore

Get Help
1

Hi,

I have the impression that since Metabase's latest update some of my questions are not working anymore. They were working perfectly fine before and now first show "Still Waiting..." before changing to an exclamation mark. The questions are quite basic and built using Metabase's question editor.

Everything seems to be working fine until I add the filter (which is a simple date filter).

Any clues ? Thanks !

image
image2492×1302 150 KB

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "os.name": "Linux",
    "os.version": "4.14.186-146.268.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "bigquery"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-02-19",
      "tag": "v1.38.0.1",
      "branch": "release-x.38.x",
      "hash": "0635914"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @anton1
Which version did you upgrade from?
Try upgrading to 1.38.1, which fixed several BigQuery issues:
https://github.com/metabase/metabase/releases/tag/v1.38.1
And check the logs for any errors - Admin > Troubleshooting > Logs.

3

Hi @flamber and thank you for your reply. It seems like I am not able to update to 1.38.1 from the admin panel (see screenshot). We are on the cloud based version so from my understanding updates are made automatically. Is there anyway the Metabase team can update us ? The thing is that I need those questions to get back working quite urgently.

What do you think ? Thanks !

image
image1110×422 21.6 KB

4

Regarding the logs, there is this error which seems to concern the column on which the filter is applied. But again it's strange because it worked perfectly fine before.

image
image3186×86 44.2 KB

5

@anton1 Upgrades are done in batches normally, but please go to https://store.metabase.com/support and contact support with a request to upgrade to 1.38.1 and please include which time would be convenient for the upgrade and your timezone.

There can be unrelated errors in the log, so ignore errors, which isn’t shown during the problem you’re testing.

6

Ok will do thanks !

Anton

7

Hi @flamber, we are about to migrate to 1.38.1 via the Metabase Store. However before doing that we just wanted to make sure that all our previous work is safe and that we do not need to make any backup of any sort (?)

Thanks for confirming

image
image1228×426 23.6 KB

8

@anton1 I think there’s a misunderstanding. The “Migration” is for migrating from self-hosted to Cloud, which will replace everything on Cloud with the data from the self-hosted.
Here you can see the steps as part of migration:
https://www.metabase.com/blog/migrating-to-metabase-cloud/index.html

“Upgrade” is not the same as “Migrate”.
Metabase Cloud will automatically do backups before upgrades and migrations.

9

Ok thanks for clarifying. Actually we are already on the cloud version. So if not through “migration”, how can we upgrade to 1.38.1 if we are running on the cloud ?

10

@anton1 I wrote that a couple of comments earlier:
Upgrades are done in batches normally, but please go to https://store.metabase.com/support and contact support with a request to upgrade to 1.38.1 and please include which time would be convenient for the upgrade and your timezone.

We cannot verify an account through the forum.

11

Ok got it thanks !