Error after update to 0.42.1

herrsiqueira · February 25, 2022, 9:51pm

Hello @flamber,

I got the error bellow after updated to version 0.42.1. Do you have any idea what happened?

herrsiqueira · February 25, 2022, 10:13pm

now after we back to version 0.41.1 some dataset ID are with same name

flamber · February 26, 2022, 5:04pm

Hi @herrsiqueira

Post "Diagnostic Info" from Admin > Troubleshooting.
Post which database type you are querying
Post what you are doing. I have absolutely not context with those tiny screenshots.
Post the full stacktrace from Admin > Troubleshooting > Logs - not a screenshot.

herrsiqueira · February 26, 2022, 9:56pm

Hi @flamber,
First screenshot appers when I tryed to acess any database after update to 0.42.1, the erros appers and I cant do anything.

The second screenshot is after I dowgraded to 0.41.1 all BQ database I have connected in Metabase had the database Id changed to toucanSightings.

herrsiqueira · February 26, 2022, 9:58pm

{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.12+7",
"java.vendor": "Eclipse Foundation",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.12",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.12+7",
"os.name": "Linux",
"os.version": "5.4.0-1044-gke",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"postgres",
"googleanalytics",
"mysql",
"bigquery-cloud-sdk",
"redshift"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "9.6.24"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2021-10-21",
"tag": "v0.41.1",
"branch": "release-x.41.x",
"hash": "76aa4a5"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
}
}
}

flamber · February 27, 2022, 9:17am

@herrsiqueira You should absolutely not be using 0.41.1. Use 0.41.6 or newer.

Metabase does not support downgrading, so you need to revert to your backup before upgrading.
Since 0.42 supports multiple datasets, then downgrading will only support a single dataset. The dataset ID has not been changed to "toucanSightings", that's a placeholder, the field is empty.

You have duplicates in the Metabase application database table metabase_table, specifically check all rows with db_id=95

herrsiqueira · February 28, 2022, 3:20pm

thanks @flamber

I will upgrade to 0.41.6. Now I got those kind of error

, but my databaseID is zendesk. All database from BQ have the same error when I saw an old dashboard.

flamber · February 28, 2022, 3:54pm

@herrsiqueira But you have not reverted to your backup from before you upgraded. Do that. If you don't have a backup, then upgrade to 0.42.1

And remove the "Project ID (override)", which I'm guessing you have.