I am using MySQL database. Most of my dashboards are really slow and mostly several charts end up with ‘There was a problem displaying the chart’ error messages OR ‘Database has been closed’ message appears.
Version: 0.32.8
Few Logs:
Aug 07 10:53:56 ERROR metabase.middleware.log :: POST /api/card/2/query 500 58 ms (3 DB calls)
{:message “The database has been closed [90098-197]”,
:type org.h2.jdbc.JdbcSQLException,
:stacktrace
(“org.h2.message.DbException.getJdbcSQLException(DbException.java:357)”
“org.h2.message.DbException.get(DbException.java:179)”
“org.h2.message.DbException.get(DbException.java:155)”
“org.h2.message.DbException.get(DbException.java:144)”
“org.h2.engine.Database.checkPowerOff(Database.java:536)”
“org.h2.command.Command.executeQuery(Command.java:228)”
“org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)”
“com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)”
“clojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1072)”
“clojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1066)”
“clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1095)”
“clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1075)”
“clojure.java.jdbc$query.invokeStatic(jdbc.clj:1164)”
“clojure.java.jdbc$query.invoke(jdbc.clj:1126)”
“toucan.db$query.invokeStatic(db.clj:274)”
“toucan.db$query.doInvoke(db.clj:270)”
“clojure.lang.RestFn.invoke(RestFn.java:410)”
“–> models.user$permissions_set.invokeStatic(user.clj:280)”
“models.user$permissions_set.invoke(user.clj:272)”
“middleware.session$do_with_current_user$fn__58588.invoke(session.clj:175)”
“models.interface$current_user_permissions_set.invokeStatic(interface.clj:234)”
“models.interface$current_user_permissions_set.invoke(interface.clj:234)”
“models.interface$make_perms_check_fn$_has_perms_QMARK___24078.invoke(interface.clj:249)”
“models.interface$make_perms_check_fn$_has_perms_QMARK___24078.invoke(interface.clj:247)”
“models.interface$fn__24013$G__24004__24022.invoke(interface.clj:181)”
“api.common$read_check.invokeStatic(common.clj:367)”
“api.common$read_check.invoke(common.clj:360)”
“api.card$run_query_for_card_async.invokeStatic(card.clj:618)”
“api.card$run_query_for_card_async.doInvoke(card.clj:610)”
“api.card$fn__44661$fn__44664.invoke(card.clj:632)”
“api.card$fn__44661.invokeStatic(card.clj:631)”
“api.card$fn__44661.invoke(card.clj:627)”
“middleware.auth$enforce_authentication$fn__59926.invoke(auth.clj:14)”
“routes$fn__61084$fn__61085.doInvoke(routes.clj:56)”
“middleware.exceptions$catch_uncaught_exceptions$fn__60017.invoke(exceptions.clj:104)”
“middleware.exceptions$catch_api_exceptions$fn__60014.invoke(exceptions.clj:92)”
“middleware.log$log_api_call$fn__61458$fn__61459.invoke(log.clj:170)”
“middleware.log$log_api_call$fn__61458.invoke(log.clj:164)”
“middleware.security$add_security_headers$fn__59980.invoke(security.clj:105)”
“middleware.json$wrap_json_body$fn__61163.invoke(json.clj:61)”
“middleware.json$wrap_streamed_json_response$fn__61181.invoke(json.clj:97)”
“middleware.session$bind_current_user$fn__58593$fn__58594.invoke(session.clj:193)”
“middleware.session$do_with_current_user.invokeStatic(session.clj:176)”
“middleware.session$do_with_current_user.invoke(session.clj:170)”
“middleware.session$bind_current_user$fn__58593.invoke(session.clj:192)”
“middleware.session$wrap_current_user_id$fn__58582.invoke(session.clj:161)”
“middleware.session$wrap_session_id$fn__58567.invoke(session.clj:123)”
“middleware.auth$wrap_api_key$fn__59934.invoke(auth.clj:27)”
“middleware.misc$maybe_set_site_url$fn__61523.invoke(misc.clj:58)”
“middleware.misc$bind_user_locale$fn__61526.invoke(misc.clj:74)”
“middleware.misc$add_content_type$fn__61511.invoke(misc.clj:30)”
“middleware.misc$disable_streaming_buffering$fn__61548.invoke(misc.clj:119)”
“middleware.misc$wrap_gzip$fn__61541.invoke(misc.clj:101)”),
:sql-exception-chain [“JdbcSQLException:” “Message: The database has been closed [90098-197]” “SQLState: 90098” “Error Code: 90098”]}