Xray crashes

peterb · December 2, 2021, 10:47am

Hi,

We have a simple query, build using the custom query option. SQL looks like this:

SELECT surveys__via__survey_id.label AS surveys__via__survey_id__label, sum(CASE WHEN (answers.score >= 0
AND answers.score <= 6) THEN 1 ELSE 0.0 END) AS Detractors, sum(CASE WHEN (answers.score >= 7 AND answers.score <= 8) THEN 1 ELSE 0.0 END) AS Passives, sum(CASE WHEN (answers.score >= 9 AND answers.score <= 10) THEN 1 ELSE 0.0 END) AS Promotors
FROM answers
LEFT JOIN responses responses - response_id ON answers.response_id = responses - response_id.id LEFT JOIN flattened_metadata flattened_metadata ON responses - response_id.id = flattened_metadata.response_id LEFT JOIN questions questions__via__question_id ON answers.question_id = questions__via__question_id.id LEFT JOIN surveys surveys__via__survey_id ON answers.survey_id = surveys__via__survey_id.id
WHERE (questions__via__question_id.indicator = 'nps' AND answers.survey_id = 'b41aa1e2-dfbe-11eb-94d4-06d041a7f064')
GROUP BY surveys__via__survey_id.label
ORDER BY surveys__via__survey_id.label ASC

when we click the xray option, we get this error:

(conn=11110) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1

Logs:

[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:55+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 2.6 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:55+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 4.1 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (17 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:55+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 5.3 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:55+01:00 DEBUG metabase.server.middleware.log GET /api/setting 200 656.6 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:55+01:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 15.3 ms (11 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:59+01:00 DEBUG metabase.server.middleware.log PUT /api/setting/enable-xrays 204 12.0 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:59+01:00 DEBUG metabase.server.middleware.log GET /api/setting 200 650.1 µs (0 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (17 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:27:59+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 4.9 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (17 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:04+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 2.6 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:04+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 4.0 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (17 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:04+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 2.9 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (18 idle, 0 queued) (138 total active threads) Queries in flight: 0 (0 queued)
[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:04+01:00 ERROR metabase.models.params Could not find matching Field ID for target: [:dimension [:template-tag created_at]]
clojure.lang.ExceptionInfo: Output of unwrap-field-clause does not match schema:
[(not (present? :field)) (not (present? "id-or-name")) (not (present? "options"))]
{:type :schema.core/error, :schema (constrained [(one (eq :field) :field) (one (cond-pre (constrained Int "positive integer") (constrained Str "Non-blank string")) "id-or-name") (one (maybe (recursive (var metabase.mbql.schema/FieldOptions))) "options")] ":field clauses using a string field name must specify :base-type."), :value nil, :error [(not (present? :field)) (not (present? "id-or-name")) (not (present? "options"))]}
at metabase.models.params$fn__44783$unwrap_field_clause__44788.invoke(params.clj:21)
at metabase.models.params$fn__44825$param_target__GT_field_clause__44830$fn__44831.invoke(params.clj:81)
at metabase.models.params$fn__44825$param_target__GT_field_clause__44830.invoke(params.clj:73)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934$iter__44935__44941$fn__44942$iter__44937__44943$fn__44944$fn__44945.invoke(params.clj:189)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934$iter__44935__44941$fn__44942$iter__44937__44943$fn__44944.invoke(params.clj:187)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934$iter__44935__44941$fn__44942.invoke(params.clj:187)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:58)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
....

flamber · December 2, 2021, 10:54am

Hi @peterb
Please post "Diagnostic Info" from Admin > Troubleshooting.
And can you include the full stacktrace from Admin > Troubleshooting > Logs, when you do the X-ray?

peterb · December 2, 2021, 11:03am

{
"browser-info": {
"language": "en-IN",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.1 Safari/605.1.15",
"vendor": "Apple Computer, Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "4.14.252-195.483.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.26"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-11-09",
"tag": "v1.41.2",
"branch": "release-x.41.x",
"hash": "ad599fd"
},
"settings": {
"report-timezone": null
}
}
}

peterb · December 2, 2021, 11:03am

Logs are 3mb

flamber · December 2, 2021, 11:08am

@peterb The stacktrace that occurs, when you try to X-ray should only be few hundred lines. I'm not asking for all your logs, just the interesting parts that happens when you hit an error.

peterb · December 2, 2021, 12:48pm

[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:04+01:00 ERROR metabase.models.params Could not find matching Field ID for target: [:dimension [:template-tag created_at]]
clojure.lang.ExceptionInfo: Output of unwrap-field-clause does not match schema:
[(not (present? :field)) (not (present? "id-or-name")) (not (present? "options"))]
{:type :schema.core/error, :schema (constrained [(one (eq :field) :field) (one (cond-pre (constrained Int "positive integer") (constrained Str "Non-blank string")) "id-or-name") (one (maybe (recursive (var metabase.mbql.schema/FieldOptions))) "options")] ":field clauses using a string field name must specify :base-type."), :value nil, :error [(not (present? :field)) (not (present? "id-or-name")) (not (present? "options"))]}
at metabase.models.params$fn__44783$unwrap_field_clause__44788.invoke(params.clj:21)
at metabase.models.params$fn__44825$param_target__GT_field_clause__44830$fn__44831.invoke(params.clj:81)
at metabase.models.params$fn__44825$param_target__GT_field_clause__44830.invoke(params.clj:73)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934$iter__44935__44941$fn__44942$iter__44937__44943$fn__44944$fn__44945.invoke(params.clj:189)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934$iter__44935__44941$fn__44942$iter__44937__44943$fn__44944.invoke(params.clj:187)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934$iter__44935__44941$fn__44942.invoke(params.clj:187)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:58)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$set.invokeStatic(core.clj:4101)
at clojure.core$set.invoke(core.clj:4093)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933$fn__44934.invoke(params.clj:192)
at metabase.models.params$fn__44928$dashboard__GT_parameter_mapping_field_clauses__44933.invoke(params.clj:183)
at metabase.models.params$fn__44993$dashboard__GT_param_field_ids__44998$fn__44999.invoke(params.clj:211)
at metabase.models.params$fn__44993$dashboard__GT_param_field_ids__44998.invoke(params.clj:205)
at metabase.models.params$fn__45023.invokeStatic(params.clj:226)
at metabase.models.params$fn__45023.invoke(params.clj:225)
at clojure.lang.MultiFn.invoke(MultiFn.java:229)
at clojure.lang.Var.invoke(Var.java:384)
at toucan.hydrate$simple_hydrate$iter__34243__34247$fn__34248.invoke(hydrate.clj:262)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at toucan.hydrate$simple_hydrate$iter__34243__34247$fn__34248.invoke(hydrate.clj:257)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.LazySeq.first(LazySeq.java:73)
at clojure.lang.RT.first(RT.java:692)
at clojure.core$first__5401.invokeStatic(core.clj:55)
at clojure.core$first__5401.invoke(core.clj:55)
at toucan.hydrate$hydrate.invokeStatic(hydrate.clj:433)
at toucan.hydrate$hydrate.doInvoke(hydrate.clj:343)
at clojure.lang.RestFn.invoke(RestFn.java:521)
at metabase.api.dashboard$get_dashboard.invokeStatic(dashboard.clj:213)
at metabase.api.dashboard$get_dashboard.invoke(dashboard.clj:205)
at metabase.api.dashboard$fn__74568.invokeStatic(dashboard.clj:253)
at metabase.api.dashboard$fn__74568.invoke(dashboard.clj:250)
at compojure.core$wrap_response$fn__31926.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__31910.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__31915.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:151)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:153)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__71006.invoke(auth.clj:14)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at compojure.core$make_context$handler__31966.invoke(core.clj:289)
at compojure.core$make_context$fn__31970.invoke(core.clj:299)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:199)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:199)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:199)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at metabase.api.routes$fn__80483$fn__80484.invoke(routes.clj:54)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.server.routes$fn__80628$fn__80629.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at compojure.core$make_context$handler__31966.invoke(core.clj:289)
at compojure.core$make_context$fn__31970.invoke(core.clj:299)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__31919.invoke(core.clj:152)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:199)
at compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940.invoke(core.clj:197)
at compojure.core$make_context$fn__31970.invoke(core.clj:300)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at compojure.core$routes$fn__31938$f__31939.invoke(core.clj:198)
at compojure.core$routes$fn__31938.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__78088.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__78085.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__82681$fn__82682$fn__82683.invoke(log.clj:209)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__82681$fn__82682.invoke(log.clj:201)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$_do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__82681.invoke(log.clj:200)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__87922.invoke(browser_cookie.clj:30)
at metabase.server.middleware.security$add_security_headers$fn__59939.invoke(security.clj:147)
at metabase.server.middleware.json$wrap_json_body$fn__85223.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__85241.invoke(json.clj:98)
at metabase.server.middleware.offset_paging$handle_paging$fn__59963.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__88189.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__88205.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__33937.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__45983$fn__45984.invoke(session.clj:257)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:238)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:230)
at metabase.server.middleware.session$bind_current_user$fn__45983.invoke(session.clj:256)
at metabase.server.middleware.session$wrap_current_user_info$fn__45970.invoke(session.clj:216)
at metabase.server.middleware.session$wrap_session_id$fn__45956.invoke(session.clj:162)
at metabase.server.middleware.auth$wrap_api_key$fn__71014.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__88109.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__33920.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__33945.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__88151.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__33948.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__87938.invoke(ssl.clj:48)
at metabase.server$async_proxy_handler$fn__82454.invoke(server.clj:71)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Unknown Source)

.......

[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:09+01:00 ERROR metabase.server.middleware.log GET /api/automagic-dashboards/question/213/cell/WyI9IixbImZpZWxkIiw4NSx7InNvdXJjZS1maWVsZCI6NDF9XSwiQmxva2tlciB8IE5QUyJd 500 101.8 ms (44 DB calls)
{:via
[{:type java.sql.SQLSyntaxErrorException,
:message
"(conn=10471) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1",
:at [org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory createException "ExceptionFactory.java" 62]}
{:type org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
:message
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1",
:at [org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException of "MariaDbSqlException.java" 34]}
{:type java.sql.SQLException,
:message
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1",
:at [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1688]}],
:trace
[[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1688]
[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readPacket "AbstractQueryProtocol.java" 1550]
[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol getResult "AbstractQueryProtocol.java" 1513]
[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol executeQuery "AbstractQueryProtocol.java" 318]
[org.mariadb.jdbc.ClientSidePreparedStatement executeInternal "ClientSidePreparedStatement.java" 220]
[org.mariadb.jdbc.ClientSidePreparedStatement execute "ClientSidePreparedStatement.java" 149]
[org.mariadb.jdbc.ClientSidePreparedStatement executeQuery "ClientSidePreparedStatement.java" 163]
[com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeQuery "NewProxyPreparedStatement.java" 431]
[clojure.java.jdbc$execute_query_with_params invokeStatic "jdbc.clj" 1090]
[clojure.java.jdbc$execute_query_with_params invoke "jdbc.clj" 1084]
[clojure.java.jdbc$db_query_with_resultset_STAR_ invokeStatic "jdbc.clj" 1113]
[clojure.java.jdbc$db_query_with_resultset_STAR_ invoke "jdbc.clj" 1093]
[clojure.java.jdbc$query invokeStatic "jdbc.clj" 1182]
[clojure.java.jdbc$query invoke "jdbc.clj" 1144]
[toucan.db$query invokeStatic "db.clj" 288]
[toucan.db$query doInvoke "db.clj" 284]
[clojure.lang.RestFn invoke "RestFn.java" 410]
[toucan.db$simple_select invokeStatic "db.clj" 394]
[toucan.db$simple_select invoke "db.clj" 383]
[toucan.db$simple_select_one invokeStatic "db.clj" 420]
[toucan.db$simple_select_one invoke "db.clj" 409]
[toucan.db$select_one invokeStatic "db.clj" 627]
[toucan.db$select_one doInvoke "db.clj" 620]
[clojure.lang.RestFn applyTo "RestFn.java" 139]
[clojure.lang.Var applyTo "Var.java" 705]
[clojure.core$apply invokeStatic "core.clj" 673]
[clojure.core$apply invoke "core.clj" 662]
[toucan.models$invoke_model invokeStatic "models.clj" 380]
[toucan.models$invoke_model doInvoke "models.clj" 368]
[clojure.lang.RestFn invoke "RestFn.java" 445]
[toucan.models$invoke_model invokeStatic "models.clj" 378]
[toucan.models$invoke_model invoke "models.clj" 368]
[clojure.lang.AFn applyToHelper "AFn.java" 156]
[clojure.lang.RestFn applyTo "RestFn.java" 132]
[clojure.core$apply invokeStatic "core.clj" 669]
[clojure.core$apply invoke "core.clj" 662]
[toucan.models$invoke_model_or_instance invokeStatic "models.clj" 395]
[toucan.models$invoke_model_or_instance doInvoke "models.clj" 391]
[clojure.lang.RestFn invoke "RestFn.java" 423]
[metabase.models.field.FieldInstance invoke "field.clj" 61]
[metabase.automagic_dashboards.core$__GT_field invokeStatic "core.clj" 52]
[metabase.automagic_dashboards.core$__GT_field invoke "core.clj" 45]
[metabase.automagic_dashboards.core$filter_referenced_fields$fn__67188$iter__67192__67196$fn__67197$fn__67198
invoke
"core.clj"
978]
[metabase.automagic_dashboards.core$filter_referenced_fields$fn__67188$iter__67192__67196$fn__67197
invoke
"core.clj"
977]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5419 invokeStatic "core.clj" 139]
[clojure.core$concat$fn__5510 invoke "core.clj" 727]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5419 invokeStatic "core.clj" 139]
[clojure.core$concat$cat__5512$fn__5513 invoke "core.clj" 736]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5419 invokeStatic "core.clj" 139]
[clojure.core$filter$fn__5911 invoke "core.clj" 2813]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5419 invokeStatic "core.clj" 139]
[clojure.core.protocols$seq_reduce invokeStatic "protocols.clj" 24]
[clojure.core.protocols$fn__8168 invokeStatic "protocols.clj" 75]
[clojure.core.protocols$fn__8168 invoke "protocols.clj" 75]
[clojure.core.protocols$fn__8110$G__8105__8123 invoke "protocols.clj" 13]
[clojure.core$reduce invokeStatic "core.clj" 6830]
[clojure.core$into invokeStatic "core.clj" 6897]
[clojure.core$into invoke "core.clj" 6889]
[metabase.automagic_dashboards.core$filter_referenced_fields invokeStatic "core.clj" 980]
[metabase.automagic_dashboards.core$filter_referenced_fields invoke "core.clj" 971]
[metabase.automagic_dashboards.core$automagic_dashboard invokeStatic "core.clj" 1011]
[metabase.automagic_dashboards.core$automagic_dashboard invoke "core.clj" 982]
[metabase.automagic_dashboards.core$fn__67315 invokeStatic "core.clj" 1208]
[metabase.automagic_dashboards.core$fn__67315 invoke "core.clj" 1191]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.api.automagic_dashboards$fn__79162 invokeStatic "automagic_dashboards.clj" 131]
[metabase.api.automagic_dashboards$fn__79162 invoke "automagic_dashboards.clj" 121]
[compojure.core$wrap_response$fn__31926 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__31910 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__31915 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__31919 invoke "core.clj" 151]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__31919 invoke "core.clj" 152]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[metabase.server.middleware.auth$enforce_authentication$fn__71006 invoke "auth.clj" 14]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[compojure.core$make_context$handler__31966 invoke "core.clj" 289]
[compojure.core$make_context$fn__31970 invoke "core.clj" 299]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 199]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 199]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 199]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[metabase.api.routes$fn__80483$fn__80484 invoke "routes.clj" 54]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 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__80628$fn__80629 doInvoke "routes.clj" 57]
[clojure.lang.RestFn invoke "RestFn.java" 436]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[compojure.core$make_context$handler__31966 invoke "core.clj" 289]
[compojure.core$make_context$fn__31970 invoke "core.clj" 299]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__31919 invoke "core.clj" 152]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__31919 invoke "core.clj" 152]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__31919 invoke "core.clj" 152]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 199]
[compojure.core$routes$fn__31938$f__31939$respond_SINGLEQUOTE___31940 invoke "core.clj" 197]
[compojure.core$make_context$fn__31970 invoke "core.clj" 300]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[compojure.core$routes$fn__31938$f__31939 invoke "core.clj" 198]
[compojure.core$routes$fn__31938 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__78088 invoke "exceptions.clj" 98]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__78085 invoke "exceptions.clj" 86]
[metabase.server.middleware.log$log_api_call$fn__82681$fn__82682$fn__82683 invoke "log.clj" 209]
[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__82681$fn__82682 invoke "log.clj" 201]
[toucan.db$_do_with_call_counting invokeStatic "db.clj" 216]
[toucan.db$_do_with_call_counting invoke "db.clj" 209]
[metabase.server.middleware.log$log_api_call$fn__82681 invoke "log.clj" 200]
[metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__87922 invoke "browser_cookie.clj" 30]
[metabase.server.middleware.security$add_security_headers$fn__59939 invoke "security.clj" 147]
[metabase.server.middleware.json$wrap_json_body$fn__85223 invoke "json.clj" 62]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__85241 invoke "json.clj" 98]
[metabase.server.middleware.offset_paging$handle_paging$fn__59963 invoke "offset_paging.clj" 42]
[ring.middleware.keyword_params$wrap_keyword_params$fn__88189 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__88205 invoke "params.clj" 69]
[metabase.server.middleware.misc$maybe_set_site_url$fn__33937 invoke "misc.clj" 59]
[metabase.server.middleware.session$bind_current_user$fn__45983$fn__45984 invoke "session.clj" 257]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 238]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 230]
[metabase.server.middleware.session$bind_current_user$fn__45983 invoke "session.clj" 256]
[metabase.server.middleware.session$wrap_current_user_info$fn__45970 invoke "session.clj" 216]
[metabase.server.middleware.session$wrap_session_id$fn__45956 invoke "session.clj" 162]
[metabase.server.middleware.auth$wrap_api_key$fn__71014 invoke "auth.clj" 27]
[ring.middleware.cookies$wrap_cookies$fn__88109 invoke "cookies.clj" 216]
[metabase.server.middleware.misc$add_content_type$fn__33920 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__33945 invoke "misc.clj" 76]
[ring.middleware.gzip$wrap_gzip$fn__88151 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__33948 invoke "misc.clj" 93]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__87938 invoke "ssl.clj" 48]
[metabase.server$async_proxy_handler$fn__82454 invoke "server.clj" 71]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[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" 388]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 633]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 380]
[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" 386]
[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
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1",
:message
"(conn=10471) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1",
:sql-exception-chain
["SQLSyntaxErrorException:"
"Message: (conn=10471) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 1' at line 1"
"SQLState: 42000"
"Error Code: 1064"]}

[8815116b-92de-451b-957b-7f6a9ddcdd80] 2021-12-02T11:28:13+01:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 1.6 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (19 idle, 0 queued) (139 total active threads) Queries in flight: 0 (0 queued)

flamber · December 2, 2021, 1:19pm

@peterb Are you an Enterprise customer? Could you reach out via the support email if so?
MySQL is such an unhelpful database sometimes. The errors it provides back to the client just make you scratch your head, wondering where exactly the problem is. I'll need to figure out how to reproduce this first, then I would have to enable debug query logs on MySQL, so I can understand why it's failing.

peterb · December 2, 2021, 1:30pm

Yeah, I'm enterprise. Will send an email, thanks

flamber · December 7, 2021, 4:43pm

Just for reference: https://github.com/metabase/metabase/issues/19241