Unable to save a question

Get Help
1

Hello everyone,

I recently upgraded from v0.36.2 to v0.41.2 (did incremental upgrades). The bug I am facing is I am not able to save a question.

The logs are as follows and don't indicate any error:

[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:45+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 21.4 ms (2 DB calls) App DB connections: 1/10 Jetty threads: 4/50 (19 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:45+05:30 DEBUG metabase.server.middleware.log GET /api/user/current 200 107.7 ms (3 DB calls) App DB connections: 0/10 Jetty threads: 4/50 (19 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:45+05:30 DEBUG metabase.server.middleware.log GET /api/database 200 81.1 ms (3 DB calls) App DB connections: 0/10 Jetty threads: 4/50 (18 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:45+05:30 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 123.7 ms (5 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (19 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:47+05:30 DEBUG metabase.server.middleware.log GET /api/collection/root 200 10.9 ms (2 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:47+05:30 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 104.8 ms (5 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:52+05:30 DEBUG metabase.server.middleware.log GET /api/native-query-snippet 200 61.6 ms (2 DB calls) App DB connections: 1/10 Jetty threads: 4/50 (19 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:52+05:30 DEBUG metabase.server.middleware.log GET /api/collection 200 67.8 ms (3 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (19 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:57+05:30 DEBUG metabase.server.middleware.log GET /api/database/64/autocomplete_suggestions 200 296.5 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:58+05:30 DEBUG metabase.server.middleware.log GET /api/database/64/autocomplete_suggestions 200 131.5 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:43:59+05:30 DEBUG metabase.server.middleware.log GET /api/database/64/autocomplete_suggestions 200 218.1 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (19 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:44:01+05:30 DEBUG metabase.server.middleware.log GET /api/database/64/autocomplete_suggestions 200 182.8 ms (6 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:44:02+05:30 DEBUG metabase.server.middleware.log GET /api/database/64/autocomplete_suggestions 200 82.7 ms (5 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (84 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:44:06+05:30 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 104.0 ms (4 DB calls) App DB connections: 1/10 Jetty threads: 2/50 (20 idle, 0 queued) (86 total active threads) Queries in flight: 1 (0 queued); postgres DB 64 connections: 0/1 (0 threads blocked)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:44:08+05:30 DEBUG metabase.server.middleware.log GET /api/collection 200 36.6 ms (3 DB calls) App DB connections: 0/10 Jetty threads: 3/50 (20 idle, 0 queued) (86 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:44:29+05:30 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:04+05:30 INFO metabase.api.card Card results metadata passed in to API is VALID. Thanks!
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:33+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 8.6 ms (2 DB calls) App DB connections: 3/10 Jetty threads: 4/50 (18 idle, 0 queued) (85 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:33+05:30 DEBUG metabase.server.middleware.log GET /api/user/current 200 16.4 ms (3 DB calls) App DB connections: 2/10 Jetty threads: 3/50 (18 idle, 0 queued) (85 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:34+05:30 DEBUG metabase.server.middleware.log GET /api/database 200 21.5 ms (3 DB calls) App DB connections: 3/10 Jetty threads: 4/50 (18 idle, 0 queued) (85 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:34+05:30 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 28.1 ms (4 DB calls) App DB connections: 2/10 Jetty threads: 3/50 (18 idle, 0 queued) (85 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:35+05:30 DEBUG metabase.server.middleware.log GET /api/collection/root 200 24.7 ms (2 DB calls) App DB connections: 2/10 Jetty threads: 3/50 (18 idle, 0 queued) (85 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:37+05:30 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 40.3 ms (5 DB calls) App DB connections: 2/10 Jetty threads: 3/50 (19 idle, 0 queued) (85 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:41+05:30 DEBUG metabase.server.middleware.log GET /api/setting 200 1.1 ms (0 DB calls) App DB connections: 3/10 Jetty threads: 4/50 (18 idle, 0 queued) (86 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:41+05:30 DEBUG metabase.server.middleware.log GET /api/session/properties 200 9.6 ms (2 DB calls) App DB connections: 3/10 Jetty threads: 4/50 (18 idle, 0 queued) (86 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:43+05:30 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 3.7 ms (1 DB calls) App DB connections: 3/10 Jetty threads: 4/50 (17 idle, 0 queued) (86 total active threads) Queries in flight: 0 (0 queued)
[22c32d3f-4709-4228-8ccd-073059b1d7a8] 2021-12-12T16:45:43+05:30 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 83.9 ms (11 DB calls) App DB connections: 2/10 Jetty threads: 3/50 (18 idle, 0 queued) (86 total active threads) Queries in flight: 0 (0 queued)

When I check the network call made by clicking "Save" for saving a question, I get a 202 response. There's no error message even after waiting for a long time but the question doesn't get saved.

Another thing that I noticed was that on searching for the question, I can see the question in the search results but when I click on it, it just loads forever and after some time, it displays the message "Something went wrong".

I tried looking at questions that basically ask the same question but none of the answers seemed to work for me.

Thank you for taking the time to read this and please let me know if I need to share something else.

I am using the Metabase Open source version, build an image and then run the container.

2

Hi @pvij_mfine
Post "Diagnostic Info" from Admin > Troubleshooting.

3

Hey @flamber, thank you for responding. I have posted the logs above. Do you want something else too?

Thanks,
Prabhatika

4

@pvij_mfine I'm asking for "Diagnostic Info", not the log.

5

I am sorry, here is the diagnostic info:

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.55 Safari/537.36",
    "vendor": "Google 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.181-140.257.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "Asia/Calcutta"
  },
  "metabase-info": {
    "databases": [
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.12"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-12-06",
      "tag": "v0.41.3-SNAPSHOT",
      "branch": "dev",
      "hash": "96aaf2e"
    },
    "settings": {
      "report-timezone": "Asia/Calcutta"
    }
  }
}
6

@pvij_mfine So try with the latest official release, since I have absolutely no idea which changes you have made.
And if you have some cache/WAF/etc, then disable that:
https://www.metabase.com/docs/latest/troubleshooting-guide/proxies.html

7

Understood, will try that and let you know. Thank you for your response.