AWS ECS MYSQL Connection Problem

Hey,

I would like to deploy Metabase in aws ecs and connect it to the rds mysql database. But when i do it looks ok first but then i got this error:

2024-03-26T14:20:00.247000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:20:00,247 INFO task.sync-databases :: Starting sync task for Database 1.

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:20:00,399 ERROR driver.util :: Failed to connect to Database

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "/plugins/sample-database.db" not found, and IFEXISTS=true, so we cant auto-create it [90146-214]

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.get(DbException.java:223)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.get(DbException.java:199)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.throwNotFound(Engine.java:186)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.openSession(Engine.java:72)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.openSession(Engine.java:222)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.createSession(Engine.java:201)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:122)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.Driver.connect(Driver.java:59)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invoke(jdbc.clj:1144)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invoke(jdbc.clj:1144)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:326)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:323)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_QMARK_$fn__50989.invoke(connection.clj:335)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection$fn__50971.invoke(connection.clj:311)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:165)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:154)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invokeStatic(connection.clj:309)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invoke(connection.clj:305)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:334)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:330)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.h2$fn__81124.invokeStatic(h2.clj:136)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.h2$fn__81124.invoke(h2.clj:118)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.lang.MultiFn.invoke(MultiFn.java:234)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.util$can_connect_with_details_QMARK_$fn__59800.invoke(util.clj:148)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.lang.AFn.call(AFn.java:18)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

2024-03-26T14:20:00.466000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.lang.Thread.run(Unknown Source)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:20:00,468 WARN task.sync-databases :: Cannot sync Database Sample Database: Database cannot be found.

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 clojure.lang.ExceptionInfo: Database cannot be found. {:message "Database cannot be found.", :errors {:db "check your connection string"}}

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:165)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:136)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.lang.RestFn.invoke(RestFn.java:442)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_$fn__106132$fn__106133.invoke(sync_databases.clj:87)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_$fn__106132.invoke(sync_databases.clj:86)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invokeStatic(sync_databases.clj:83)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases$sync_and_analyze_database_STAR__BANG_.invoke(sync_databases.clj:76)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:112)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:100)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:117)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "/plugins/sample-database.db" not found, and IFEXISTS=true, so we cant auto-create it [90146-214]

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.getJdbcSQLException(DbException.java:678)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.get(DbException.java:223)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.message.DbException.get(DbException.java:199)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.throwNotFound(Engine.java:186)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.openSession(Engine.java:72)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.openSession(Engine.java:222)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.Engine.createSession(Engine.java:201)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:122)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at org.h2.Driver.connect(Driver.java:59)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1111)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invoke(jdbc.clj:1144)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.java.jdbc$query.invoke(jdbc.clj:1144)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invokeStatic(connection.clj:326)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:323)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_QMARK_$fn__50989.invoke(connection.clj:335)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection$fn__50971.invoke(connection.clj:311)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:165)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:154)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invokeStatic(connection.clj:309)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$do_with_connection_spec_for_testing_connection.invoke(connection.clj:305)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:334)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:330)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.h2$fn__81124.invokeStatic(h2.clj:136)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.h2$fn__81124.invoke(h2.clj:118)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.lang.MultiFn.invoke(MultiFn.java:234)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at metabase.driver.util$can_connect_with_details_QMARK_$fn__59800.invoke(util.clj:148)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at clojure.lang.AFn.call(AFn.java:18)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

2024-03-26T14:20:00.475000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 at java.base/java.lang.Thread.run(Unknown Source)

2024-03-26T14:21:52.873000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:21:52,873 DEBUG middleware.log :: GET /api/health 200 546.9 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (30 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:21:52.881000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:21:52,881 DEBUG middleware.log :: GET /api/health 200 496.0 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (3 idle, 0 queued) (32 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:26:52.916000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:26:52,916 DEBUG middleware.log :: GET /api/health 200 347.7 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (30 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:26:52.927000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:26:52,927 DEBUG middleware.log :: GET /api/health 200 282.9 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (32 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:31:52.937000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:31:52,936 DEBUG middleware.log :: GET /api/health 200 537.3 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (30 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:31:52.987000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:31:52,987 DEBUG middleware.log :: GET /api/health 200 350.1 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (32 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:36:52.994000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:36:52,993 DEBUG middleware.log :: GET /api/health 200 416.3 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (30 total active threads) Queries in flight: 0 (0 queued)

2024-03-26T14:36:53.058000+00:00 service/metabase/923de36e6c614109b7383469cce35f33 2024-03-26 14:36:53,057 DEBUG middleware.log :: GET /api/health 200 329.3 µs (0 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (32 total active threads) Queries in flight: 0 (0 queued)

Do yo have any idea what is that?

Are you running a fork? Please post troubleshooting info