Hi !
I'm selfhosting metabase and i have set it up with the docker and jar way, nonetheless when i try to login it seems that is not working well, any lead? Im working with H2
Hi @Gonzalo
Post the full logs from startup until you try to login.
Migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
Im quite new how can i see the log trough moba?
org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1526)
at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1502)
at org.h2.jdbc.JdbcConnection.getAutoCommit(JdbcConnection.java:476)
at com.mchange.v2.c3p0.impl.C3P0ImplUtils.resetTxnState(C3P0ImplUtils.java:245)
at com.mchange.v2.c3p0.impl.NewPooledConnection.reset(NewPooledConnection.java:461)
at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:417)
at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:87)
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 toucan.db$query.invokeStatic(db.clj:288)
at toucan.db$query.doInvoke(db.clj:284)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at toucan.db$simple_select.invokeStatic(db.clj:394)
at toucan.db$simple_select.invoke(db.clj:383)
at toucan.db$simple_select_one.invokeStatic(db.clj:420)
at toucan.db$simple_select_one.invoke(db.clj:409)
at toucan.db$select_one.invokeStatic(db.clj:650)
at toucan.db$select_one.doInvoke(db.clj:644)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at toucan.db$select_one_field.invokeStatic(db.clj:662)
at toucan.db$select_one_field.doInvoke(db.clj:655)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.models.setting.cache$cache_out_of_date_QMARK_.invokeStatic(cache.clj:111)
at metabase.models.setting.cache$cache_out_of_date_QMARK_.invoke(cache.clj:92)
at metabase.models.setting.cache$restore_cache_if_needed_BANG_.invokeStatic(cache.clj:164)
at metabase.models.setting.cache$restore_cache_if_needed_BANG_.invoke(cache.clj:141)
at metabase.models.setting$db_or_cache_value.invokeStatic(setting.clj:391)
at metabase.models.setting$db_or_cache_value.invoke(setting.clj:383)
at metabase.models.setting$get_raw_value.invokeStatic(setting.clj:428)
at metabase.models.setting$get_raw_value.invoke(setting.clj:402)
at metabase.models.setting$get_raw_value.invokeStatic(setting.clj:442)
at metabase.models.setting$get_raw_value.invoke(setting.clj:402)
at metabase.models.setting$fn__30106.invokeStatic(setting.clj:461)
at metabase.models.setting$fn__30106.invoke(setting.clj:459)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.util.i18n.impl$fn__1646$f__1647.invoke(impl.clj:188)
at metabase.util.i18n.impl$site_locale_from_setting.invokeStatic(impl.clj:199)
at metabase.util.i18n.impl$site_locale_from_setting.invoke(impl.clj:192)
at metabase.util.i18n$site_locale_string.invokeStatic(i18n.clj:37)
at metabase.util.i18n$site_locale_string.invoke(i18n.clj:32)
at metabase.util.i18n$site_locale.invokeStatic(i18n.clj:50)
at metabase.util.i18n$site_locale.invoke(i18n.clj:47)
at metabase.util.i18n$translate_site_locale.invokeStatic(i18n.clj:69)
at metabase.util.i18n$translate_site_locale.doInvoke(i18n.clj:66)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.util.i18n.SiteLocalizedString.toString(i18n.clj:94)
at clojure.core$str.invokeStatic(core.clj:555)
at clojure.core$str.invoke(core.clj:546)
at metabase.core$destroy_BANG_.invokeStatic(core.clj:72)
at metabase.core$destroy_BANG_.invoke(core.clj:69)
at clojure.lang.AFn.run(AFn.java:22)
at java.base/java.lang.Thread.run(Thread.java:829)
thats what i get any lead?
@Gonzalo You are showing logs from when you shutdown Metabase.
Setup Metabase properly with Postgres or MariaDB/MySQL:
https://www.metabase.com/docs/latest/operations-guide/installing-metabase.html