Version 0.40 is here — let us know what you think

News and Announcements
1

We just released version 0.40, with a vastly improved dashboard creation and editing experience, easier data selection, and a more intuitive flow for using SQL results as starting data for new questions.

Enterprise version 1.40 additionally adds new Audit tools to help you find frequently-used queries that could use optimization, and major improvements to the serialization feature.

As always, if you're self-hosting and upgrading from a previous version, make sure to make a backup of your Metabase app database!

We'd love to hear your thoughts and feedback on 0.40 or 1.40. Please tell us what you think!

Cheers,
Maz and the Metabase team

1 Like
2

When upgrading from 0.39.4 to 0.40.0 on AWS EBS, it seems to not be finding the app database correctly and showing up as if it were a new install. Rolling back to 0.39.4 against the same database (no changes) and everything works fine again. There isn't anything unique to our setup (used the Metabase installation guide).

Excited to try the new dashboard builder!

3

Hi @landm, Luis here, can you send any logs about this issue? I'll check it out on a Elastic Beanstalk server in the meantime

4

Yeah, trying to think through what log would be helpful here. Comparing the container log (stdout) from a 0.39.4 instance and a 0.40.0 the first diff is that instead of "Verifying postgres Database Connection", it goes immediately to "e[31mWARNING: Using Metabase with an H2 application database is not recommended for production deployments." after "Setting up and migrating Metabase DB. Please sit tight, this may take a minute..."

Picked up JAVA_TOOL_OPTIONS: -Xmx1g
Warning: environ value jdk-11.0.11+9 for key :java-version has been overwritten with 11.0.11
2021-07-09 16:05:53,730 INFO metabase.util :: Maximum memory available to JVM: 989.9 MB
2021-07-09 16:06:10,783 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. 🔓 
 For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2021-07-09 16:06:21,021 INFO metabase.core :: 
Metabase v0.40.0 (961caed master) 

Copyright © 2021 Metabase, Inc. 

Metabase Enterprise Edition extensions are NOT PRESENT.
2021-07-09 16:06:21,043 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2021-07-09 16:06:21,047 INFO metabase.core :: Starting Metabase in STANDALONE mode
2021-07-09 16:06:21,135 INFO metabase.server :: Launching Embedded Jetty Webserver with config: 
 {:port 3000, :host "0.0.0.0"}

2021-07-09 16:06:21,184 INFO metabase.core :: Starting Metabase version v0.40.0 (961caed master) ...
2021-07-09 16:06:21,277 INFO metabase.core :: System info:
 {"file.encoding" "UTF-8",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "11.0.11+9",
 "java.vendor" "AdoptOpenJDK",
 "java.vendor.url" "https://adoptopenjdk.net/",
 "java.version" "11.0.11",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "11.0.11+9",
 "os.name" "Linux",
 "os.version" "4.14.232-177.418.amzn2.x86_64",
 "user.language" "en",
 "user.timezone" "America/Los_Angeles"}

2021-07-09 16:06:21,279 INFO metabase.plugins :: Loading plugins in /plugins...
2021-07-09 16:06:21,516 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2021-07-09 16:06:22,139 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
2021-07-09 16:06:22,145 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2021-07-09 16:06:22,154 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2021-07-09 16:06:22,174 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2021-07-09 16:06:22,183 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2021-07-09 16:06:22,194 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
2021-07-09 16:06:22,197 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2021-07-09 16:06:22,205 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2021-07-09 16:06:22,238 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
2021-07-09 16:06:22,245 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2021-07-09 16:06:22,248 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2021-07-09 16:06:22,445 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2021-07-09 16:06:22,822 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :hive-like...e[0m
2021-07-09 16:06:23,431 INFO driver.impl :: e[34mRegistered abstract driver :sqle[0m  🚚
e[32m ↙ Load driver :sql took 208.2 mse[0m
2021-07-09 16:06:23,456 INFO driver.impl :: e[34mRegistered abstract driver :sql-jdbce[0m (parents: [:sql]) 🚚
e[32mLoad driver :sql-jdbc took 637.0 mse[0m
2021-07-09 16:06:23,469 INFO driver.impl :: e[34mRegistered abstract driver :hive-likee[0m (parents: [:sql-jdbc]) 🚚
2021-07-09 16:06:23,474 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sparksql...e[0m
2021-07-09 16:06:23,477 INFO driver.impl :: e[34mRegistered driver :sparksqle[0m (parents: [:hive-like]) 🚚
2021-07-09 16:06:23,509 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-07-09 16:06:23,515 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2021-07-09 16:06:23,516 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase BigQuery Driver"]e[0m
2021-07-09 16:06:23,533 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlserver...e[0m
2021-07-09 16:06:23,537 INFO driver.impl :: e[34mRegistered driver :sqlservere[0m (parents: [:sql-jdbc]) 🚚
2021-07-09 16:06:23,545 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlite...e[0m
2021-07-09 16:06:23,560 INFO driver.impl :: e[34mRegistered driver :sqlitee[0m (parents: [:sql-jdbc]) 🚚
2021-07-09 16:06:23,578 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Vertica Driver due to required dependencies.e[0m Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.

2021-07-09 16:06:23,580 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2021-07-09 16:06:23,595 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase BigQuery Driver" "Metabase Vertica Driver"]e[0m
2021-07-09 16:06:23,607 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :redshift...e[0m
2021-07-09 16:06:23,651 INFO driver.impl :: e[34mRegistered driver :postgrese[0m (parents: [:sql-jdbc]) 🚚
e[32mLoad driver :postgres took 101.8 mse[0m
2021-07-09 16:06:23,744 INFO driver.impl :: e[34mRegistered driver :redshifte[0m (parents: [:postgres]) 🚚
2021-07-09 16:06:23,749 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto...e[0m
2021-07-09 16:06:23,767 INFO driver.impl :: e[34mRegistered driver :prestoe[0m (parents: [:sql]) 🚚
2021-07-09 16:06:23,786 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :druid...e[0m
2021-07-09 16:06:23,787 INFO driver.impl :: e[34mRegistered driver :druide[0m  🚚
2021-07-09 16:06:23,840 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :mongo...e[0m
2021-07-09 16:06:23,851 INFO driver.impl :: e[34mRegistered driver :mongoe[0m  🚚
2021-07-09 16:06:23,863 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :google...e[0m
2021-07-09 16:06:23,878 INFO driver.impl :: e[34mRegistered abstract driver :googlee[0m  🚚
2021-07-09 16:06:23,880 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-07-09 16:06:23,882 DEBUG plugins.initialize :: e[33mDependencies satisfied; these plugins will now be loaded: ["Metabase BigQuery Driver"]e[0m
2021-07-09 16:06:23,887 WARN plugins.lazy-loaded-driver :: e[31mWarning: plugin manifest for :bigquery does not include connection propertiese[0m
2021-07-09 16:06:23,890 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :bigquery...e[0m
2021-07-09 16:06:23,896 INFO driver.impl :: e[34mRegistered driver :bigquerye[0m (parents: [:sql :google]) 🚚
2021-07-09 16:06:23,915 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Oracle Driver due to required dependencies.e[0m Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

2021-07-09 16:06:23,933 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2021-07-09 16:06:23,934 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]e[0m
2021-07-09 16:06:24,018 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :snowflake...e[0m
2021-07-09 16:06:24,029 INFO driver.impl :: e[34mRegistered driver :snowflakee[0m (parents: [:sql-jdbc]) 🚚
2021-07-09 16:06:24,054 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-07-09 16:06:24,057 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-07-09 16:06:24,059 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :googleanalytics...e[0m
2021-07-09 16:06:24,063 INFO driver.impl :: e[34mRegistered driver :googleanalyticse[0m (parents: [:google]) 🚚
2021-07-09 16:06:24,104 INFO driver.impl :: e[34mRegistered driver :h2e[0m (parents: [:sql-jdbc]) 🚚
2021-07-09 16:06:24,241 INFO driver.impl :: e[34mRegistered driver :mysqle[0m (parents: [:sql-jdbc]) 🚚
2021-07-09 16:06:24,353 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2021-07-09 16:06:24,365 WARN db.env :: e[31mWARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.htmle[0m
2021-07-09 16:06:24,393 INFO db.setup :: e[36mVerifying h2 Database Connection ...e[0m
2021-07-09 16:06:24,820 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection. ✅
2021-07-09 16:06:24,822 INFO db.setup :: Running Database Migrations...
2021-07-09 16:06:24,831 INFO db.setup :: Setting up Liquibase...
2021-07-09 16:06:24,928 INFO db.setup :: Liquibase is ready.
2021-07-09 16:06:24,932 INFO db.liquibase :: Checking if Database has unrun migrations...
2021-07-09 16:06:28,776 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2021-07-09 16:06:28,888 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2021-07-09 16:06:32,697 INFO db.setup :: Database Migrations Current ...  ✅
2021-07-09 16:06:32,754 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2021-07-09 16:06:32,763 INFO db.data-migrations :: Running data migration 'add-users-to-default-permissions-groups'...
2021-07-09 16:06:32,806 INFO models.permissions-group :: e[32mCreated magic permissions group 'All Users' (ID = 1)e[0m
2021-07-09 16:06:32,816 INFO models.permissions-group :: e[32mCreated magic permissions group 'Administrators' (ID = 2)e[0m
2021-07-09 16:06:32,823 INFO db.data-migrations :: Running data migration 'add-admin-group-root-entry'...
2021-07-09 16:06:32,834 INFO models.permissions-group :: e[32mCreated magic permissions group 'MetaBot' (ID = 3)e[0m
2021-07-09 16:06:32,846 INFO db.data-migrations :: Running data migration 'add-databases-to-magic-permissions-groups'...
2021-07-09 16:06:32,852 INFO db.data-migrations :: Running data migration 'copy-site-url-setting-and-remove-trailing-slashes'...
2021-07-09 16:06:32,862 INFO db.data-migrations :: Running data migration 'ensure-protocol-specified-in-site-url'...
2021-07-09 16:06:32,870 INFO db.data-migrations :: Running data migration 'populate-card-database-id'...
2021-07-09 16:06:32,877 INFO db.data-migrations :: Running data migration 'migrate-humanization-setting'...
2021-07-09 16:06:32,888 INFO db.data-migrations :: Running data migration 'mark-category-fields-as-list'...
2021-07-09 16:06:32,918 INFO db.data-migrations :: Running data migration 'add-legacy-sql-directive-to-bigquery-sql-cards'...
2021-07-09 16:06:32,927 INFO db.data-migrations :: Running data migration 'clear-ldap-user-local-passwords'...
2021-07-09 16:06:32,940 INFO db.data-migrations :: Running data migration 'add-migrated-collections'...
2021-07-09 16:06:32,975 INFO db.data-migrations :: Running data migration 'migrate-click-through'...
2021-07-09 16:06:32,997 INFO db.data-migrations :: Finished running data migrations.
e[32mDatabase setup took 8.6 se[0m
2021-07-09 16:06:33,388 INFO metabase.events :: Starting events listener: e[34m:metabase.events.dependencies/Dependenciese[0m 👂
2021-07-09 16:06:33,405 INFO metabase.events :: Starting events listener: e[34m:metabase.events.activity-feed/ActivityFeede[0m 👂
2021-07-09 16:06:33,419 INFO metabase.events :: Starting events listener: e[34m:metabase.events.metabot-lifecycle/MetaBotLifecyclee[0m 👂
2021-07-09 16:06:33,420 INFO metabase.events :: Starting events listener: e[34m:metabase.events.last-login/LastLogine[0m 👂
2021-07-09 16:06:33,421 INFO metabase.events :: Starting events listener: e[34m:metabase.events.notifications/Notificationse[0m 👂
2021-07-09 16:06:33,421 INFO metabase.events :: Starting events listener: e[34m:metabase.events.sync-database/Synce[0m 👂
2021-07-09 16:06:33,424 INFO metabase.events :: Starting events listener: e[34m:metabase.events.driver-notifications/DriverNotificationse[0m 👂
2021-07-09 16:06:33,425 INFO metabase.events :: Starting events listener: e[34m:metabase.events.revision/Revisionse[0m 👂
2021-07-09 16:06:33,426 INFO metabase.events :: Starting events listener: e[34m:metabase.events.view-log/ViewLoge[0m 👂
2021-07-09 16:06:33,773 INFO metabase.task :: Initializing task e[32mSyncDatabasese[0m 📆
2021-07-09 16:06:33,810 INFO metabase.task :: Initializing task e[32mCheckForNewVersionse[0m 📆
2021-07-09 16:06:33,842 INFO metabase.task :: Initializing task e[32mSendAnonymousUsageStatse[0m 📆
2021-07-09 16:06:33,854 INFO metabase.task :: Initializing task e[32mSendAbandomentEmailse[0m 📆
2021-07-09 16:06:33,862 INFO metabase.task :: Initializing task e[32mSendPulsese[0m 📆
2021-07-09 16:06:33,866 INFO metabase.task :: Initializing task e[32mSendFollowUpEmailse[0m 📆
2021-07-09 16:06:33,879 INFO metabase.task :: Initializing task e[32mTaskHistoryCleanupe[0m 📆
2021-07-09 16:06:33,884 INFO metabase.core :: Looks like this is a new installation ... preparing setup wizard
2021-07-09 16:06:33,920 INFO metabase.core :: e[32mPlease use the following URL to setup your Metabase installation:

http://0.0.0.0:3000/setup/

e[0m
2021-07-09 16:06:33,942 INFO metabase.sample-data :: Loading sample dataset...
2021-07-09 16:06:33,945 INFO driver.impl :: e[33mInitializing driver :sql...e[0m
2021-07-09 16:06:33,955 INFO driver.impl :: e[33mInitializing driver :sql-jdbc...e[0m
2021-07-09 16:06:33,957 INFO driver.impl :: e[33mInitializing driver :h2...e[0m
2021-07-09 16:06:34,062 INFO task.sync-databases :: e[32mScheduling sync/analyze for database 1: trigger: metabase.task.sync-and-analyze.trigger.1e[0m
2021-07-09 16:06:34,087 INFO task.sync-databases :: e[32mScheduling field-values for database 1: trigger: metabase.task.update-field-values.trigger.1e[0m
2021-07-09 16:06:34,110 INFO sync.util :: e[35mSTARTING: Sync h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:34,123 INFO sync.util :: e[35mSTARTING: Sync metadata for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:34,135 INFO sync.util :: e[35mSTARTING: step 'sync-timezone' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:34,711 INFO sync.util :: e[35mFINISHED: step 'sync-timezone' for h2 Database 1 'Sample Dataset' (575.7 ms)e[0m
2021-07-09 16:06:34,715 INFO sync.util :: e[35mSTARTING: step 'sync-tables' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:34,797 INFO sync-metadata.tables :: Found new tables: (Table  'PUBLIC.PRODUCTS' Table  'PUBLIC.ORDERS' Table  'PUBLIC.PEOPLE' Table  'PUBLIC.REVIEWS')
2021-07-09 16:06:34,871 INFO sync-metadata.tables :: Updating description for tables: (Table  'PUBLIC.PEOPLE' Table  'PUBLIC.REVIEWS' Table  'PUBLIC.ORDERS' Table  'PUBLIC.PRODUCTS')
2021-07-09 16:06:34,873 INFO sync.util :: e[35mFINISHED: step 'sync-tables' for h2 Database 1 'Sample Dataset' (157.9 ms)e[0m
2021-07-09 16:06:34,876 INFO sync.util :: e[35mSTARTING: step 'sync-fields' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:35,450 INFO sync.util :: e[35mFINISHED: step 'sync-fields' for h2 Database 1 'Sample Dataset' (573.5 ms)e[0m
2021-07-09 16:06:35,455 INFO sync.util :: e[35mSTARTING: step 'sync-fks' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:35,487 INFO sync-metadata.fks :: e[36mMarking foreign key from Table 2 'PUBLIC.ORDERS' Field 11 'USER_ID' -> Table 3 'PUBLIC.PEOPLE' Field 30 'ID'e[0m
2021-07-09 16:06:35,501 INFO sync-metadata.fks :: e[36mMarking foreign key from Table 2 'PUBLIC.ORDERS' Field 13 'PRODUCT_ID' -> Table 1 'PUBLIC.PRODUCTS' Field 8 'ID'e[0m
2021-07-09 16:06:35,520 INFO sync-metadata.fks :: e[36mMarking foreign key from Table 4 'PUBLIC.REVIEWS' Field 33 'PRODUCT_ID' -> Table 1 'PUBLIC.PRODUCTS' Field 8 'ID'e[0m
2021-07-09 16:06:35,523 INFO sync.util :: e[35mFINISHED: step 'sync-fks' for h2 Database 1 'Sample Dataset' (67.7 ms)e[0m
2021-07-09 16:06:35,524 INFO sync.util :: e[35mSTARTING: step 'sync-metabase-metadata' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:35,693 INFO sync.util :: e[35mFINISHED: step 'sync-metabase-metadata' for h2 Database 1 'Sample Dataset' (168.8 ms)e[0m
2021-07-09 16:06:35,830 INFO sync.util :: e[35mFINISHED: Sync metadata for h2 Database 1 'Sample Dataset' (1.7 s)e[0m
2021-07-09 16:06:35,834 INFO sync.util :: e[35mSTARTING: Analyze data for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:35,843 INFO sync.util :: e[35mSTARTING: step 'fingerprint-fields' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:37,325 INFO sync.analyze :: e[34mfingerprint-fields Analyzed [*******···········································] 😞   15% Table 2 'PUBLIC.ORDERS'e[0m
2021-07-09 16:06:41,708 INFO sync.analyze :: e[34mfingerprint-fields Analyzed [***************···································] 😕   31% Table 4 'PUBLIC.REVIEWS'e[0m
2021-07-09 16:06:42,281 INFO sync.util :: e[35mFINISHED: step 'fingerprint-fields' for h2 Database 1 'Sample Dataset' (6.4 s)e[0m
2021-07-09 16:06:42,293 INFO sync.util :: e[35mSTARTING: step 'classify-fields' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:42,446 INFO sync.analyze :: e[34mclassify-fields Analyzed [***********************···························] 😬   46% Table 2 'PUBLIC.ORDERS'e[0m
2021-07-09 16:06:42,577 INFO sync.analyze :: e[34mclassify-fields Analyzed [******************************····················] 😌   62% Table 4 'PUBLIC.REVIEWS'e[0m
2021-07-09 16:06:42,578 INFO sync.util :: e[35mFINISHED: step 'classify-fields' for h2 Database 1 'Sample Dataset' (285.0 ms)e[0m
2021-07-09 16:06:42,579 INFO sync.util :: e[35mSTARTING: step 'classify-tables' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:42,596 INFO sync.analyze :: e[34mclassify-tables Analyzed [**************************************············] 😋   77% Table 2 'PUBLIC.ORDERS'e[0m
2021-07-09 16:06:42,606 INFO sync.analyze :: e[34mclassify-tables Analyzed [**********************************************····] 😍   92% Table 4 'PUBLIC.REVIEWS'e[0m
2021-07-09 16:06:42,607 INFO sync.util :: e[35mFINISHED: step 'classify-tables' for h2 Database 1 'Sample Dataset' (27.7 ms)e[0m
2021-07-09 16:06:42,631 INFO sync.util :: e[35mFINISHED: Analyze data for h2 Database 1 'Sample Dataset' (6.8 s)e[0m
2021-07-09 16:06:42,633 INFO sync.util :: e[35mSTARTING: Cache field values in h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:42,638 INFO sync.util :: e[35mSTARTING: step 'update-field-values' for h2 Database 1 'Sample Dataset'e[0m
2021-07-09 16:06:44,174 INFO sync.util :: e[35mFINISHED: step 'update-field-values' for h2 Database 1 'Sample Dataset' (1.5 s)e[0m
2021-07-09 16:06:44,183 INFO sync.util :: e[35mFINISHED: Cache field values in h2 Database 1 'Sample Dataset' (1.5 s)e[0m
2021-07-09 16:06:44,184 INFO sync.util :: e[35mFINISHED: Sync h2 Database 1 'Sample Dataset' (10.1 s)e[0m
2021-07-09 16:06:44,188 INFO metabase.core :: Metabase Initialization COMPLETE
5

what environment variables you have defined @landm?

6

Looking at that now, originally just:

27%20PM
27%20PM2968×424 16.9 KB

But specifically configuring the MB_DB_* variables right now. Will let you know if that resolves the issue.

7

I'm thinking that you might have the RDS in the deployment that Elastic Beanstalk did which is not recommended as it launches RDS instances with sub-optimal options, check out this guide if needed https://www.metabase.com/docs/latest/operations-guide/creating-RDS-database-on-AWS.html#decouple-your-rds-database-from-the-elastic-beanstalk-deployment

8

Yeah, that is the issue. Worth noting for others that this must be done, as this is the first upgrade since 0.36.1 that I've had an issue.

Thanks for the help!

9

Hi
unfortunately we still see a lot of IE11 out there - can this be added bnack as a supported browser ??
What will not work on it ?

10

@Robbo IE11 will not be added back. We cannot tell you what works or doesn't work, since it's not been tested. Everything might work like previous versions, but going forward things will stop working, since no modern libraries support IE11 anymore.

Most advanced webservices do not support IE11 anymore - even Microsoft has removed support for their services. And IE11 will be completely unsupported (not more security updates) by June 15th 2022:
https://blogs.windows.com/windowsexperience/2021/05/19/the-future-of-internet-explorer-on-windows-10-is-in-microsoft-edge/
You should migrate to Edge, which has an option for "IE Mode" for legacy systems that still requires that.

11

Also had an issue upgrading from 0.39.3 on Elastic Beanstalk to 0.40.0. Dropped back to 0.39.4 and that worked.

2021-07-12 08:39:31 UTC-0400 WARN Environment health has transitioned from Info to Degraded. Command failed on all instances. Incorrect application version found on all instances. Expected version "v0.39.3" (deployment 49). Application update is aborting. 4 out of 4 instances completed (running for 2 minutes).
2021-07-12 08:38:21 UTC-0400 ERROR During an aborted deployment, some instances may have deployed the new application version. To ensure all instances are running the same version, re-deploy the appropriate application version.
2021-07-12 08:38:21 UTC-0400 ERROR Failed to deploy application.
2021-07-12 08:38:21 UTC-0400 ERROR Unsuccessful command execution on instance id(s) 'i-05806c7b6f22db7a0,i-07add0acc5f6ad9db,i-01cd60fb09474fe78,i-0788ee43edbeedfce'. Aborting the operation.
2021-07-12 08:38:21 UTC-0400 INFO Command execution completed on all instances. Summary: [Successful: 0, Failed: 4].
2021-07-12 08:38:21 UTC-0400 ERROR [Instance: i-07add0acc5f6ad9db] Command failed on instance. Return code: 1 Output: Loaded plugins: priorities, update-motd, upgrade-helper No package amazon-cloudwatch-agent available. Error: Nothing to do. container_command 07-install_cloudwatch_agent in .ebextensions/01_metabase.config failed. For more detail, check /var/log/eb-activity.log using console or EB CLI.
2021-07-12 08:38:16 UTC-0400 ERROR [Instance: i-05806c7b6f22db7a0,i-01cd60fb09474fe78,i-0788ee43edbeedfce] Command failed on instance. Return code: 1 Output: Loaded plugins: priorities, update-motd, upgrade-helper No package amazon-cloudwatch-agent available. Error: Nothing to do. container_command 07-install_cloudwatch_agent in .ebextensions/01_metabase.config failed. For more detail, check /var/log/eb-activity.log using console or EB CLI.
2021-07-12 08:38:06 UTC-0400 INFO Successfully built aws_beanstalk/staging-app
--- --- ---
2021-07-12 08:38:05 UTC-0400 INFO Successfully built aws_beanstalk/staging-app
2021-07-12 08:38:04 UTC-0400 INFO Successfully pulled metabase/metabase:v0.40.0
2021-07-12 08:37:44 UTC-0400 INFO Deploying new version to instance(s).
2021-07-12 08:37:31 UTC-0400 INFO Environment health has transitioned from Ok to Info. Application update in progress (running for 6 seconds).
2021-07-12 08:37:02 UTC-0400 INFO Environment update is starting.
12

Hi @mikebee, seems like the cloudwatch agent couldn't be installed (a feature we introduced in https://github.com/metabase/metabase/issues/11851), can you try deploying a new Elastic Beanstalk application and connecting to your current application database?

13

thanks... well i was attempting to deploy the latest version when i got this error. or do you mean something different?

14

@mikebee try doing a separate deployment (connecting to your current application database) instead of a re-deployment on the current stack

15

New question picker on dashboards is great, as is the moving of charts when you resize them. These have been small friction points for us but this feels like it works really smoothly. I'm yet to update production, will see how it shakes out out over the next week or so.

1 Like
16

The top margin for questions placed on the dashboard is gone. (Questions are arranged at the top)
Is this such a specification and will it not change in the future?

Before

([Q]=Question)

[Q][Q][Q]
[Q]
[Q][Q][Q]

After (0.40)

([Q]=Question)

[Q][Q][Q]
[Q][Q][Q]
[Q]

17

@masakazuwatanabe You're seeing this issue:
https://github.com/metabase/metabase/issues/16786 - upvote by clicking :+1: on the first post

18

I'm having the same problem upgrading to 0.40.0 from 0.39.3, did you get a solution for it?

20

@trsilva32 @mikebee if you are having issues upgrading and you are using a very old version of Elastic Beanstalk, we created an issue and we just uploaded a custom deployment file in the thread https://github.com/metabase/metabase/issues/17012

21

thanks will give this a go