Issue on Model Based Questions when Update

Ziggy · April 28, 2023, 10:02am

Hello, I just found an issue and I am not sure where it comes from.

I am currently using version 0.44.3. I am using a docker container to host the app. While testing updates on my local environment (using my metabase database backup) I noticed the following:

When the version I switch to is 0.45 or newer, I lose the definition of questions based on models. More specifically, the questions on dashboards work well. But when I click on them nothing shows, and when I go to the definition it just shows the Model and no other definition at all.

Is this something already known? What should I do instead of reproducing all my questions from scratch?

Here is what it shows when clicking on the updated version:

Here the correct definition:

and now the definition on updated version:

Luiggi · April 28, 2023, 12:01pm

Please send the frontend logs when you open a question on v45

Ziggy · April 28, 2023, 12:15pm

I'm sorry it is actually version 0.46.1 now.

Is this what you meant?

[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6575 nil] for field "DM_Avg_Employee_KPI.company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6600 nil] for field "DM_Monthly_Employee_KPIs.sum" at [:aggregation :sum]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6574 nil] for field "DM_Avg_Employee_KPI.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6601 {:temporal-unit :month}] for field "DM_Monthly_Employee_KPIs.month_name" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6602 nil] for field "DM_Monthly_Employee_KPIs.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6601 {:temporal-unit :month}] for field "DM_Monthly_Employee_KPIs.month_name" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6603 nil] for field "DM_Monthly_Employee_KPIs.company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6577 nil] for field "DM_Avg_Employee_KPI.avg_employee_estimation" at [:aggregation :sum]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6574 nil] for field "DM_Avg_Employee_KPI.year_name" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6575 nil] for field "DM_Avg_Employee_KPI.company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6574 nil] for field "DM_Avg_Employee_KPI.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6574 nil] for field "DM_Avg_Employee_KPI.year_name" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6577 nil] for field "DM_Avg_Employee_KPI.avg_employee_estimation" at [:aggregation :sum]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6574 nil] for field "DM_Avg_Employee_KPI.year_name" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6574 nil] for field "DM_Avg_Employee_KPI.year_name" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:06+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6053 nil] for field "DM_Employees_Demografics.employee_id" at [:aggregation :distinct]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6046 nil] for field "DM_Employees_Demografics.age_group" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6052 nil] for field "DM_Employees_Demografics.is_employeed" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6051 nil] for field "DM_Employees_Demografics.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6604 nil] for field "DM_Employees_Demografics.active_company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6046 nil] for field "DM_Employees_Demografics.age_group" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6053 nil] for field "DM_Employees_Demografics.employee_id" at [:aggregation :distinct]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6049 nil] for field "DM_Employees_Demografics.gender" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6052 nil] for field "DM_Employees_Demografics.is_employeed" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6051 nil] for field "DM_Employees_Demografics.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6604 nil] for field "DM_Employees_Demografics.active_company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6049 nil] for field "DM_Employees_Demografics.gender" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1565/card/873/query 202 [ASYNC: completed] 485.8 ms (22 DB calls) App DB connections: 4/10 Jetty threads: 4/50 (6 idle, 0 queued) (86 total active threads) Queries in flight: 4 (0 queued); postgres DB 9 connections: 0/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1557/card/863/query 202 [ASYNC: completed] 504.0 ms (23 DB calls) App DB connections: 6/10 Jetty threads: 7/50 (6 idle, 0 queued) (86 total active threads) Queries in flight: 3 (0 queued); postgres DB 9 connections: 2/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1558/card/864/query 202 [ASYNC: completed] 471.1 ms (23 DB calls) App DB connections: 3/10 Jetty threads: 4/50 (6 idle, 0 queued) (86 total active threads) Queries in flight: 5 (0 queued); postgres DB 9 connections: 1/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6053 nil] for field "DM_Employees_Demografics.employee_id" at [:condition :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6050 nil] for field "DM_Employees_Demografics.company" at [:condition :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6101 nil] for field "DM_Employees_Demografics.contract_type" at [:condition :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6052 nil] for field "DM_Employees_Demografics.is_employeed" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1286/card/718/query 202 [ASYNC: completed] 600.9 ms (23 DB calls) App DB connections: 5/10 Jetty threads: 6/50 (6 idle, 0 queued) (86 total active threads) Queries in flight: 2 (0 queued); postgres DB 9 connections: 0/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6051 nil] for field "DM_Employees_Demografics.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6604 nil] for field "DM_Employees_Demografics.active_company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6101 nil] for field "DM_Employees_Demografics.contract_type" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6053 nil] for field "DM_Employees_Demografics.employee_id" at [:aggregation :distinct]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6101 nil] for field "DM_Employees_Demografics.contract_type" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1559/card/866/query 202 [ASYNC: completed] 649.9 ms (23 DB calls) App DB connections: 5/10 Jetty threads: 5/50 (6 idle, 0 queued) (87 total active threads) Queries in flight: 2 (0 queued); postgres DB 9 connections: 1/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6053 nil] for field "DM_Employees_Demografics.employee_id" at [:aggregation :distinct]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6047 nil] for field "DM_Employees_Demografics.education_level" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6052 nil] for field "DM_Employees_Demografics.is_employeed" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6051 nil] for field "DM_Employees_Demografics.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6604 nil] for field "DM_Employees_Demografics.active_company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6047 nil] for field "DM_Employees_Demografics.education_level" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6052 nil] for field "DM_Employees_Demografics.is_employeed" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6604 nil] for field "DM_Employees_Demografics.active_company" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6048 nil] for field "DM_Employees_Demografics.subdepartment" at [:breakout]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6051 nil] for field "DM_Employees_Demografics.year_name" at [:filter :and :=]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6048 nil] for field "DM_Employees_Demografics.subdepartment" at [:order-by :asc]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 WARN metabase.query-processor.middleware.fix-bad-references Bad :field clause [:field 6053 nil] for field "DM_Employees_Demografics.employee_id" at [:aggregation :distinct]: clause should have a :join-alias. Unable to infer an appropriate join. Query may not work as expected.
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1564/card/872/query 202 [ASYNC: completed] 866.8 ms (27 DB calls) App DB connections: 2/10 Jetty threads: 4/50 (6 idle, 0 queued) (88 total active threads) Queries in flight: 2 (0 queued); postgres DB 9 connections: 0/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1288/card/720/query 202 [ASYNC: completed] 425.1 ms (23 DB calls) App DB connections: 2/10 Jetty threads: 4/50 (6 idle, 0 queued) (88 total active threads) Queries in flight: 1 (0 queued); postgres DB 9 connections: 1/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:07+03:00 DEBUG metabase.server.middleware.log POST /api/dashboard/128/dashcard/1287/card/719/query 202 [ASYNC: completed] 477.3 ms (23 DB calls) App DB connections: 1/10 Jetty threads: 4/50 (6 idle, 0 queued) (88 total active threads) Queries in flight: 0 (0 queued); postgres DB 9 connections: 1/5 (0 threads blocked)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:17+03:00 DEBUG metabase.server.middleware.log GET /api/card/718 200 27.7 ms (11 DB calls) App DB connections: 0/10 Jetty threads: 5/50 (5 idle, 0 queued) (87 total active threads) Queries in flight: 0 (0 queued)
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:18+03:00 INFO metabase.api.dataset Source query for this query is Card 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:18+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:18+03:00 INFO metabase.query-processor.middleware.fetch-source-query Trimming trailing comment from card with id 865
[2dc476d9-204c-4bd4-9352-bca42a8de84c] 2023-04-28T15:19:18+03:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 495.1 ms (15 DB calls) App DB connections: 1/10 Jetty threads: 4/50 (5 idle, 0 queued) (88 total active threads) Queries in flight: 0 (0 queued); postgres DB 9 connections: 0/5 (0 threads blocked)

Luiggi · April 28, 2023, 8:42pm

open the browser developer tools and see what's in the console section when you open a question that looks broken

Ziggy · May 2, 2023, 7:40am

Yeah sorry, this makes more sense. The console brings out these 2 errors.

In the link, the full text of error is: "Unable to find node on an unmounted component."

Is this helpful?

TonyC · May 2, 2023, 8:26am

Can you send Admin -> Troubleshooting -> Diagnostic Info

Ziggy · May 2, 2023, 8:33am

Hello, yes this is the info:

{
"browser-info": {
"language": "el-GR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.18+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.18",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.18+10",
"os.name": "Linux",
"os.version": "5.15.90.1-microsoft-standard-WSL2",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"mysql",
"h2",
"postgres",
"sqlserver"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.10 (Debian 13.10-1.pgdg110+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.1"
}
},
"run-mode": "prod",
"version": {
"date": "2023-04-05",
"tag": "v0.46.1",
"branch": "release-x.46.x",
"hash": "12a6e1d"
},
"settings": {
"report-timezone": "Europe/Athens"
}
}
}

Luiggi · May 4, 2023, 12:38pm

seems to me that this is a corruption in the card that leads Metabase to remove many "invalid" MBQL clauses. I think that the only option is to rebuild the card here

Ziggy · May 4, 2023, 12:47pm

Yeah but it seems weird that in some versions is broken and others is not. So I wanted to understand why that is. Maybe I will try to recreate this and narrow the issue to an official bug.

Anyway, thank you for your time.