Hi.
Suddenly a collection we use quite a bit is empty. If we go to one of the questions that is stored in the collection the location on the top still lists the collection in question as its home but if any user navigates to the collection we get an message:
This collection is empty
Use collections to organize and group dashboards and questions for your team or yourself
I figured it was probably a change made to the permissions and went in made sure they are good. All users is listed as Curator.
Any ideas?
Hi @thendren
Post "Diagnostic Info" from Admin > Troubleshooting.
Make sure that you don't have a reverse-proxy or browser extension causing problems by intercepting requests.
I think I've also been running into the same issue. Here's some relevant diagnostic info:
[355c7295-b322-4fc0-abd4-20e5798bfde6] 2022-11-08T15:57:01-08:00 ERROR metabase.server.middleware.log GET /api/collection/332/items 500 40.4 ms (5 DB calls)
{:via
[{:type clojure.lang.ExceptionInfo,
:message "[[...]] clauses must contain at least one {{...}} clause.",
:data {:type :invalid-query},
:at [metabase.driver.common.parameters.parse$optional invokeStatic "parse.clj" 80]}],
:trace
[[metabase.driver.common.parameters.parse$optional invokeStatic "parse.clj" 80]
[metabase.driver.common.parameters.parse$optional doInvoke "parse.clj" 78]
[clojure.lang.RestFn applyTo "RestFn.java" 137]
[clojure.core$apply invokeStatic "core.clj" 667]
[clojure.core$apply invoke "core.clj" 662]
[metabase.driver.common.parameters.parse$fn__73692$parse_tokens_STAR___73697$fn__73698 invoke "parse.clj" 96]
[metabase.driver.common.parameters.parse$fn__73692$parse_tokens_STAR___73697 invoke "parse.clj" 84]
[metabase.driver.common.parameters.parse$fn__73734$parse_tokens__73739$fn__73740 invoke "parse.clj" 116]
[metabase.driver.common.parameters.parse$fn__73734$parse_tokens__73739 invoke "parse.clj" 114]
[metabase.driver.common.parameters.parse$fn__73768$parse__73773$fn__73774 invoke "parse.clj" 134]
[metabase.driver.common.parameters.parse$fn__73768$parse__73773 invoke "parse.clj" 125]
[metabase.api.collection$fully_parametrized_text_QMARK_ invokeStatic "collection.clj" 326]
[metabase.api.collection$fully_parametrized_text_QMARK_ invoke "collection.clj" 305]
[metabase.api.collection$fully_parametrized_query_QMARK_ invokeStatic "collection.clj" 337]
[metabase.api.collection$fully_parametrized_query_QMARK_ invoke "collection.clj" 334]
[metabase.api.collection$post_process_card_row invokeStatic "collection.clj" 344]
[metabase.api.collection$post_process_card_row invoke "collection.clj" 340]
[clojure.core$map$fn__5935 invoke "core.clj" 2770]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5467 invokeStatic "core.clj" 139]
[clojure.core.protocols$seq_reduce invokeStatic "protocols.clj" 24]
[clojure.core.protocols$fn__8236 invokeStatic "protocols.clj" 75]
[clojure.core.protocols$fn__8236 invoke "protocols.clj" 75]
[clojure.core.protocols$fn__8178$G__8173__8191 invoke "protocols.clj" 13]
[clojure.core$reduce invokeStatic "core.clj" 6886]
[clojure.core$cat$fn__8851 invoke "core.clj" 7693]
[clojure.core$map$fn__5931$fn__5932 invoke "core.clj" 2759]
[clojure.core.protocols$iter_reduce invokeStatic "protocols.clj" 49]
[clojure.core.protocols$fn__8230 invokeStatic "protocols.clj" 75]
[clojure.core.protocols$fn__8230 invoke "protocols.clj" 75]
[clojure.core.protocols$fn__8178$G__8173__8191 invoke "protocols.clj" 13]
[clojure.core$transduce invokeStatic "core.clj" 6947]
[clojure.core$into invokeStatic "core.clj" 6962]
[clojure.core$into invoke "core.clj" 6950]
[metabase.api.collection$post_process_rows invokeStatic "collection.clj" 435]
[metabase.api.collection$post_process_rows invoke "collection.clj" 429]
[metabase.api.collection$collection_children_STAR_ invokeStatic "collection.clj" 572]
[metabase.api.collection$collection_children_STAR_ invoke "collection.clj" 548]
[metabase.api.collection$fn__74913$collection_children__74918$fn__74925 invoke "collection.clj" 594]
[metabase.api.collection$fn__74913$collection_children__74918 invoke "collection.clj" 581]
[metabase.api.collection$fn__75004 invokeStatic "collection.clj" 647]
[metabase.api.collection$fn__75004 invoke "collection.clj" 632]
[compojure.core$wrap_response$fn__28102 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__28086 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__28091 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 151]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 153]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114 invoke "core.clj" 200]
[metabase.server.middleware.auth$enforce_authentication$fn__68961 invoke "auth.clj" 14]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114 invoke "core.clj" 200]
[compojure.core$make_context$handler__28142 invoke "core.clj" 289]
[compojure.core$make_context$fn__28146 invoke "core.clj" 299]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$make_context$fn__28146 invoke "core.clj" 300]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$make_context$fn__28146 invoke "core.clj" 300]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$make_context$fn__28146 invoke "core.clj" 300]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$make_context$fn__28146 invoke "core.clj" 300]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$make_context$fn__28146 invoke "core.clj" 300]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[metabase.api.routes$fn__79946$fn__79949 invoke "routes.clj" 60]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.core$apply invokeStatic "core.clj" 667]
[clojure.core$apply invoke "core.clj" 662]
[metabase.server.routes$fn__80101$fn__80102 doInvoke "routes.clj" 67]
[clojure.lang.RestFn invoke "RestFn.java" 436]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114 invoke "core.clj" 200]
[compojure.core$make_context$handler__28142 invoke "core.clj" 289]
[compojure.core$make_context$fn__28146 invoke "core.clj" 299]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__28095 invoke "core.clj" 152]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114$f__28115$respond_SINGLEQUOTE___28116 invoke "core.clj" 197]
[metabase.server.routes$fn__80087$fn__80089 invoke "routes.clj" 45]
[compojure.core$routes$fn__28114$f__28115 invoke "core.clj" 198]
[compojure.core$routes$fn__28114 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__76838 invoke "exceptions.clj" 98]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__76835 invoke "exceptions.clj" 86]
[metabase.server.middleware.log$log_api_call$fn__81513$fn__81514$fn__81515 invoke "log.clj" 211]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invokeStatic "diagnostic.clj" 15]
[metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info invoke "diagnostic.clj" 9]
[metabase.server.middleware.log$log_api_call$fn__81513$fn__81514 invoke "log.clj" 203]
[toucan.db$_do_with_call_counting invokeStatic "db.clj" 236]
[toucan.db$_do_with_call_counting invoke "db.clj" 229]
[metabase.server.middleware.log$log_api_call$fn__81513 invoke "log.clj" 202]
[metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__84613 invoke "browser_cookie.clj" 38]
[metabase.server.middleware.security$add_security_headers$fn__62353 invoke "security.clj" 149]
[metabase.server.middleware.json$wrap_json_body$fn__83571 invoke "json.clj" 63]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__83589 invoke "json.clj" 99]
[metabase.server.middleware.offset_paging$handle_paging$fn__62377 invoke "offset_paging.clj" 59]
[ring.middleware.keyword_params$wrap_keyword_params$fn__84880 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__84899 invoke "params.clj" 77]
[metabase.server.middleware.misc$maybe_set_site_url$fn__35782 invoke "misc.clj" 59]
[metabase.server.middleware.session$reset_session_timeout$fn__47474 invoke "session.clj" 377]
[metabase.server.middleware.session$bind_current_user$fn__47457$fn__47458 invoke "session.clj" 313]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 292]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 281]
[metabase.server.middleware.session$bind_current_user$fn__47457 invoke "session.clj" 312]
[metabase.server.middleware.session$wrap_current_user_info$fn__47439 invoke "session.clj" 262]
[metabase.server.middleware.session$wrap_session_id$fn__47423 invoke "session.clj" 195]
[metabase.server.middleware.auth$wrap_api_key$fn__68969 invoke "auth.clj" 27]
[ring.middleware.cookies$wrap_cookies$fn__84800 invoke "cookies.clj" 216]
[metabase.server.middleware.misc$add_content_type$fn__35765 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__35790 invoke "misc.clj" 76]
[ring.middleware.gzip$wrap_gzip$fn__84842 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__35793 invoke "misc.clj" 93]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__84629 invoke "ssl.clj" 48]
[metabase.server$async_proxy_handler$fn__80309 invoke "server.clj" 73]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.StatisticsHandler handle "StatisticsHandler.java" 181]
[org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 127]
[org.eclipse.jetty.server.Server handle "Server.java" 516]
[org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 487]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 732]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 479]
[org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 277]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 311]
[org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 105]
[org.eclipse.jetty.io.ChannelEndPoint$1 run "ChannelEndPoint.java" 104]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask "EatWhatYouKill.java" 338]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce "EatWhatYouKill.java" 315]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce "EatWhatYouKill.java" 173]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run "EatWhatYouKill.java" 131]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 409]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 883]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 1034]
[java.lang.Thread run nil -1]],
:cause "[[...]] clauses must contain at least one {{...}} clause.",
:data {:type :invalid-query},
:message "[[...]] clauses must contain at least one {{...}} clause."}