Metabase Querys Stopped Working

Hi, i am using metabase from like 6 months and i am loving it.

But now suddenly all the querys stopped working.

They keep loading and then it says that there was a problem with the question.

In the logs i see this:

Jun 22 13:51:52 ERROR metabase.driver.generic-sql.query-processor :: nil
Jun 22 13:51:52 WARN metabase.query-processor :: {:status :failed,
:class java.lang.Exception,
:error “Connections could not be acquired from the underlying database!”,
:stacktrace
[“driver.generic_sql.query_processor$do_with_try_catch.invokeStatic(query_processor.clj:313)”
“driver.generic_sql.query_processor$do_with_try_catch.invoke(query_processor.clj:309)”
“driver.generic_sql.query_processor$execute_query.invokeStatic(query_processor.clj:360)”
“driver.generic_sql.query_processor$execute_query.invoke(query_processor.clj:356)”
“driver$fn__22356$G__22349__22363.invoke(driver.clj:45)”
“query_processor$execute_query.invokeStatic(query_processor.clj:44)”
“query_processor$execute_query.invoke(query_processor.clj:38)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__25882.invoke(mbql_to_native.clj:30)”
“query_processor.middleware.annotate_and_sort$annotate_and_sort$fn__24471.invoke(annotate_and_sort.clj:37)”
“query_processor.middleware.limit$limit$fn__25854.invoke(limit.clj:14)”
“query_processor.middleware.cumulative_aggregations$cumulative_aggregation$fn__25715.invoke(cumulative_aggregations.clj:46)”
“query_processor.middleware.cumulative_aggregations$cumulative_aggregation$fn__25715.invoke(cumulative_aggregations.clj:46)”
“query_processor.middleware.format_rows$format_rows$fn__25845.invoke(format_rows.clj:21)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__24151.invoke(add_row_count_and_status.clj:14)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__25735.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__26930.invoke(resolve_driver.clj:14)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__24551.invoke(cache.clj:146)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__25657.invoke(catch_exceptions.clj:51)”
“query_processor$process_query.invokeStatic(query_processor.clj:69)”
“query_processor$process_query.invoke(query_processor.clj:64)”
“query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:190)”
“query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:185)”
“query_processor$fn__26961$dataset_query__26966$fn__26967.invoke(query_processor.clj:223)”
“query_processor$fn__26961$dataset_query__26966.invoke(query_processor.clj:209)”
“api.dataset$fn__28474$fn__28477.invoke(dataset.clj:39)”
“api.common.internal$do_with_caught_api_exceptions.invokeStatic(internal.clj:229)”
“api.common.internal$do_with_caught_api_exceptions.invoke(internal.clj:224)”
“api.dataset$fn__28474.invokeStatic(dataset.clj:33)”
“api.dataset$fn__28474.invoke(dataset.clj:33)”
“middleware$enforce_authentication$fn__38784.invoke(middleware.clj:120)”
“api.routes$fn__38910.invokeStatic(routes.clj:59)”
“api.routes$fn__38910.invoke(routes.clj:59)”
“routes$fn__39540$fn__39541.doInvoke(routes.clj:64)”
“routes$fn__39540.invokeStatic(routes.clj:60)”
“routes$fn__39540.invoke(routes.clj:60)”
“middleware$log_api_call$fn__38883$fn__38885.invoke(middleware.clj:329)”
“middleware$log_api_call$fn__38883.invoke(middleware.clj:328)”
“middleware$add_security_headers$fn__38833.invoke(middleware.clj:243)”
“middleware$bind_current_user$fn__38788.invoke(middleware.clj:140)”
“middleware$maybe_set_site_url$fn__38837.invoke(middleware.clj:266)”],
:query
{:type “query”,
:query {:source_table 59, :aggregation [[“count”]]},
:parameters [],
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:info
{:executed-by 1,
:context :ad-hoc,
:query-hash [38, -111, 67, 125, -106, 126, 80, 123, 117, 86, -28, -42, -50, 28, 121, -63, -126, -75, 3, -111, -82, 70, 12, -85, -124, -125, 127, -101, -43, 83, -20, 48],
:query-type “MBQL”}},
:expanded-query
{:type “query”,
:query {:source-table {:schema nil, :name “emails_masivos_destinatarios”, :id 59}, :aggregation [{:aggregation-type :count, :custom-name nil}], :join-tables nil},
:parameters [],
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:info
{:executed-by 1,
:context :ad-hoc,
:query-hash [38, -111, 67, 125, -106, 126, 80, 123, 117, 86, -28, -42, -50, 28, 121, -63, -126, -75, 3, -111, -82, 70, 12, -85, -124, -125, 127, -101, -43, 83, -20, 48],
:query-type “MBQL”},
:fk-field-ids #{}}}

Jun 22 13:51:52 WARN metabase.query-processor :: Query failure: Connections could not be acquired from the underlying database!
[“query_processor$assert_query_status_successful.invokeStatic(query_processor.clj:159)”
“query_processor$assert_query_status_successful.invoke(query_processor.clj:152)”
“query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:191)”
“query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:185)”
“query_processor$fn__26961$dataset_query__26966$fn__26967.invoke(query_processor.clj:223)”
“query_processor$fn__26961$dataset_query__26966.invoke(query_processor.clj:209)”
“api.dataset$fn__28474$fn__28477.invoke(dataset.clj:39)”
“api.common.internal$do_with_caught_api_exceptions.invokeStatic(internal.clj:229)”
“api.common.internal$do_with_caught_api_exceptions.invoke(internal.clj:224)”
“api.dataset$fn__28474.invokeStatic(dataset.clj:33)”
“api.dataset$fn__28474.invoke(dataset.clj:33)”
“middleware$enforce_authentication$fn__38784.invoke(middleware.clj:120)”
“api.routes$fn__38910.invokeStatic(routes.clj:59)”
“api.routes$fn__38910.invoke(routes.clj:59)”
“routes$fn__39540$fn__39541.doInvoke(routes.clj:64)”
“routes$fn__39540.invokeStatic(routes.clj:60)”
“routes$fn__39540.invoke(routes.clj:60)”
“middleware$log_api_call$fn__38883$fn__38885.invoke(middleware.clj:329)”
“middleware$log_api_call$fn__38883.invoke(middleware.clj:328)”
“middleware$add_security_headers$fn__38833.invoke(middleware.clj:243)”
“middleware$bind_current_user$fn__38788.invoke(middleware.clj:140)”
“middleware$maybe_set_site_url$fn__38837.invoke(middleware.clj:266)”]

Jun 22 13:51:53 DEBUG metabase.middleware :: POST /api/dataset 200 (47 s) (12 DB calls)

Nevermind, it was a permisson issue. How do i delete this?

hello cagiraudo, I have the same issue, Metabase was working well and suddenly it stops with the same errors

The :blue_book: Troubleshooting Guide has a good database page!