Sorry if it seems trivial. Quite new to metabase.
The query below returns “No results! This may be the answer you’re looking for. If not, try removing or changing your filters to make them less specific.”
[{
“$match”: {
“_id”: “1200”
}
}]
Log:
tags {}},
:parameters [],
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-59, -88, -46, 12, -76, 31, 93, 98, 61, -65, 116, 16, 90, 5, -6, 67, -117, 98, 8, -30, 22, -95, 35, 9, -126, -111, 82, 107, -38, 88, -72, -16]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:cause {:class org.bson.BsonInvalidOperationException, :error “readStartArray can only be called when CurrentBSONType is ARRAY, not when CurrentBSONType is DOCUMENT.”},
:error_type :invalid-query,
:ex-data {:type :invalid-query, :query “{\r\n\t”$match": {\r\n\t\t"_id": “5ddb79b59158ef53bfd684a7”\r\n\t}\r\n}"}}
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:01+05:30 DEBUG metabase.middleware.log POST /api/dataset 200 [ASYNC: completed] 305.0 ms (10 DB calls) Jetty threads: 3/50 (3 idle, 0 queued) (47 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:12+05:30 DEBUG metabase.middleware.log POST /api/dataset 200 [ASYNC: completed] 58.4 ms (10 DB calls) Jetty threads: 3/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/user/current 200 5.7 ms (3 DB calls) Jetty threads: 5/50 (2 idle, 0 queued) (49 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/session/properties 200 14.8 ms (1 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (50 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/database 200 9.2 ms (3 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/session/properties 200 5.2 ms (1 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/setting 200 1.4 ms (0 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/setting 200 1.7 ms (0 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:29+05:30 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 18.4 ms (11 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:32+05:30 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 3.4 ms (1 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0
[d2122123-69aa-4a59-828b-5b06df70a6eb] 2019-12-31T12:44:33+05:30 DEBUG metabase.middleware.log GET /api/task/info 200 9.4 ms (0 DB calls) Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0