Hello,
Any question that I create using the UI it doesn't get cached, caching only works with questions created using a native query. Any idea how this can be solved?
I get the following from logs:
[c8acb4c7-fba7-493e-8055-a8b751401f69] 2023-01-28T18:55:03+03:00 ERROR metabase.query-processor.middleware.cache Error saving query results to cache: backing-map
java.lang.NoSuchFieldException: backing-map
at java.base/java.lang.Class.getField(Unknown Source)
at taoensso.nippy$fn__28649$fn__28650$fn__28651.invoke(nippy.clj:1209)
at taoensso.nippy$fn__28649$fn__28650.invoke(nippy.clj:1207)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at taoensso.nippy$fn__28649.invokeStatic(nippy.clj:1207)
at taoensso.nippy$fn__28649.invoke(nippy.clj:1200)
at taoensso.nippy$fn__28443$G__28438__28450.invoke(nippy.clj:567)
at taoensso.nippy$fn__28474.invokeStatic(nippy.clj:576)
at taoensso.nippy$fn__28474.invoke(nippy.clj:569)
at taoensso.nippy$fn__28461$G__28456__28468.invoke(nippy.clj:568)
at taoensso.nippy$write_map$fn__28535$fn__28536.invoke(nippy.clj:887)
at taoensso.nippy$write_map$fn__28535.invoke(nippy.clj:884)
at clojure.lang.PersistentArrayMap.kvreduce(PersistentArrayMap.java:429)
at clojure.core$fn__8525.invokeStatic(core.clj:6908)
at clojure.core$fn__8525.invoke(core.clj:6888)
at clojure.core.protocols$fn__8257$G__8252__8266.invoke(protocols.clj:175)
at clojure.core$reduce_kv.invokeStatic(core.clj:6919)
at clojure.core$reduce_kv.invoke(core.clj:6910)
at taoensso.nippy$write_map.invokeStatic(nippy.clj:884)
at taoensso.nippy$write_map.invoke(nippy.clj:866)
at taoensso.nippy$fn__28639.invokeStatic(nippy.clj:1172)
at taoensso.nippy$fn__28639.invoke(nippy.clj:1172)
at taoensso.nippy$fn__28443$G__28438__28450.invoke(nippy.clj:567)
at taoensso.nippy$fn__28474.invokeStatic(nippy.clj:576)
at taoensso.nippy$fn__28474.invoke(nippy.clj:569)
at taoensso.nippy$fn__28461$G__28456__28468.invoke(nippy.clj:568)
at taoensso.nippy$write_vec$fn__28506$fn__28507.invoke(nippy.clj:751)
at taoensso.nippy$write_vec$fn__28506.invoke(nippy.clj:751)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at taoensso.nippy$write_vec.invokeStatic(nippy.clj:751)
at taoensso.nippy$write_vec.invoke(nippy.clj:729)
at taoensso.nippy$fn__28635.invokeStatic(nippy.clj:1170)
at taoensso.nippy$fn__28635.invoke(nippy.clj:1170)
at taoensso.nippy$fn__28443$G__28438__28450.invoke(nippy.clj:567)
at taoensso.nippy$fn__28474.invokeStatic(nippy.clj:576)
at taoensso.nippy$fn__28474.invoke(nippy.clj:569)
at taoensso.nippy$fn__28461$G__28456__28468.invoke(nippy.clj:568)
at taoensso.nippy$write_map$fn__28535$fn__28536.invoke(nippy.clj:887)
at taoensso.nippy$write_map$fn__28535.invoke(nippy.clj:884)
at clojure.lang.PersistentArrayMap.kvreduce(PersistentArrayMap.java:429)
at clojure.core$fn__8525.invokeStatic(core.clj:6908)
at clojure.core$fn__8525.invoke(core.clj:6888)
at clojure.core.protocols$fn__8257$G__8252__8266.invoke(protocols.clj:175)
at clojure.core$reduce_kv.invokeStatic(core.clj:6919)
at clojure.core$reduce_kv.invoke(core.clj:6910)
at taoensso.nippy$write_map.invokeStatic(nippy.clj:884)
at taoensso.nippy$write_map.invoke(nippy.clj:866)
at taoensso.nippy$fn__28639.invokeStatic(nippy.clj:1172)
at taoensso.nippy$fn__28639.invoke(nippy.clj:1172)
at taoensso.nippy$fn__28443$G__28438__28450.invoke(nippy.clj:567)
at taoensso.nippy$fn__28474.invokeStatic(nippy.clj:576)
at taoensso.nippy$fn__28474.invoke(nippy.clj:569)
at taoensso.nippy$fn__28461$G__28456__28468.invoke(nippy.clj:568)
at taoensso.nippy$write_map$fn__28535$fn__28536.invoke(nippy.clj:887)
at taoensso.nippy$write_map$fn__28535.invoke(nippy.clj:884)
at clojure.lang.PersistentArrayMap.kvreduce(PersistentArrayMap.java:429)
at clojure.core$fn__8525.invokeStatic(core.clj:6908)
at clojure.core$fn__8525.invoke(core.clj:6888)
at clojure.core.protocols$fn__8257$G__8252__8266.invoke(protocols.clj:175)
at clojure.core$reduce_kv.invokeStatic(core.clj:6919)
at clojure.core$reduce_kv.invoke(core.clj:6910)
at taoensso.nippy$write_map.invokeStatic(nippy.clj:884)
at taoensso.nippy$write_map.invoke(nippy.clj:866)
at taoensso.nippy$fn__28639.invokeStatic(nippy.clj:1172)
at taoensso.nippy$fn__28639.invoke(nippy.clj:1172)
at taoensso.nippy$fn__28443$G__28438__28450.invoke(nippy.clj:567)
at taoensso.nippy$fn__28474.invokeStatic(nippy.clj:576)
at taoensso.nippy$fn__28474.invoke(nippy.clj:569)
at taoensso.nippy$fn__28461$G__28456__28468.invoke(nippy.clj:568)
at taoensso.nippy$write_map$fn__28535$fn__28536.invoke(nippy.clj:887)
at taoensso.nippy$write_map$fn__28535.invoke(nippy.clj:884)
at clojure.lang.PersistentArrayMap.kvreduce(PersistentArrayMap.java:429)
at clojure.core$fn__8525.invokeStatic(core.clj:6908)
at clojure.core$fn__8525.invoke(core.clj:6888)
at clojure.core.protocols$fn__8257$G__8252__8266.invoke(protocols.clj:175)
at clojure.core$reduce_kv.invokeStatic(core.clj:6919)
at clojure.core$reduce_kv.invoke(core.clj:6910)
at taoensso.nippy$write_map.invokeStatic(nippy.clj:884)
at taoensso.nippy$write_map.invoke(nippy.clj:866)
at taoensso.nippy$fn__28639.invokeStatic(nippy.clj:1172)
at taoensso.nippy$fn__28639.invoke(nippy.clj:1172)
at taoensso.nippy$fn__28443$G__28438__28450.invoke(nippy.clj:567)
at taoensso.nippy$fn__28474.invokeStatic(nippy.clj:576)
at taoensso.nippy$fn__28474.invoke(nippy.clj:569)
at taoensso.nippy$fn__28461$G__28456__28468.invoke(nippy.clj:568)
at taoensso.nippy$freeze_to_out_BANG_.invokeStatic(nippy.clj:1011)
at taoensso.nippy$freeze_to_out_BANG_.invoke(nippy.clj:1008)
at metabase.query_processor.middleware.cache.impl$freeze_BANG_.invokeStatic(impl.clj:36)
at metabase.query_processor.middleware.cache.impl$freeze_BANG_.invoke(impl.clj:33)
at metabase.query_processor.middleware.cache.impl$do_with_serialization$in_STAR___49967$fn__49968.invoke(impl.clj:71)
at metabase.query_processor.middleware.cache.impl$do_with_serialization$in_STAR___49967.invoke(impl.clj:70)
at metabase.query_processor.middleware.cache$add_object_to_cache_BANG_.invokeStatic(cache.clj:64)
at metabase.query_processor.middleware.cache$add_object_to_cache_BANG_.invoke(cache.clj:60)
at metabase.query_processor.middleware.cache$save_results_xform$fn__53521.invoke(cache.clj:103)
at clojure.core$transduce.invokeStatic(core.clj:6948)
at clojure.core$transduce.invokeStatic(core.clj:6942)
at clojure.core$transduce.invoke(core.clj:6933)
at metabase.query_processor.context.default$default_reducef$fn__39686.invoke(default.clj:57)
at metabase.query_processor.context.default$default_reducef.invokeStatic(default.clj:56)
at metabase.query_processor.context.default$default_reducef.invoke(default.clj:48)
at metabase.query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___53557$fn__53558.invoke(cache.clj:192)
at metabase.query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:68)
at metabase.query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)
at metabase.query_processor.middleware.cache.impl$do_with_serialization.invokeStatic(impl.clj:58)
at metabase.query_processor.middleware.cache.impl$do_with_serialization.invoke(impl.clj:39)
at metabase.query_processor.middleware.cache$run_query_with_cache$reducef_SINGLEQUOTE___53557.invoke(cache.clj:188)
at metabase.query_processor.context$reducef.invokeStatic(context.clj:69)
at metabase.query_processor.context$reducef.invoke(context.clj:62)
at metabase.query_processor.context.default$default_runf$respond_STAR___39690.invoke(default.clj:68)
at metabase.driver.mongo.execute$reduce_results.invokeStatic(execute.clj:138)
at metabase.driver.mongo.execute$reduce_results.invoke(execute.clj:131)
at metabase.driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:169)
at metabase.driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)
at metabase.driver.mongo$fn__98833$f__97136__auto____98834.invoke(mongo.clj:246)
at metabase.driver.mongo.util$do_with_mongo_connection$fn__97127.invoke(util.clj:226)
at metabase.util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:139)
at metabase.util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:128)
at metabase.driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:220)
at metabase.driver.mongo.util$do_with_mongo_connection.invoke(util.clj:215)
at metabase.driver.mongo$fn__98833.invokeStatic(mongo.clj:245)
at metabase.driver.mongo$fn__98833.invoke(mongo.clj:243)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
at metabase.query_processor.context$executef.invoke(context.clj:48)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:67)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:65)
at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
at metabase.query_processor.context$runf.invoke(context.clj:39)
at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:9)
at metabase.query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:193)
at metabase.query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:178)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___53569.invoke(cache.clj:219)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__49259.invoke(permissions.clj:109)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__52514.invoke(mbql_to_native.clj:23)
at metabase.query_processor$fn__55045$combined_post_process__55050$combined_post_process_STAR___55051.invoke(query_processor.clj:212)
at metabase.query_processor$fn__55045$combined_pre_process__55046$combined_pre_process_STAR___55047.invoke(query_processor.clj:209)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53490$fn__53495.invoke(resolve_database_and_driver.clj:35)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:76)
at metabase.driver$do_with_driver.invoke(driver.clj:72)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__53490.invoke(resolve_database_and_driver.clj:34)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__49525.invoke(fetch_source_query.clj:314)
at metabase.query_processor.middleware.store$initialize_store$fn__49715$fn__49716.invoke(store.clj:11)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:45)
at metabase.query_processor.store$do_with_store.invoke(store.clj:39)
at metabase.query_processor.middleware.store$initialize_store$fn__49715.invoke(store.clj:10)
at metabase.query_processor.middleware.normalize_query$normalize$fn__53762.invoke(normalize_query.clj:22)
at metabase.query_processor.middleware.constraints$add_default_userland_constraints$fn__50803.invoke(constraints.clj:53)
at metabase.query_processor.middleware.process_userland_query$process_userland_query$fn__53701.invoke(process_userland_query.clj:145)
at metabase.query_processor.middleware.catch_exceptions$catch_exceptions$fn__54073.invoke(catch_exceptions.clj:167)
at metabase.query_processor.reducible$async_qp$qp_STAR___45514$thunk__45516.invoke(reducible.clj:100)
at metabase.query_processor.reducible$async_qp$qp_STAR___45514$fn__45518.invoke(reducible.clj:105)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.17+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.17",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.17+8",
"os.name": "Linux",
"os.version": "5.15.0-1026-aws",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"h2",
"googleanalytics",
"mongo"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.11"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.0"
}
},
"run-mode": "prod",
"version": {
"date": "2023-01-17",
"tag": "v0.45.2",
"branch": "release-x.45.x",
"hash": "819ce29"
},
"settings": {
"report-timezone": null
}
}
}