I am getting below error suddenly and Metabase displays 504, Gateway timeout error on accessing URL. Logs are from AWS cloudwatch.
Warning: environ value jdk-11.0.11+9 for key :java-version has been overwritten with 11.0.11
2021-08-16 05:56:33,401 INFO metabase.util :: Maximum memory available to JVM: 494.9 MB
2021-08-16 05:56:50,062 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-08-16 05:57:02,168 INFO metabase.core ::
Metabase v0.39.4 (f538050 release-x.39.x)
Copyright © 2021 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2021-08-16 05:57:02,183 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2021-08-16 05:57:02,184 INFO metabase.core :: Starting Metabase in STANDALONE mode
2021-08-16 05:57:02,274 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 80}
2021-08-16 05:57:02,305 INFO metabase.core :: Starting Metabase version v0.39.4 (f538050 release-x.39.x) ...
2021-08-16 05:57:02,382 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.238-182.422.amzn2.x86_64",
"user.language" "en",
"user.timezone" "GMT"}
2021-08-16 05:57:02,384 INFO metabase.plugins :: Loading plugins in /app/plugins...
2021-08-16 05:57:02,674 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /app/plugins/sparksql.metabase-driver.jar
2021-08-16 05:57:03,435 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /app/plugins/bigquery.metabase-driver.jar
2021-08-16 05:57:03,441 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /app/plugins/sqlserver.metabase-driver.jar
2021-08-16 05:57:03,473 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /app/plugins/sqlite.metabase-driver.jar
2021-08-16 05:57:03,497 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /app/plugins/vertica.metabase-driver.jar
2021-08-16 05:57:03,498 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /app/plugins/redshift.metabase-driver.jar
2021-08-16 05:57:03,507 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /app/plugins/presto.metabase-driver.jar
2021-08-16 05:57:03,509 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /app/plugins/druid.metabase-driver.jar
2021-08-16 05:57:03,565 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /app/plugins/mongo.metabase-driver.jar
2021-08-16 05:57:03,601 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /app/plugins/google.metabase-driver.jar
2021-08-16 05:57:03,609 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /app/plugins/oracle.metabase-driver.jar
2021-08-16 05:57:03,610 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /app/plugins/snowflake.metabase-driver.jar
2021-08-16 05:57:03,901 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /app/plugins/googleanalytics.metabase-driver.jar
2021-08-16 05:57:04,302 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :athena...e[0m
2021-08-16 05:57:04,669 INFO driver.impl :: e[34mRegistered abstract driver :sqle[0m 🚚
e[32m ↙ Load driver :sql took 203.2 mse[0m
2021-08-16 05:57:04,691 INFO driver.impl :: e[34mRegistered abstract driver :sql-jdbce[0m (parents: [:sql]) 🚚
e[32mLoad driver :sql-jdbc took 391.1 mse[0m
2021-08-16 05:57:04,697 INFO driver.impl :: e[34mRegistered driver :athenae[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:04,708 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :google...e[0m
2021-08-16 05:57:04,763 INFO driver.impl :: e[34mRegistered abstract driver :googlee[0m 🚚
2021-08-16 05:57:04,773 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-08-16 05:57:04,775 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-08-16 05:57:04,776 WARN plugins.lazy-loaded-driver :: e[31mWarning: plugin manifest for :bigquery does not include connection propertiese[0m
2021-08-16 05:57:04,778 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :bigquery...e[0m
2021-08-16 05:57:04,780 INFO driver.impl :: e[34mRegistered driver :bigquerye[0m (parents: [:sql :google]) 🚚
2021-08-16 05:57:04,795 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlserver...e[0m
2021-08-16 05:57:04,796 INFO driver.impl :: e[34mRegistered driver :sqlservere[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:04,810 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-08-16 05:57:04,862 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2021-08-16 05:57:04,863 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Oracle Driver"]e[0m
2021-08-16 05:57:04,870 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlite...e[0m
2021-08-16 05:57:04,873 INFO driver.impl :: e[34mRegistered driver :sqlitee[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:04,883 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto...e[0m
2021-08-16 05:57:04,884 INFO driver.impl :: e[34mRegistered driver :prestoe[0m (parents: [:sql]) 🚚
2021-08-16 05:57:04,904 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :mongo...e[0m
2021-08-16 05:57:04,907 INFO driver.impl :: e[34mRegistered driver :mongoe[0m 🚚
2021-08-16 05:57:04,984 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :snowflake...e[0m
2021-08-16 05:57:04,985 INFO driver.impl :: e[34mRegistered driver :snowflakee[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:04,996 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-08-16 05:57:04,997 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2021-08-16 05:57:04,999 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]e[0m
2021-08-16 05:57:05,085 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :hive-like...e[0m
2021-08-16 05:57:05,089 INFO driver.impl :: e[34mRegistered abstract driver :hive-likee[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:05,090 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sparksql...e[0m
2021-08-16 05:57:05,091 INFO driver.impl :: e[34mRegistered driver :sparksqle[0m (parents: [:hive-like]) 🚚
2021-08-16 05:57:05,096 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-08-16 05:57:05,098 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-08-16 05:57:05,100 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :googleanalytics...e[0m
2021-08-16 05:57:05,101 INFO driver.impl :: e[34mRegistered driver :googleanalyticse[0m (parents: [:google]) 🚚
2021-08-16 05:57:05,106 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :redshift...e[0m
2021-08-16 05:57:05,191 INFO driver.impl :: e[34mRegistered driver :postgrese[0m (parents: [:sql-jdbc]) 🚚
e[32mLoad driver :postgres took 97.5 mse[0m
2021-08-16 05:57:05,205 INFO driver.impl :: e[34mRegistered driver :redshifte[0m (parents: [:postgres]) 🚚
2021-08-16 05:57:05,209 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :druid...e[0m
2021-08-16 05:57:05,262 INFO driver.impl :: e[34mRegistered driver :druide[0m 🚚
2021-08-16 05:57:05,270 INFO driver.impl :: e[34mRegistered driver :h2e[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:05,290 INFO driver.impl :: e[34mRegistered driver :mysqle[0m (parents: [:sql-jdbc]) 🚚
2021-08-16 05:57:05,305 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2021-08-16 05:57:05,309 INFO db.setup :: e[36mVerifying postgres Database Connection ...e[0m
2021-08-16 05:57:15,408 ERROR metabase.core :: Metabase Initialization FAILED
clojure.lang.ExceptionInfo: Unable to connect to Metabase postgres DB.
{}
at metabase.db.setup$fn__35507$verify_db_connection__35512$fn__35513$fn__35514.invoke(setup.clj:102)
at metabase.db.setup$fn__35507$verify_db_connection__35512$fn__35513.invoke(setup.clj:100)
at metabase.db.setup$fn__35507$verify_db_connection__35512.invoke(setup.clj:94)
at metabase.db.setup$setup_db_BANG_$fn__35542$fn__35543.invoke(setup.clj:142)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:687)
at metabase.util$do_with_us_locale.invoke(util.clj:673)
at metabase.db.setup$setup_db_BANG_$fn__35542.invoke(setup.clj:141)
at metabase.db.setup$setup_db_BANG_.invokeStatic(setup.clj:140)
at metabase.db.setup$setup_db_BANG_.invoke(setup.clj:136)
at metabase.db$setup_db_BANG_$fn__35556.invoke(db.clj:61)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:56)
at metabase.db$setup_db_BANG_.invoke(db.clj:51)
at metabase.core$init_BANG_.invokeStatic(core.clj:95)
at metabase.core$init_BANG_.invoke(core.clj:74)
at metabase.core$start_normally.invokeStatic(core.clj:139)
at metabase.core$start_normally.invoke(core.clj:133)
at metabase.core$_main.invokeStatic(core.clj:172)
at metabase.core$_main.doInvoke(core.clj:166)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:315)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:225)
at org.postgresql.Driver.makeConnection(Driver.java:465)
at org.postgresql.Driver.connect(Driver.java:264)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:199)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:196)
at metabase.db.setup$fn__35507$verify_db_connection__35512$fn__35513$fn__35514.invoke(setup.clj:100)
... 21 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at org.postgresql.core.PGStream.createSocket(PGStream.java:231)
at org.postgresql.core.PGStream.<init>(PGStream.java:95)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:98)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213)
... 40 more
2021-08-16 05:57:15,430 INFO metabase.core :: Metabase Shutting Down ...
2021-08-16 05:57:15,431 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2021-08-16 05:57:15,450 INFO metabase.core :: Metabase Shutdown COMPLETE
Can anyone please help or suggest for above error.