Query editor does not expand/collapse for queries with multiple join

Hello

I created a query that required 3 joins using the Advanced Question panel.

It runs perfectly but when I click on the "Show Editor" button to try to further modify it, it does not open up completely. See screenshot below:

Is there something I can do on the browser to fix this?

Thanks so much.

Hi @swapneelrane
Post "Diagnostic Info" from Admin > Troubleshooting.
Is it completely stuck in that position, or does it slowly open? Sounds like you're seeing this issue:
https://github.com/metabase/metabase/issues/12378 - upvote by clicking :+1: on the first post

Thanks @flamber. It is completely stuck. I need to manually scroll up/down for it to open up further.

Here is the diagnostic info:

{
  "browser-info": {
    "language": "en-GB",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 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.8.0-1032-gcp",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "sqlserver",
      "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-08-03",
      "tag": "v0.40.2",
      "branch": "release-x.40.x",
      "hash": "b884d29"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

@swapneelrane No matter what I do, I cannot make it stuck, when I try to create a question similar to yours. Can you try either in Incognito-mode, so there are no extensions, or another browser?
Also, check your Chrome developer console for any errors, which are specific to this question and you don't see on other questions, which does not have problems with opening the Notebook editor.

1 Like

Hi @flamber thanks so much for this.

I was originally accessing Metabase on Chromium. So, I spent the last couple of days testing this issue on Chrome and Firefox, in normal as well as incognito mode, and found that Google Chrome works best (in either mode).

However, the same complex questions still get stuck, and I end up using one tab to view and another to just edit & save the question.

Here is my diagnostic info. If you provide an email id, I can share screen recording of this issue as well.

{
  "browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 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.8.0-1032-gcp",
"user.language": "en",
"user.timezone": "GMT"
  },
  "metabase-info": {
"databases": [
  "h2",
  "sqlserver",
  "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-08-03",
  "tag": "v0.40.2",
  "branch": "release-x.40.x",
  "hash": "b884d29"
},
"settings": {
  "report-timezone": null
}
  }
}

@swapneelrane
Do you see any errors in the Chrome DevTools Console?
So you're saying that it only happens for specific complex questions? Can you see what could be the trigger compared to a slightly less complex question, which does not cause this behavior?