WheI'm trying to graph my data I'm only given 3 out of my 10 columns to pick from for my X access. How can I pick any column as my X access? 2 of my trackers have a letter in their name with a data type of "type/Text".
How can I pick any column as my X row? This is very odd
Hi @pewpew
Post "Diagnostic Info" from Admin > Troubleshooting, and which database you're querying.
The interesting part would be the response from /api/dataset (redact rows).
Thank you for taking the time to respond @flamber. I only have one database connected to my metabase and are you referring to this diagnostic info?
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "5.4.0-80-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-07-14",
"tag": "v0.40.1",
"branch": "release-x.40.x",
"hash": "ed8f9c8"
},
"settings": {
"report-timezone": null
}
}
}
Here is a some of the logs info. The log file is very long
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.analyze classify-fields Analyzed [*******************************···················] 😏 64% Table 89 'storage.migrations'
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for postgres Database 3 'Private DB Name' (9.9 ms)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.util STARTING: step 'classify-tables' for postgres Database 3 'Private DB Name'
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.analyze classify-tables Analyzed [*************************************·············] 😋 74% Table 67 'storage.buckets'
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.analyze classify-tables Analyzed [******************************************········] 😊 85% Table 78 'public.trak4_devices_reports'
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************************************···] 😍 96% Table 88 'public.tive_saved_locations'
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for postgres Database 3 'Private DB Name' (18.1 ms)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:26:03-05:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 3 'Private DB Name' (688.6 ms)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:31:19-05:00 DEBUG metabase.server.middleware.log GET /api/database 200 4.3 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:32:08-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 28.7 ms (11 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/1 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:32:29-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 51.4 ms (30 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (3 idle, 0 queued) (103 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/1 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:32:34-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 23.9 ms (11 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/1 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:32:41-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 28.1 ms (11 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/1 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:32:50-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 99.1 ms (11 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/1 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:32:54-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 52.0 ms (30 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:35:05-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 47.0 ms (16 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 1 (0 queued); postgres DB 3 connections: 0/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:35:19-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 45.7 ms (30 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:35:49-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 190.1 ms (34 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:44-05:00 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:44-05:00 DEBUG metabase.server.middleware.log POST /api/card 202 [ASYNC: completed] 59.1 ms (17 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (3 idle, 0 queued) (103 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:51-05:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 10.3 ms (5 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:53-05:00 DEBUG metabase.server.middleware.log GET /api/dashboard/4 200 15.2 ms (12 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (105 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 INFO metabase.api.card Question's average execution duration is 209.0 ms; using 'magic' TTL of 2.0 s 💾
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 INFO metabase.query-processor.middleware.cache Query took 119.0 ms to run; minimum for cache eligibility is 60.0 s
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 DEBUG metabase.server.middleware.log POST /api/card/9/query 202 [ASYNC: completed] 171.9 ms (95 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (3 idle, 0 queued) (105 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 INFO metabase.api.card Question's average execution duration is 212.0 ms; using 'magic' TTL of 2.0 s 💾
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 INFO metabase.api.card Question's average execution duration is 446.0 ms; using 'magic' TTL of 4.0 s 💾
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 INFO metabase.api.card Question's average execution duration is 146.0 ms; using 'magic' TTL of 1000.0 ms 💾
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:55-05:00 DEBUG metabase.server.middleware.log GET /api/card/15 200 10.5 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (106 total active threads) Queries in flight: 3 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 INFO metabase.query-processor.middleware.cache Query took 231.0 ms to run; minimum for cache eligibility is 60.0 s
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 DEBUG metabase.server.middleware.log POST /api/card/12/query 202 [ASYNC: completed] 271.6 ms (47 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 2 (0 queued); postgres DB 3 connections: 0/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 INFO metabase.query-processor.middleware.cache Query took 271.0 ms to run; minimum for cache eligibility is 60.0 s
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 DEBUG metabase.server.middleware.log POST /api/card/14/query 202 [ASYNC: completed] 299.0 ms (32 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 1 (0 queued); postgres DB 3 connections: 2/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 INFO metabase.query-processor.middleware.cache Query took 485.0 ms to run; minimum for cache eligibility is 60.0 s
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 DEBUG metabase.server.middleware.log POST /api/card/13/query 202 [ASYNC: completed] 509.7 ms (27 DB calls) App DB connections: 2/15 Jetty threads: 3/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 1/2 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:36:56-05:00 DEBUG metabase.server.middleware.log POST /api/card/15/query 202 [ASYNC: completed] 141.7 ms (36 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/3 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:15-05:00 DEBUG metabase.server.middleware.log POST /api/dashboard/4/cards 200 33.9 ms (15 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:15-05:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/4/cards 200 35.9 ms (30 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:15-05:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/4 200 4.6 ms (8 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:15-05:00 DEBUG metabase.server.middleware.log GET /api/dashboard/4 200 16.9 ms (13 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:19-05:00 DEBUG metabase.server.middleware.log GET /api/card/15 200 5.4 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:21-05:00 DEBUG metabase.server.middleware.log GET /api/alert/question/15 200 985.7 µs (1 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:21-05:00 INFO metabase.api.card Question's average execution duration is 136.0 ms; using 'magic' TTL of 1000.0 ms 💾
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:21-05:00 INFO metabase.query-processor.middleware.cache Query took 158.0 ms to run; minimum for cache eligibility is 60.0 s
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:37:21-05:00 DEBUG metabase.server.middleware.log POST /api/card/15/query 202 [ASYNC: completed] 208.2 ms (36 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/3 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:38:22-05:00 DEBUG metabase.server.middleware.log PUT /api/field/1923 200 4.9 ms (5 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:38:33-05:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 120.9 ms (30 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (3 idle, 0 queued) (104 total active threads) Queries in flight: 0 (0 queued); postgres DB 3 connections: 0/3 (0 threads blocked)
[e1813f11-713d-4593-99b9-920c1e5d6ada] 2021-09-25T13:39:23-05:00 DEBUG metabase.server.middleware.log PUT /api/field/1923 400 1.6 ms (0 DB calls)
{:errors
{:semantic_type
"value may be nil, or if non-nil, value must be a valid field semantic or relation type (keyword or string)."}}
@pewpew
Upgrade to 0.40.5: https://github.com/metabase/metabase/releases/latest
And migrate away from H2 if you're using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
When you run the question, while creating it, the you can see all the raw data in the browser developer Network-tab by clicking the request /api/dataset and viewing the Response data. That's where the interesting parts will be.
I cannot reproduce your problem.