My team is granted admin in our metabase, and currently having issue with creating dashboard. When dashboard is created, it proceeds, but when picking question, somehow it can't go through.
Cursor seems to unable to be clicked when choosing which question to add to dashboard.
So we had to keep replacing our existing dashboard with new question from there.
Is there anyone who knows how to solve this?
Some pictures:
- After dashboard was created, the question can't be clicked.
- I tried opening the server, to check real-time Troubleshooting>Logs. and this what came up when creating questions.
- The full code of error is as shown above. (When clicking)
- When left on standby (Create Dashboard > Ask a Question > Choosing Questions), this what came out.
- When dashboard is duplicated and edited, this what came out.
I wonder if it had something to do with our CT installation, but last year this problem never occurred.
The full response log when Asking a Question after creating dashboard is as follows:
2021-09-14 09:00:37 log [ERROR] GET /api/card 500 750.0 ms (4 DB calls)
{:message "An I/O error occurred while sending to the backend.",
:type org.postgresql.util.PSQLException,
:stacktrace
("org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:335)"
"org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)"
"org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)"
"org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)"
"org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)"
"clojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1072)"
"clojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1066)"
"clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1095)"
"clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1075)"
"clojure.java.jdbc$query.invokeStatic(jdbc.clj:1164)"
"clojure.java.jdbc$query.invoke(jdbc.clj:1126)"
"toucan.db$query.invokeStatic(db.clj:285)"
"toucan.db$query.doInvoke(db.clj:281)"
"clojure.lang.RestFn.invoke(RestFn.java:410)"
"toucan.db$simple_select.invokeStatic(db.clj:391)"
"toucan.db$simple_select.invoke(db.clj:380)"
"toucan.db$select.invokeStatic(db.clj:659)"
"toucan.db$select.doInvoke(db.clj:653)"
"clojure.lang.RestFn.applyTo(RestFn.java:139)"
"clojure.core$apply.invokeStatic(core.clj:667)"
"clojure.core$apply.invoke(core.clj:660)"
"toucan.db$select_field.invokeStatic(db.clj:682)"
"toucan.db$select_field.doInvoke(db.clj:674)"
"clojure.lang.RestFn.invoke(RestFn.java:521)"
"--> api.card$hydrate_favorites.invokeStatic(card.clj:55)"
"api.card$hydrate_favorites.invoke(card.clj:50)"
"api.card$cards_for_filter_option.invokeStatic(card.clj:133)"
"api.card$cards_for_filter_option.invoke(card.clj:131)"
"api.card$fn__47665.invokeStatic(card.clj:156)"
"api.card$fn__47665.invoke(card.clj:142)"
"middleware.auth$enforce_authentication$fn__64028.invoke(auth.clj:14)"
"routes$fn__65402$fn__65403.doInvoke(routes.clj:56)"
"middleware.exceptions$catch_uncaught_exceptions$fn__64127.invoke(exceptions.clj:104)"
"middleware.exceptions$catch_api_exceptions$fn__64124.invoke(exceptions.clj:92)"
"middleware.log$log_api_call$fn__65776$fn__65777.invoke(log.clj:170)"
"middleware.log$log_api_call$fn__65776.invoke(log.clj:164)"
"middleware.security$add_security_headers$fn__64090.invoke(security.clj:128)"
"middleware.json$wrap_json_body$fn__65481.invoke(json.clj:61)"
"middleware.json$wrap_streamed_json_response$fn__65499.invoke(json.clj:97)"
"middleware.session$bind_current_user$fn__61981$fn__61982.invoke(session.clj:193)"
"middleware.session$do_with_current_user.invokeStatic(session.clj:176)"
"middleware.session$do_with_current_user.invoke(session.clj:170)"
"middleware.session$bind_current_user$fn__61981.invoke(session.clj:192)"
"middleware.session$wrap_current_user_id$fn__61970.invoke(session.clj:161)"
"middleware.session$wrap_session_id$fn__61955.invoke(session.clj:123)"
"middleware.auth$wrap_api_key$fn__64036.invoke(auth.clj:27)"
"middleware.misc$maybe_set_site_url$fn__65803.invoke(misc.clj:56)"
"middleware.misc$bind_user_locale$fn__65806.invoke(misc.clj:72)"
"middleware.misc$add_content_type$fn__65791.invoke(misc.clj:28)"
"middleware.misc$disable_streaming_buffering$fn__65814.invoke(misc.clj:87)"),
:sql-exception-chain ["PSQLException:" "Message: An I/O error occurred while sending to the backend." "SQLState: 08006" "Error Code: 0"]}
Our Metabase Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.4+11",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "11.0.4",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.4+11",
"os.name": "Linux",
"os.version": "5.4.0-1046-gcp",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"bigquery",
"mysql",
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"run-mode": "prod",
"version": {
"date": "2019-09-20",
"tag": "v0.33.3",
"branch": "release-0.33.x",
"hash": "86d32bf"
},
"settings": {
"report-timezone": "Asia/Bangkok"
}
}
}
TLDR: Cursor error and can't ask a question after creating new dashboard.
Any helps/pointers will be very much appreciated, thank you!