[SOLVED] Kubernetes pod shutdowns after migration

mhm · December 14, 2020, 9:50pm

Hi! I’m wondering if anyone has experience running metabase in k8s?

After trying to run a pod for the first time, metabase shutdown without much hint.

Using PostgreSQL 10.5, running k8s 1.17, using docker image metabase/metabase:v0.37.3

this the log

Picked up JAVA_TOOL_OPTIONS: -Xmx2g 
Warning: environ value jdk-11.0.7+10 for key :java-version has been overwritten with 11.0.7
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2020-12-14 21:44:24,781 INFO metabase.util :: Maximum memory available to JVM: 1.9 GB
2020-12-14 21:44:35,538 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
2020-12-14 21:44:41,657 INFO metabase.core ::
Metabase v0.37.3 (2f1e783 release-x.37.x)
Copyright © 2020 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2020-12-14 21:44:41,670 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2020-12-14 21:44:41,671 INFO metabase.core :: Starting Metabase in STANDALONE mode
2020-12-14 21:44:41,728 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
 {:port 3000, :host "0.0.0.0"}
2020-12-14 21:44:41,768 INFO metabase.core :: Starting Metabase version v0.37.3 (2f1e783 release-x.37.x) ...
2020-12-14 21:44:41,811 INFO metabase.core :: System info:
 {"file.encoding" "UTF-8",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "11.0.7+10",
 "java.vendor" "AdoptOpenJDK",
 "java.vendor.url" "https://adoptopenjdk.net/",
 "java.version" "11.0.7",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "11.0.7+10",
 "os.name" "Linux",
 "os.version" "4.14.203-156.332.amzn2.x86_64",
 "user.language" "en",
 "user.timezone" "GMT"}
2020-12-14 21:44:41,814 INFO metabase.plugins :: Loading plugins in /plugins...
2020-12-14 21:44:41,935 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2020-12-14 21:44:42,167 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2020-12-14 21:44:42,185 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2020-12-14 21:44:42,194 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2020-12-14 21:44:42,218 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2020-12-14 21:44:42,623 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2020-12-14 21:44:42,645 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2020-12-14 21:44:42,664 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2020-12-14 21:44:42,669 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2020-12-14 21:44:42,670 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
2020-12-14 21:44:42,675 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
2020-12-14 21:44:42,677 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2020-12-14 21:44:42,722 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
2020-12-14 21:44:42,911 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2020-12-14 21:44:43,106 INFO driver.impl :: Registered abstract driver :sql  🚚
Load driver :sql took 139.8 ms
2020-12-14 21:44:43,126 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚
Load driver :sql-jdbc took 220.1 ms
2020-12-14 21:44:43,134 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
2020-12-14 21:44:43,142 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2020-12-14 21:44:43,144 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2020-12-14 21:44:43,144 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Google Analytics Driver"]
2020-12-14 21:44:43,157 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2020-12-14 21:44:43,157 INFO driver.impl :: Registered driver :druid  🚚
2020-12-14 21:44:43,166 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2020-12-14 21:44:43,174 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚
Load driver :postgres took 19.5 ms
2020-12-14 21:44:43,186 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚
2020-12-14 21:44:43,209 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2020-12-14 21:44:43,211 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
2020-12-14 21:44:43,212 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2020-12-14 21:44:43,212 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚
2020-12-14 21:44:43,215 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2020-12-14 21:44:43,216 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2020-12-14 21:44:43,220 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2020-12-14 21:44:43,221 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
2020-12-14 21:44:43,226 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. 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.
2020-12-14 21:44:43,226 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2020-12-14 21:44:43,227 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Google Analytics Driver"]
2020-12-14 21:44:43,231 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. 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.
2020-12-14 21:44:43,231 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2020-12-14 21:44:43,232 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver" "Metabase Google Analytics Driver"]
2020-12-14 21:44:43,235 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2020-12-14 21:44:43,235 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2020-12-14 21:44:43,239 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase BigQuery Driver" "Metabase Vertica Driver" "Metabase Oracle Driver" "Metabase Google Analytics Driver"]
2020-12-14 21:44:43,245 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2020-12-14 21:44:43,246 INFO driver.impl :: Registered driver :presto (parents: [:sql]) 🚚
2020-12-14 21:44:43,261 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2020-12-14 21:44:43,262 INFO driver.impl :: Registered driver :mongo  🚚
2020-12-14 21:44:43,268 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2020-12-14 21:44:43,268 INFO driver.impl :: Registered abstract driver :google  🚚
2020-12-14 21:44:43,269 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-12-14 21:44:43,270 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-12-14 21:44:43,270 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Google Analytics Driver" "Metabase BigQuery Driver"]
2020-12-14 21:44:43,271 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2020-12-14 21:44:43,271 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) 🚚
2020-12-14 21:44:43,272 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2020-12-14 21:44:43,275 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2020-12-14 21:44:43,275 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) 🚚
2020-12-14 21:44:43,282 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚
2020-12-14 21:44:43,300 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚
2020-12-14 21:44:43,315 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2020-12-14 21:44:43,319 INFO metabase.db :: Verifying postgres Database Connection ...
2020-12-14 21:44:43,325 INFO driver.impl :: Initializing driver :sql...
2020-12-14 21:44:43,333 INFO driver.impl :: Initializing driver :sql-jdbc...
2020-12-14 21:44:43,333 INFO driver.impl :: Initializing driver :postgres...
2020-12-14 21:44:43,464 INFO metabase.db :: Successfully verified PostgreSQL 10.5 (Debian 10.5-2.pgdg90+1) application database connection. ✅
2020-12-14 21:44:43,467 INFO metabase.db :: Running Database Migrations...
2020-12-14 21:44:43,473 INFO metabase.db :: Setting up Liquibase...
2020-12-14 21:44:43,539 INFO metabase.db :: Liquibase is ready.
2020-12-14 21:44:43,543 INFO db.liquibase :: Checking if Database has unrun migrations...
2020-12-14 21:44:45,530 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2020-12-14 21:44:45,609 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2020-12-14 21:44:48,423 INFO metabase.db :: Database Migrations Current ...  ✅
2020-12-14 21:44:48,513 INFO db.migrations :: Running all necessary data migrations, this may take a minute.
2020-12-14 21:44:48,623 INFO db.migrations :: Running data migration 'add-users-to-default-permissions-groups'...
2020-12-14 21:44:48,674 INFO models.permissions-group :: Created magic permissions group 'All Users' (ID = 1)
2020-12-14 21:44:48,685 INFO models.permissions-group :: Created magic permissions group 'Administrators' (ID = 2)
2020-12-14 21:44:48,801 INFO db.migrations :: Running data migration 'add-admin-group-root-entry'...
2020-12-14 21:44:48,807 INFO metabase.core :: Metabase Shutting Down ...
2020-12-14 21:44:48,807 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2020-12-14 21:44:48,821 INFO metabase.core :: Metabase Shutdown COMPLETE

I should mention after the pod tries to run again, I see this:

2020-12-14 21:50:41,848 INFO metabase.db :: Verifying postgres Database Connection ...
2020-12-14 21:50:41,858 INFO driver.impl :: Initializing driver :sql...
2020-12-14 21:50:41,862 INFO driver.impl :: Initializing driver :sql-jdbc...
2020-12-14 21:50:41,862 INFO driver.impl :: Initializing driver :postgres...
2020-12-14 21:50:41,980 INFO metabase.db :: Successfully verified PostgreSQL 10.5 (Debian 10.5-2.pgdg90+1) application database connection. ✅
2020-12-14 21:50:41,982 INFO metabase.db :: Running Database Migrations...
2020-12-14 21:50:42,006 INFO metabase.db :: Setting up Liquibase...
2020-12-14 21:50:42,076 INFO metabase.db :: Liquibase is ready.
2020-12-14 21:50:42,077 INFO db.liquibase :: Checking if Database has unrun migrations...
2020-12-14 21:50:44,148 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2020-12-14 21:50:44,167 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2020-12-14 21:50:44,200 INFO metabase.db :: Database Migrations Current ...  ✅
2020-12-14 21:50:44,310 INFO db.migrations :: Running all necessary data migrations, this may take a minute.
2020-12-14 21:50:44,388 INFO db.migrations :: Finished running data migrations.
Database setup took 2.5 s
2020-12-14 21:50:44,457 INFO metabase.events :: Starting events listener: :metabase.events.dependencies/Dependencies 👂
2020-12-14 21:50:44,467 INFO metabase.events :: Starting events listener: :metabase.events.activity-feed/ActivityFeed 👂
2020-12-14 21:50:44,475 INFO metabase.events :: Starting events listener: :metabase.events.metabot-lifecycle/MetaBotLifecycle 👂
2020-12-14 21:50:44,479 INFO metabase.events :: Starting events listener: :metabase.events.last-login/LastLogin 👂
2020-12-14 21:50:44,482 INFO metabase.events :: Starting events listener: :metabase.events.notifications/Notifications 👂
2020-12-14 21:50:44,488 INFO metabase.events :: Starting events listener: :metabase.events.sync-database/Sync 👂
2020-12-14 21:50:44,491 INFO metabase.events :: Starting events listener: :metabase.events.driver-notifications/DriverNotifications 👂
2020-12-14 21:50:44,492 INFO metabase.events :: Starting events listener: :metabase.events.revision/Revisions 👂
2020-12-14 21:50:44,492 INFO metabase.events :: Starting events listener: :metabase.events.view-log/ViewLog 👂
2020-12-14 21:50:44,726 INFO metabase.task :: Initializing task SyncDatabases 📆
2020-12-14 21:50:44,816 INFO task.sync-databases :: Starting sync task for Database 1.
2020-12-14 21:50:44,834 INFO sync.util :: STARTING: Sync metadata for h2 Database 1 'Sample Dataset'
2020-12-14 21:50:44,836 INFO driver.impl :: Initializing driver :h2...
2020-12-14 21:50:44,852 INFO sync.util :: STARTING: step 'sync-timezone' for h2 Database 1 'Sample Dataset'
2020-12-14 21:50:44,865 INFO metabase.task :: Initializing task CheckForNewVersions 📆
2020-12-14 21:50:44,899 INFO metabase.task :: Initializing task SendAnonymousUsageStats 📆
2020-12-14 21:50:44,925 INFO metabase.task :: Initializing task SendAbandomentEmails 📆
2020-12-14 21:50:44,964 INFO metabase.task :: Initializing task SendPulses 📆
2020-12-14 21:50:44,990 INFO metabase.task :: Initializing task SendFollowUpEmails 📆
2020-12-14 21:50:45,017 INFO metabase.task :: Initializing task TaskHistoryCleanup 📆
2020-12-14 21:50:45,045 INFO metabase.core :: Looks like this is a new installation ... preparing setup wizard
2020-12-14 21:50:45,051 INFO metabase.core :: Please use the following URL to setup your Metabase installation:
http://0.0.0.0:3000/setup/
2020-12-14 21:50:45,062 INFO metabase.core :: Metabase Initialization COMPLETE
2020-12-14 21:50:45,524 INFO sync.util :: FINISHED: step 'sync-timezone' for h2 Database 1 'Sample Dataset' (670.9 ms)
2020-12-14 21:50:45,527 INFO sync.util :: STARTING: step 'sync-tables' for h2 Database 1 'Sample Dataset'
2020-12-14 21:50:45,650 INFO sync-metadata.tables :: Found new tables: (Table  'PUBLIC.PRODUCTS' Table  'PUBLIC.ORDERS' Table  'PUBLIC.PEOPLE' Table  'PUBLIC.REVIEWS')
2020-12-14 21:50:45,747 INFO sync-metadata.tables :: Updating description for tables: (Table  'PUBLIC.PEOPLE' Table  'PUBLIC.REVIEWS' Table  'PUBLIC.ORDERS' Table  'PUBLIC.PRODUCTS')
2020-12-14 21:50:45,750 INFO sync.util :: FINISHED: step 'sync-tables' for h2 Database 1 'Sample Dataset' (223.2 ms)
2020-12-14 21:50:45,751 INFO sync.util :: STARTING: step 'sync-fields' for h2 Database 1 'Sample Dataset'
2020-12-14 21:50:46,231 INFO sync.util :: FINISHED: step 'sync-fields' for h2 Database 1 'Sample Dataset' (479.9 ms)
2020-12-14 21:50:46,234 INFO sync.util :: STARTING: step 'sync-fks' for h2 Database 1 'Sample Dataset'
2020-12-14 21:50:46,267 INFO sync-metadata.fks :: Marking foreign key from Table 2 'PUBLIC.ORDERS' Field 3 'USER_ID' -> Table 3 'PUBLIC.PEOPLE' Field 22 'ID'
2020-12-14 21:50:46,287 INFO sync-metadata.fks :: Marking foreign key from Table 2 'PUBLIC.ORDERS' Field 5 'PRODUCT_ID' -> Table 1 'PUBLIC.PRODUCTS' Field 30 'ID'
2020-12-14 21:50:46,309 INFO sync-metadata.fks :: Marking foreign key from Table 4 'PUBLIC.REVIEWS' Field 33 'PRODUCT_ID' -> Table 1 'PUBLIC.PRODUCTS' Field 30 'ID'
2020-12-14 21:50:46,332 INFO sync.util :: FINISHED: step 'sync-fks' for h2 Database 1 'Sample Dataset' (96.8 ms)
2020-12-14 21:50:46,339 INFO sync.util :: STARTING: step 'sync-metabase-metadata' for h2 Database 1 'Sample Dataset'
2020-12-14 21:50:46,456 INFO metabase.core :: Metabase Shutting Down ...
2020-12-14 21:50:46,475 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2020-12-14 21:50:46,498 INFO metabase.core :: Metabase Shutdown COMPLETE

mhm · December 15, 2020, 9:45am

I tried to use H2 and seeing the same behavior:

Warning: environ value jdk-11.0.7+10 for key :java-version has been overwritten with 11.0.7
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2020-12-15 09:41:31,244 INFO metabase.util :: Maximum memory available to JVM: 846.8 MB
2020-12-15 09:41:41,941 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
2020-12-15 09:41:48,353 INFO metabase.core ::
Metabase v0.37.3 (2f1e783 release-x.37.x)
Copyright © 2020 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2020-12-15 09:41:48,385 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2020-12-15 09:41:48,386 INFO metabase.core :: Starting Metabase in STANDALONE mode
2020-12-15 09:41:48,431 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
 {:port 3000, :host "0.0.0.0"}
2020-12-15 09:41:48,486 INFO metabase.core :: Starting Metabase version v0.37.3 (2f1e783 release-x.37.x) ...
2020-12-15 09:41:48,569 INFO metabase.core :: System info:
 {"file.encoding" "UTF-8",
 "java.runtime.name" "OpenJDK Runtime Environment",
 "java.runtime.version" "11.0.7+10",
 "java.vendor" "AdoptOpenJDK",
 "java.vendor.url" "https://adoptopenjdk.net/",
 "java.version" "11.0.7",
 "java.vm.name" "OpenJDK 64-Bit Server VM",
 "java.vm.version" "11.0.7+10",
 "os.name" "Linux",
 "os.version" "4.14.203-156.332.amzn2.x86_64",
 "user.language" "en",
 "user.timezone" "GMT"}
2020-12-15 09:41:48,581 INFO metabase.plugins :: Loading plugins in /plugins...
2020-12-15 09:41:48,921 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2020-12-15 09:41:49,157 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2020-12-15 09:41:49,163 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2020-12-15 09:41:49,169 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2020-12-15 09:41:49,188 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2020-12-15 09:41:49,627 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2020-12-15 09:41:49,656 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2020-12-15 09:41:49,672 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2020-12-15 09:41:49,678 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2020-12-15 09:41:49,682 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
2020-12-15 09:41:49,688 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
2020-12-15 09:41:49,690 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2020-12-15 09:41:49,723 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
2020-12-15 09:41:49,869 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2020-12-15 09:41:50,118 INFO driver.impl :: Registered abstract driver :sql  🚚
Load driver :sql took 149.3 ms
2020-12-15 09:41:50,132 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) 🚚
Load driver :sql-jdbc took 267.6 ms
2020-12-15 09:41:50,139 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
2020-12-15 09:41:50,147 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2020-12-15 09:41:50,149 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2020-12-15 09:41:50,150 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Google Analytics Driver"]
2020-12-15 09:41:50,154 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2020-12-15 09:41:50,155 INFO driver.impl :: Registered driver :druid  🚚
2020-12-15 09:41:50,160 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2020-12-15 09:41:50,175 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) 🚚
Load driver :postgres took 33.5 ms
2020-12-15 09:41:50,199 INFO driver.impl :: Registered driver :redshift (parents: [:postgres]) 🚚
2020-12-15 09:41:50,233 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2020-12-15 09:41:50,235 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
2020-12-15 09:41:50,235 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2020-12-15 09:41:50,237 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like]) 🚚
2020-12-15 09:41:50,240 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2020-12-15 09:41:50,241 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
2020-12-15 09:41:50,248 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2020-12-15 09:41:50,250 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
2020-12-15 09:41:50,256 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. 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.
2020-12-15 09:41:50,257 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2020-12-15 09:41:50,257 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Google Analytics Driver" "Metabase Oracle Driver"]
2020-12-15 09:41:50,261 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. 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.
2020-12-15 09:41:50,262 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2020-12-15 09:41:50,268 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Google Analytics Driver" "Metabase Oracle Driver"]
2020-12-15 09:41:50,271 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2020-12-15 09:41:50,271 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
2020-12-15 09:41:50,271 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase BigQuery Driver" "Metabase Google Analytics Driver" "Metabase Oracle Driver"]
2020-12-15 09:41:50,278 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...
2020-12-15 09:41:50,279 INFO driver.impl :: Registered driver :presto (parents: [:sql]) 🚚
2020-12-15 09:41:50,288 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2020-12-15 09:41:50,293 INFO driver.impl :: Registered driver :mongo  🚚
2020-12-15 09:41:50,296 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :google...
2020-12-15 09:41:50,296 INFO driver.impl :: Registered abstract driver :google  🚚
2020-12-15 09:41:50,297 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-12-15 09:41:50,297 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2020-12-15 09:41:50,298 DEBUG plugins.initialize :: Dependencies satisfied; these plugins will now be loaded: ["Metabase Google Analytics Driver" "Metabase BigQuery Driver"]
2020-12-15 09:41:50,299 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2020-12-15 09:41:50,299 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) 🚚
2020-12-15 09:41:50,300 WARN plugins.lazy-loaded-driver :: Warning: plugin manifest for :bigquery does not include connection properties
2020-12-15 09:41:50,307 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery...
2020-12-15 09:41:50,308 INFO driver.impl :: Registered driver :bigquery (parents: [:sql :google]) 🚚
2020-12-15 09:41:50,316 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) 🚚
2020-12-15 09:41:50,338 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) 🚚
2020-12-15 09:41:50,356 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2020-12-15 09:41:50,360 WARN metabase.db :: WARNING: 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.html
2020-12-15 09:41:50,363 INFO metabase.db :: Verifying h2 Database Connection ...
2020-12-15 09:41:50,371 INFO driver.impl :: Initializing driver :sql...
2020-12-15 09:41:50,372 INFO driver.impl :: Initializing driver :sql-jdbc...
2020-12-15 09:41:50,372 INFO driver.impl :: Initializing driver :h2...
2020-12-15 09:41:50,634 INFO metabase.db :: Successfully verified H2 1.4.197 (2018-03-18) application database connection. ✅
2020-12-15 09:41:50,635 INFO metabase.db :: Running Database Migrations...
2020-12-15 09:41:50,646 INFO metabase.db :: Setting up Liquibase...
2020-12-15 09:41:50,744 INFO metabase.db :: Liquibase is ready.
2020-12-15 09:41:50,745 INFO db.liquibase :: Checking if Database has unrun migrations...
2020-12-15 09:41:53,086 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2020-12-15 09:41:53,150 INFO db.liquibase :: Migration lock is cleared. Running migrations...
2020-12-15 09:41:55,293 INFO metabase.db :: Database Migrations Current ...  ✅
2020-12-15 09:41:55,328 INFO metabase.core :: Metabase Shutting Down ...
2020-12-15 09:41:55,329 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2020-12-15 09:41:55,365 INFO metabase.core :: Metabase Shutdown COMPLETE

flamber · December 15, 2020, 10:24am

Hi @mhm
Migration is a one-off process - meaning you run it one time and never again. Then you start Metabase on the new application database (without the load-from-h2 parameter).
I would recommend not running migration in k8s - it’s just over-complicating things.

mhm · December 15, 2020, 11:10am

Thanks for the reply.

The migration is part of the steps when docker images starts. I don’t have any way to prevent that.

So today I noticed what’s wrong! I set up the livenessProbe and readinessProbe in my deployment. I removed them and it’s working fine now!

--- a/metabase/templates/deployment.yaml
+++ b/metabase/templates/deployment.yaml
@@ -31,14 +31,6 @@ spec:
             - name: http
               containerPort: 80
               protocol: TCP
-          livenessProbe:
-            httpGet:
-              path: /
-              port: http
-          readinessProbe:
-            httpGet:
-              path: /
-              port: http