Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-45739

Loading documents via console Documents tab hangs Chrome

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • 7.0.0-Beta1
    • UI
    • None
    • Untriaged
    • Windows 64-bit
    • 1
    • Unknown

    Description

      I have 30 documents, each ~180k.

      If I try to fetch more than ~5 such documents via the Documents tab, (10 is the default in chrome) chrome hangs.

      I can retrieve ALL 30 documents from the Query tab in around ~50ms with no problem whatsoever, using this simple query:

      SELECT dev.* FROM dev WHERE type='form'

      Only the Documents tab fails. 

      I wonder if this has something to do with the query that the Documents tab generates on my behalf:

      `select meta().id from `dev`.`_default`.`_default` data where type='form' order by meta().id limit 10 offset 0`

      I'm not using a 'scope' or a 'collection'. Nor do I want to.

      These documents aren't very big.  I have 18GB of memory assigned to the bucket with only 118MB in use. I'm retrieving documents where type='form'. I have a GSI on 'type'.

      Furthermore, because the console automatically caches the current search in the 'documents' tab, as soon as I've accidentally performed a query that will melt chrome (e.g. fetching 10 or more of said documents), the console caches the result and I can no longer EVER open the console to the documents tab again, because it will re-crash, then re-crash, then re-crash. The ONLY way I can recover is to manually clear chrome browsing data.

      At the very least, I would expect couchbase to attempt to detect a previous hang and clear the current document search that caused it, so that you have some hope of returning to the console again.

      Attachments

        1. document.json
          87 kB
        2. documents.png
          documents.png
          28 kB
        3. hang.png
          hang.png
          5 kB
        4. query.png
          query.png
          19 kB
        5. Screenshot 2021-04-21 at 9.28.19 PM.png
          Screenshot 2021-04-21 at 9.28.19 PM.png
          251 kB
        For Gerrit Dashboard: MB-45739
        # Subject Branch Project Status CR V

        Activity

          People

            eben Eben Haber
            rmirabelle Robert Mirabelle
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty