Unable to pick a saved query, no query is shown in the list

Alisa · August 11, 2020, 3:16pm

Hi,

I’m trying to ask a question using saves questions, but the list to pick Saved question is empty. I tried to refresh the “Pick your data” page - it did not helped, also tried other browser, which did not help also.
The interesting thing is I can see saved questions in test Metabase, which is almost similar to production one (only one our Vertica data base is connected in test Metabase, in production data base there are more Vertica connections). Below are configuration for test and production environments - please let me know if I should get any additional info.

PRODUCTION METABASE, NO SAVED QUESTIONS:
{
“browser-info”: {
“language”: “en”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36 OPR/69.0.3686.95”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10”,
“os.name”: “Linux”,
“os.version”: “4.14.146-119.123.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“postgres”,
“vertica”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “10.5”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-07-31”,
“tag”: “v0.36.2”,
“branch”: “release-0.36.x”,
“hash”: “13f0225”
},
“settings”: {
“report-timezone”: null
}
}
}

TEST METABASE, SAVED QUERIES ARE VIZIBLE:
{
“browser-info”: {
“language”: “en”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36 OPR/69.0.3686.95”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10”,
“os.name”: “Linux”,
“os.version”: “4.14.146-119.123.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“vertica”,
“h2”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “11.4”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-07-31”,
“tag”: “v0.36.2”,
“branch”: “release-0.36.x”,
“hash”: “13f0225”
},
“settings”: {
“report-timezone”: null
}
}
}

flamber · August 11, 2020, 3:32pm

Hi @Alisa
There are some limitations on Saved Questions, so you might be seeing one of those:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#picking-your-starting-data
But it could simply be a browser cache problem, so try doing a browser refresh.

Alisa · August 11, 2020, 4:40pm

I did try a browser refresh (it did not help); my saved questions should be available 'cause they do not satisfy condition stated (i.g. no Mongo, no Count column etc.)

flamber · August 11, 2020, 4:56pm

@Alisa I don’t have a Vertica database handy to test with, but is it the same problem if you just save a simple question on the Postgres database?
Try creating a question on production exactly equal to one that exists on test.
Unless you have deactivated “Nested queries” in Admin > Settings > General, then I really don’t know what the problem could be.

Alisa · August 11, 2020, 6:16pm

I did create a saved question in production database with Postgress Local metabase audit source - it is not visible in the list either((

flamber · August 11, 2020, 6:19pm

@Alisa Okay, I don’t know what’s wrong. Check the logs, and any settings that a different between the two instances.
I have never heard of this problem before.

Alisa · August 14, 2020, 1:30pm

Here is java error text I can see:

data: {via: Array(1), trace: Array(158), cause: “Not something with an ID: 38”, message: “Not something with an ID: 38”, type: “class java.lang.Exception”}
isCancelled: false
status: 500

flamber · August 14, 2020, 3:46pm

@Alisa There should be a full stacktrace in Admin > Troubleshooting > Logs.
But I guess something is broken on your production instance - possibly if you have manually edited the metadata, then it can cause corruption.

Alisa · August 14, 2020, 4:27pm

Here are logs from Metabase:

[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:47+03:00 DEBUG metabase.middleware.log GET /api/database 200 466.9 ms (9 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:48+03:00 DEBUG metabase.middleware.log GET /api/collection/175 200 33.5 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:48+03:00 INFO metabase.api.card Question’s average execution duration is 6.5 s; using ‘magic’ TTL of 21.6 mins
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:48+03:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 764:
{:source-table 317,
:filter [:and [:= [:field-id 6780] “USDT” “USDTALL”] [:= [:field-id 6793] “Deposit”]],
:breakout [[:field-id 6779] [:datetime-field [:field-id 6777] :day] [:field-id 6766] [:field-id 6780]],
:aggregation [[:sum [:field-id 6788]]],
:order-by [[:desc [:aggregation 0]]]}

[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:48+03:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 764:
{:source-table 317,
:filter [:and [:= [:field-id 6780] “USDT” “USDTALL”] [:= [:field-id 6793] “Deposit”]],
:breakout [[:field-id 6779] [:datetime-field [:field-id 6777] :day] [:field-id 6766] [:field-id 6780]],
:aggregation [[:sum [:field-id 6788]]],
:order-by [[:desc [:aggregation 0]]]}

[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:56+03:00 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash “a2964cc1”.
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:56+03:00 INFO metabase.query-processor.middleware.cache Query took 8.4 s to run; miminum for cache eligibility is 3.0 s
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:24:56+03:00 DEBUG metabase.middleware.log POST /api/card/779/query 202 [ASYNC: completed] 8.5 s (14 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (5 idle, 0 queued) (115 total active threads) Queries in flight: 0 (0 queued)
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:25:13+03:00 ERROR metabase.middleware.log GET /api/database/-1337/schemas 500 1.3 s (11 DB calls)
{:via [{:type java.lang.Exception, :message “Not something with an ID: 38”, :at [metabase.util$get_id invokeStatic “util.clj” 489]}],
:trace
[[metabase.util$get_id invokeStatic “util.clj” 489]
[metabase.util$get_id invoke “util.clj” 480]
[metabase.driver.util$database__GT_driver_STAR_ invokeStatic “util.clj” 64]
[metabase.driver.util$database__GT_driver_STAR_ invoke “util.clj” 61]
[clojure.lang.AFn applyToHelper “AFn.java” 154]
[clojure.lang.AFn applyTo “AFn.java” 144]
[clojure.core$apply invokeStatic “core.clj” 665]
[clojure.core$apply invoke “core.clj” 660]
[clojure.core.memoize$through_STAR_$fn__11207 invoke “memoize.clj” 107]
[clojure.core.cache$through$fn__10930 invoke “cache.clj” 55]
[clojure.core.memoize$through_STAR_$fn__11203$fn__11204 invoke “memoize.clj” 106]
[clojure.core.memoize.RetryingDelay deref “memoize.clj” 47]
[clojure.core$deref invokeStatic “core.clj” 2320]
[clojure.core$deref invoke “core.clj” 2306]
[clojure.core.memoize$cached_function$fn__11271 doInvoke “memoize.clj” 231]
[clojure.lang.RestFn applyTo “RestFn.java” 137]
[clojure.lang.AFunction$1 doInvoke “AFunction.java” 31]
[clojure.lang.RestFn invoke “RestFn.java” 408]
[metabase.api.database$card_database_supports_nested_queries_QMARK_ invokeStatic “database.clj” 82]
[metabase.api.database$card_database_supports_nested_queries_QMARK_ invoke “database.clj” 80]
[metabase.api.database$card_can_be_used_as_source_query_QMARK_ invokeStatic “database.clj” 115]
[metabase.api.database$card_can_be_used_as_source_query_QMARK_ invoke “database.clj” 112]
[clojure.core$filter$fn__5889$fn__5890 invoke “core.clj” 2805]
[clojure.core$completing$fn__8440 invoke “core.clj” 6868]
[clojure.core$map$fn__5862$fn__5863 invoke “core.clj” 2742]
[clojure.java.jdbc$init_reduce_rs invokeStatic “jdbc.clj” 1205]
[clojure.java.jdbc$init_reduce_rs invoke “jdbc.clj” 1197]
[clojure.java.jdbc$reducible_result_set_STAR_$reify__19180 reduce “jdbc.clj” 1227]
[clojure.core$reduce invokeStatic “core.clj” 6827]
[clojure.core$reduce invoke “core.clj” 6810]
[clojure.java.jdbc$query_reducer$fn__19186$fn__19189 invoke “jdbc.clj” 1262]
[clojure.java.jdbc$execute_query_with_params invokeStatic “jdbc.clj” 1091]
[clojure.java.jdbc$execute_query_with_params invoke “jdbc.clj” 1084]
[clojure.java.jdbc$db_query_with_resultset_STAR_ invokeStatic “jdbc.clj” 1113]
[clojure.java.jdbc$db_query_with_resultset_STAR_ invoke “jdbc.clj” 1093]
[clojure.java.jdbc$reducible_query$reify__19203 reduce “jdbc.clj” 1357]
[clojure.core$transduce invokeStatic “core.clj” 6883]
[clojure.core.Eduction reduce “core.clj” 7682]
[clojure.core$transduce invokeStatic “core.clj” 6883]
[clojure.core$transduce invoke “core.clj” 6870]
[metabase.api.database$source_query_cards invokeStatic “database.clj” 128]
[metabase.api.database$source_query_cards doInvoke “database.clj” 124]
[clojure.lang.RestFn invoke “RestFn.java” 397]
[metabase.api.database$cards_virtual_tables invokeStatic “database.clj” 152]
[metabase.api.database$cards_virtual_tables doInvoke “database.clj” 147]
[clojure.lang.RestFn invoke “RestFn.java” 397]
[metabase.api.database$fn__55232 invokeStatic “database.clj” 680]
[metabase.api.database$fn__55232 invoke “database.clj” 675]
[compojure.core$wrap_response$fn__1993 invoke “core.clj” 160]
[compojure.core$wrap_route_middleware$fn__1977 invoke “core.clj” 132]
[compojure.core$wrap_route_info$fn__1982 invoke “core.clj” 139]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 151]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 153]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[metabase.middleware.auth$enforce_authentication$fn__68489 invoke “auth.clj” 14]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[compojure.core$make_context$handler__2033 invoke “core.clj” 287]
[compojure.core$make_context$fn__2035 invoke “core.clj” 296]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$make_context$fn__2035 invoke “core.clj” 297]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[clojure.lang.AFn applyToHelper “AFn.java” 160]
[clojure.lang.AFn applyTo “AFn.java” 144]
[clojure.core$apply invokeStatic “core.clj” 665]
[clojure.core$apply invoke “core.clj” 660]
[metabase.routes$fn__70022$fn__70023 doInvoke “routes.clj” 56]
[clojure.lang.RestFn invoke “RestFn.java” 436]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[compojure.core$make_context$handler__2033 invoke “core.clj” 287]
[compojure.core$make_context$fn__2035 invoke “core.clj” 296]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 152]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 152]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005$f__2006$respond_SINGLEQUOTE___2007 invoke “core.clj” 197]
[compojure.core$wrap_route_matches$fn__1986 invoke “core.clj” 152]
[compojure.core$routes$fn__2005$f__2006 invoke “core.clj” 198]
[compojure.core$routes$fn__2005 invoke “core.clj” 200]
[metabase.middleware.exceptions$catch_uncaught_exceptions$fn__68592 invoke “exceptions.clj” 96]
[metabase.middleware.exceptions$catch_api_exceptions$fn__68589 invoke “exceptions.clj” 84]
[metabase.middleware.log$log_api_call$fn__70470$fn__70471 invoke “log.clj” 197]
[toucan.db$_do_with_call_counting invokeStatic “db.clj” 216]
[toucan.db$_do_with_call_counting invoke “db.clj” 209]
[metabase.middleware.log$log_api_call$fn__70470 invoke “log.clj” 191]
[metabase.middleware.security$add_security_headers$fn__68555 invoke “security.clj” 121]
[metabase.middleware.json$wrap_json_body$fn__70173 invoke “json.clj” 64]
[metabase.middleware.json$wrap_streamed_json_response$fn__70191 invoke “json.clj” 100]
[ring.middleware.keyword_params$wrap_keyword_params$fn__70771 invoke “keyword_params.clj” 55]
[ring.middleware.params$wrap_params$fn__70787 invoke “params.clj” 69]
[metabase.middleware.misc$maybe_set_site_url$fn__70501 invoke “misc.clj” 59]
[metabase.middleware.session$bind_current_user$fn__65051$fn__65052 invoke “session.clj” 204]
[metabase.middleware.session$do_with_current_user invokeStatic “session.clj” 186]
[metabase.middleware.session$do_with_current_user invoke “session.clj” 178]
[metabase.middleware.session$bind_current_user$fn__65051 invoke “session.clj” 203]
[metabase.middleware.session$wrap_current_user_info$fn__65038 invoke “session.clj” 169]
[metabase.middleware.session$wrap_session_id$fn__65026 invoke “session.clj” 127]
[metabase.middleware.auth$wrap_api_key$fn__68497 invoke “auth.clj” 27]
[ring.middleware.cookies$wrap_cookies$fn__70691 invoke “cookies.clj” 216]
[metabase.middleware.misc$add_content_type$fn__70486 invoke “misc.clj” 28]
[metabase.middleware.misc$disable_streaming_buffering$fn__70509 invoke “misc.clj” 76]
[ring.middleware.gzip$wrap_gzip$fn__70733 invoke “gzip.clj” 86]
[metabase.middleware.ssl$redirect_to_https_middleware$fn__70522 invoke “ssl.clj” 39]
[metabase.server$async_proxy_handler$fn__70248 invoke “server.clj” 72]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.HandlerWrapper handle “HandlerWrapper.java” 127]
[org.eclipse.jetty.server.Server handle “Server.java” 500]
[org.eclipse.jetty.server.HttpChannel lambda$handle$1 “HttpChannel.java” 383]
[org.eclipse.jetty.server.HttpChannel dispatch “HttpChannel.java” 547]
[org.eclipse.jetty.server.HttpChannel handle “HttpChannel.java” 375]
[org.eclipse.jetty.server.HttpConnection onFillable “HttpConnection.java” 273]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded “AbstractConnection.java” 311]
[org.eclipse.jetty.io.FillInterest fillable “FillInterest.java” 103]
[org.eclipse.jetty.io.ChannelEndPoint$2 run “ChannelEndPoint.java” 117]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask “EatWhatYouKill.java” 336]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce “EatWhatYouKill.java” 313]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce “EatWhatYouKill.java” 171]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run “EatWhatYouKill.java” 129]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run “ReservedThreadExecutor.java” 375]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob “QueuedThreadPool.java” 806]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run “QueuedThreadPool.java” 938]
[java.lang.Thread run nil -1]],
:cause “Not something with an ID: 38”,
:message “Not something with an ID: 38”,
:type java.lang.Exception}

[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:25:14+03:00 DEBUG metabase.middleware.log GET /api/database/-1337/schema/Risk%20Management%20%5BDepartment%5D 200 130.2 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (115 total active threads) Queries in flight: 0 (0 queued)
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:25:15+03:00 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:25:15+03:00 DEBUG metabase.middleware.log PUT /api/card/2174 202 [ASYNC: completed] 152.2 ms (13 DB calls) App DB connections: 1/15 Jetty threads: 2/50 (5 idle, 0 queued) (115 total active threads) Queries in flight: 0 (0 queued)
[12a029d1-7906-45b1-b5c4-4bc46063200b] 2020-08-14T17:25:15+03:00 DEBUG metabase.middleware.log GET /api/alert/question/2174 200 10.2 ms (1 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (5 idle, 0 queued) (115 total active threads) Queries in flight: 0 (0 queued)

flamber · August 14, 2020, 4:35pm

@Alisa I’m quite sure that you have a row with 38 somewhere, but then somewhere else, where Metabase expects data, that data has been removed.
Sounds like a corruption.

Alisa · August 14, 2020, 7:03pm

Sorry, can you please clarify your answer - I can not possibly search all database for value 38, there are tens of millions rows there - what does “somewhere else” mean: is it the same row with possible 38? What kind of data are expected? Is it possible to somehow narrow down the search area?

flamber · August 14, 2020, 7:53pm

@Alisa It is not related to your datasources - it’s sounds like a corruption in your application database.
I have no idea how you got to this problem, I’ve never seen it before.
Otherwise try setting up a new instance of Metabase.

Alisa · September 2, 2020, 7:09pm

For those who wonder, the problem was caused by one corrupted question (thou it’s not totally clear why was it corrupted) - the said question was located with the use of “Archived” sign in PostgreSQL Metabase Local audit base: if the question is archived, it’s not shown in Saved question list and thus cannot corrupt it.

aris_pg · February 22, 2021, 1:52pm

Hi @Alisa,

how did you find what was de question corrupted?

I have the same problem right now and I don’t know how to find this question.

Thanks in advace

aris_pg · February 22, 2021, 4:27pm

I solve it. Solution here