Cannot connect to database after upgrading from Postgres 10 to Postgres 11

Setup

  • AWS Beanstalk using a standalone Postgres database.
  • Metabase v0.44.1

Have also tried:

  • Postgres v11.16, v11.17, v11.19
  • Upgrading to Metabase v0.45

The app will just stay on the loading screen. I have since switched back to Postgres v10.21 so production continues to work for now, but AWS is forcing updates to Postgres 11 by April 17th next month.

The plugin dependency catches my eye, but why now without updating MB itself and only the DB?

Error log:

Metabase v0.44.1 (112f5aa release-x.44.x)

Copyright © 2023 Metabase, Inc.

Metabase Enterprise Edition extensions are NOT PRESENT.

2023-03-22 02:47:15,432 INFO metabase.core :: Starting Metabase in STANDALONE mode

2023-03-22 02:47:15,478 INFO metabase.server :: Launching Embedded Jetty Webserver with config:

{:port 3000, :host "0.0.0.0"}

2023-03-22 02:47:15,534 INFO metabase.core :: Starting Metabase version v0.44.1 (112f5aa release-x.44.x) ...

2023-03-22 02:47:15,593 INFO metabase.core :: System info:

{"file.encoding" "UTF-8",

"java.runtime.name" "OpenJDK Runtime Environment",

"java.runtime.version" "11.0.16+8",

"java.vendor" "Eclipse Adoptium",

"java.vendor.url" "https://adoptium.net/",

"java.version" "11.0.16",

"java.vm.name" "OpenJDK 64-Bit Server VM",

"java.vm.version" "11.0.16+8",

"os.name" "Linux",

"os.version" "4.14.287-215.504.amzn2.x86_64",

"user.language" "en",

"user.timezone" "GMT"}

2023-03-22 02:47:15,594 INFO metabase.plugins :: Loading plugins in /plugins...

2023-03-22 02:47:15,761 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar

2023-03-22 02:47:15,824 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar

2023-03-22 02:47:15,833 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar

2023-03-22 02:47:15,894 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar

2023-03-22 02:47:15,918 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar

2023-03-22 02:47:15,919 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar

2023-03-22 02:47:15,926 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar

2023-03-22 02:47:15,927 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar

2023-03-22 02:47:15,932 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar

2023-03-22 02:47:15,949 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar

2023-03-22 02:47:15,950 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar

2023-03-22 02:47:16,148 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar

2023-03-22 02:47:16,161 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar

2023-03-22 02:47:16,208 INFO util.files :: Extract file /modules/presto-common.metabase-driver.jar -> /plugins/presto-common.metabase-driver.jar

2023-03-22 02:47:16,340 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :hive-like...e[0m

2023-03-22 02:47:16,412 INFO driver.impl :: e[34mRegistered abstract driver :hive-likee[0m (parents: [:sql-jdbc]) :truck:

2023-03-22 02:47:16,413 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sparksql...e[0m

2023-03-22 02:47:16,413 INFO driver.impl :: e[34mRegistered driver :sparksqle[0m (parents: [:hive-like]) :truck:

2023-03-22 02:47:16,426 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlserver...e[0m

2023-03-22 02:47:16,427 INFO driver.impl :: e[34mRegistered driver :sqlservere[0m (parents: [:sql-jdbc]) :truck:

2023-03-22 02:47:16,458 INFO plugins.dependencies :: Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'

2023-03-22 02:47:16,459 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? false

2023-03-22 02:47:16,460 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Presto JDBC Driver"]e[0m

2023-03-22 02:47:16,471 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlite...e[0m

2023-03-22 02:47:16,471 INFO driver.impl :: e[34mRegistered driver :sqlitee[0m (parents: [:sql-jdbc]) :truck:

2023-03-22 02:47:16,481 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 Redirecting… for more details.

2023-03-22 02:47:16,481 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false

2023-03-22 02:47:16,481 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Vertica Driver"]e[0m

2023-03-22 02:47:16,494 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :redshift...e[0m

2023-03-22 02:47:16,495 INFO driver.impl :: e[34mRegistered driver :redshifte[0m (parents: [:postgres]) :truck:

2023-03-22 02:47:16,498 INFO plugins.dependencies :: Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'

2023-03-22 02:47:16,498 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? false

2023-03-22 02:47:16,499 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Presto JDBC Driver" "Metabase Presto Driver" "Metabase Vertica Driver"]e[0m

2023-03-22 02:47:16,501 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :druid...e[0m

2023-03-22 02:47:16,510 INFO driver.impl :: e[34mRegistered driver :druide[0m :truck:

2023-03-22 02:47:16,520 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :mongo...e[0m

2023-03-22 02:47:16,521 INFO driver.impl :: e[34mRegistered driver :mongoe[0m :truck:

2023-03-22 02:47:16,535 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 Redirecting… for more details.

2023-03-22 02:47:16,536 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false

2023-03-22 02:47:16,536 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Presto JDBC Driver" "Metabase Presto Driver" "Metabase Vertica Driver"]e[0m

2023-03-22 02:47:16,566 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :snowflake...e[0m

2023-03-22 02:47:16,567 INFO driver.impl :: e[34mRegistered driver :snowflakee[0m (parents: [:sql-jdbc]) :truck:

2023-03-22 02:47:16,579 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :googleanalytics...e[0m

2023-03-22 02:47:16,579 INFO driver.impl :: e[34mRegistered driver :googleanalyticse[0m :truck:

2023-03-22 02:47:16,585 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :bigquery-cloud-sdk...e[0m

2023-03-22 02:47:16,598 INFO driver.impl :: e[34mRegistered driver :bigquery-cloud-sdke[0m (parents: [:sql]) :truck:

2023-03-22 02:47:16,600 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto-common...e[0m

2023-03-22 02:47:16,606 INFO driver.impl :: e[34mRegistered abstract driver :presto-commone[0m :truck:

2023-03-22 02:47:16,607 INFO plugins.dependencies :: Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true

2023-03-22 02:47:16,607 INFO plugins.dependencies :: Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true

2023-03-22 02:47:16,608 DEBUG plugins.initialize :: e[33mDependencies satisfied; these plugins will now be loaded: ["Metabase Presto Driver" "Metabase Presto JDBC Driver"]e[0m

2023-03-22 02:47:16,609 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto...e[0m

2023-03-22 02:47:16,609 INFO driver.impl :: e[34mRegistered driver :prestoe[0m (parents: [:presto-common]) :truck:

2023-03-22 02:47:16,610 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto-jdbc...e[0m

2023-03-22 02:47:16,611 INFO driver.impl :: e[34mRegistered driver :presto-jdbce[0m (parents: [:presto-common]) :truck:

2023-03-22 02:47:16,612 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...

2023-03-22 02:47:16,624 INFO db.setup :: e[36mVerifying postgres Database Connection ...e[0m

Can you share the full logs? I don't see any errors from the logs or thats the end of the log file?

That is the end. Everything hangs once it gets to "Verifying postgres Database Connection"

ok so either:

  1. Metabase runs out of RAM and will never connect
  2. there's a firewall issue and Metabase can't connect
  3. the connection string is wrong