Hello,
Software looks amazing but unfortunately I’m having trouble even browsing the data in MySQL 5.5 or Mariadb 10.
Both give me this error:
Distinct, non-empty sequence of Field clauses
This happens without trying to create a custom report or anything. I click on the DB, click on any table and immediately get this error.
A RAW SQL query does indeed return data from the tables correctly.
:native nil,
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
("--> query_processor$fn__44044$receive_native_query__44049$fn__44050.invoke(query_processor.clj:236)"
"query_processor$query__GT_preprocessed.invokeStatic(query_processor.clj:257)"
"query_processor$query__GT_preprocessed.invoke(query_processor.clj:243)"
"query_processor$query__GT_native_with_spliced_params.invokeStatic(query_processor.clj:294)"
"query_processor$query__GT_native_with_spliced_params.invoke(query_processor.clj:284)"
"api.dataset$fn__47690.invokeStatic(dataset.clj:182)"
"api.dataset$fn__47690.invoke(dataset.clj:179)"
"middleware.auth$enforce_authentication$fn__64168.invoke(auth.clj:14)"
"routes$fn__65545$fn__65546.doInvoke(routes.clj:56)"
"middleware.exceptions$catch_uncaught_exceptions$fn__64267.invoke(exceptions.clj:104)"
"middleware.exceptions$catch_api_exceptions$fn__64264.invoke(exceptions.clj:92)"
"middleware.log$log_api_call$fn__65919$fn__65920.invoke(log.clj:170)"
"middleware.log$log_api_call$fn__65919.invoke(log.clj:164)"
"middleware.security$add_security_headers$fn__64230.invoke(security.clj:122)"
"middleware.json$wrap_json_body$fn__65624.invoke(json.clj:61)"
"middleware.json$wrap_streamed_json_response$fn__65642.invoke(json.clj:97)"
"middleware.session$bind_current_user$fn__60792$fn__60793.invoke(session.clj:209)"
"middleware.session$do_with_current_user.invokeStatic(session.clj:184)"
"middleware.session$do_with_current_user.invoke(session.clj:177)"
"middleware.session$bind_current_user$fn__60792.invoke(session.clj:208)"
"middleware.session$wrap_current_user_id$fn__60777.invoke(session.clj:161)"
"middleware.session$wrap_session_id$fn__60762.invoke(session.clj:123)"
"middleware.auth$wrap_api_key$fn__64176.invoke(auth.clj:27)"
"middleware.misc$maybe_set_site_url$fn__65946.invoke(misc.clj:56)"
"middleware.misc$bind_user_locale$fn__65949.invoke(misc.clj:72)"
"middleware.misc$add_content_type$fn__65934.invoke(misc.clj:28)"
"middleware.misc$disable_streaming_buffering$fn__65957.invoke(misc.clj:87)"),
:error "Distinct, non-empty sequence of Field clauses",
:query {:type "query", :query {:source-table 352}, :middleware {:disable-mbql->native? true}, :preprocessing-level 1},
:preprocessed nil,
:ex-data {:type :schema.core/error, :value (), :error (named (not ("Non-empty" a-clojure.lang.LazySeq)) "Distinct, non-empty sequence of Field clauses")},
:message "Error preprocessing query"}```
General info:
```{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.3+7",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.3",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.3+7",
"os.name": "Linux",
"os.version": "5.3.0-23-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "h2",
"run-mode": "prod",
"version": {
"date": "2019-11-13",
"tag": "v0.33.5.1",
"branch": "release-0.33.x",
"hash": "26159d2"
},
"settings": {
"report-timezone": null
}
}
}```