Hi,
I use Metabase v0.36.4. When I try to create a question (simple, custom, or native query) it works properly. but I can only save native query questions!! whenever I try to save a customer or simple question it gives me the following error: An error occurred
and I found this in the Google Chrome console:
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/97.0.4692.71 Safari/537.36",
"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.15.0-106-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"googleanalytics",
"postgres",
"redshift"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.27"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.5.1"
}
},
"run-mode": "prod",
"version": {
"date": "2020-08-17",
"tag": "v0.36.4",
"branch": "release-0.36.x",
"hash": "196c1f6"
},
"settings": {
"report-timezone": "Europe/Berlin"
}
}
}Hi @MohMansour. The Metabase version you're using is so old that the number of reasons that could be happening is huge. Please upgrade to the latest one (41.6) and try again
Actually, it could be a hard option to update the version right now, can you tell me some of the common reasons for this issue? Thanks in advance
Please post your backend logs so we can see if the backend is returning an error when you try to save a question. Please take into account that when using such old Metabase versions you might be affected by the security vulnerabilities mentioned here https://github.com/metabase/metabase/security/advisories
2022-01-17T10:00:54.712756632Z at metabase.query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10),
2022-01-17T10:00:54.712759009Z at metabase.query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22),
2022-01-17T10:00:54.712761364Z at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36),
2022-01-17T10:00:54.712763434Z at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147),
2022-01-17T10:00:54.712765585Z at metabase.query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42),
2022-01-17T10:00:54.712767630Z at metabase.query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136),
2022-01-17T10:00:54.712776090Z at metabase.query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174),
2022-01-17T10:00:54.712778655Z at metabase.query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101),
2022-01-17T10:00:54.712780888Z at metabase.query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107),
2022-01-17T10:00:54.712782825Z at metabase.query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133),
2022-01-17T10:00:54.712784730Z at metabase.query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132),
2022-01-17T10:00:54.712786745Z at clojure.lang.AFn.applyToHelper(AFn.java:156),
2022-01-17T10:00:54.712788653Z at clojure.lang.AFn.applyTo(AFn.java:144),
2022-01-17T10:00:54.712790867Z at clojure.core$apply.invokeStatic(core.clj:667),
2022-01-17T10:00:54.712793024Z at clojure.core$apply.invoke(core.clj:660),
2022-01-17T10:00:54.712795134Z at metabase.query_processor$process_userland_query.invokeStatic(query_processor.clj:213),
2022-01-17T10:00:54.712797498Z at metabase.query_processor$process_userland_query.doInvoke(query_processor.clj:209),
2022-01-17T10:00:54.712799856Z at clojure.lang.RestFn.invoke(RestFn.java:423),
2022-01-17T10:00:54.712802201Z at metabase.query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225),
2022-01-17T10:00:54.712804413Z at metabase.query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217),
2022-01-17T10:00:54.712806565Z at metabase.query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237),
2022-01-17T10:00:54.712808648Z at metabase.query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230),
2022-01-17T10:00:54.712810709Z at metabase.api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54),
2022-01-17T10:00:54.712812594Z at metabase.query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73),
2022-01-17T10:00:54.712814750Z at metabase.query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72),
2022-01-17T10:00:54.712816579Z at metabase.async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66),
2022-01-17T10:00:54.712818483Z at metabase.async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64),
2022-01-17T10:00:54.712820283Z at metabase.async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85),
2022-01-17T10:00:54.712822081Z at clojure.lang.AFn.applyToHelper(AFn.java:152),
2022-01-17T10:00:54.712823955Z at clojure.lang.AFn.applyTo(AFn.java:144),
2022-01-17T10:00:54.712825711Z at clojure.core$apply.invokeStatic(core.clj:665),
2022-01-17T10:00:54.712827486Z at clojure.core$with_bindings_STAR_.invokeStatic(core.clj:1973),
2022-01-17T10:00:54.712830820Z at clojure.core$with_bindings_STAR_.doInvoke(core.clj:1973),
2022-01-17T10:00:54.712832998Z at clojure.lang.RestFn.invoke(RestFn.java:425),
2022-01-17T10:00:54.712835373Z at clojure.lang.AFn.applyToHelper(AFn.java:156),
2022-01-17T10:00:54.712837566Z at clojure.lang.RestFn.applyTo(RestFn.java:132),
2022-01-17T10:00:54.712839510Z at clojure.core$apply.invokeStatic(core.clj:669),
2022-01-17T10:00:54.712841398Z at clojure.core$bound_fn_STAR_$fn__5749.doInvoke(core.clj:2003),
2022-01-17T10:00:54.712843172Z at clojure.lang.RestFn.invoke(RestFn.java:397),
2022-01-17T10:00:54.712844961Z at clojure.lang.AFn.run(AFn.java:22),
2022-01-17T10:00:54.712846978Z at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source),
2022-01-17T10:00:54.712848941Z at java.base/java.util.concurrent.FutureTask.run(Unknown Source),
2022-01-17T10:00:54.712850897Z at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source),
2022-01-17T10:00:54.712852859Z at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source),
2022-01-17T10:00:54.712855060Z at java.base/java.lang.Thread.run(Unknown Source),
2022-01-17T10:01:00.390800276Z 01-17 10:01:00 DEBUG middleware.log :: POST /api/dataset 202 [ASYNC: completed] 15.8 s (12 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (20 idle, 0 queued) (154 total active threads) Queries in flight: 0 (0 queued),
2022-01-17T10:01:10.513529452Z 01-17 10:01:10 DEBUG middleware.log :: GET /api/collection 200 32.3 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (19 idle, 0 queued) (153 total active threads) Queries in flight: 0 (0 queued),
2022-01-17T10:01:12.597706559Z 01-17 10:01:12 DEBUG middleware.log :: POST /api/card 400 11.3 ms (0 DB calls) ,
2022-01-17T10:01:12.597723522Z {:errors {:result_metadata "value may be nil, or if non-nil, value must be an array of valid results column metadata maps."}},
2022-01-17T10:01:12.597725991Z ,can you send some example simple/custom question that you're trying to save and doesn't? do these questions return a result?
if they do, what are the column types of the table you're using?
I use 2 fields only:
country: string
spend: float
and it gives me a chart that represents the answer normally.
Also, when I try to show all the table as it is (chart is an only table), I have the same issue
The happy thing is that we are seeking to update the version tomorrow. I will check after that and tell you. Thanks
updated and all is working well now. Thanks